Re: Using Open Arguments in Access Report

Simple yet effective. perfect, thank you.


Allen Browne wrote:
Split the database.

Place the temp table in the front end.

Since each user has an independent front end, their searches do not
interfere with each other.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<mpfohl@xxxxxxxxxxx> wrote in message
news:1164210899.342017.154790@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On second reading that question still doesn't seem clear so let me try
one more time.

Currently, my database works like this: my search form builds the SQL
based on multiple search criteria chosen by the user. The SQL then
dumps records into a table in my database. The report then opens and
one of the many joins in that report is to that table, thereby limiting
that report to the records found by the form.

However, I want multiple users to be able to use the database at once
so if two users are trying to run a search at the same time it won't
work because there is only one static table. So I want to change this
entire search process into VB code so that multiple searches can run at
once without interfering with each other.

Thanks

.

Relevant Pages

  • Re: Non-descriptive error message
    ... It is the first thing I look for in any database that is going wrong. ... Allen Browne - Microsoft MVP. ... From experience with this kind of corruption, ... The deleted report did not appear when running the suggested query. ...
    (microsoft.public.access.reports)
  • Re: access crashes every time I do this
    ... Does it happen on *any* report in *any* database? ... Allen Browne - Microsoft MVP. ... just a form with 2 subforms and one report. ... >> Windows problem or bad video driver. ...
    (microsoft.public.access.forms)
  • Re: Using OleDbDataAdapter Fill when INNER JOIN specified
    ... To have multiple tables in a ... specified database, fetches the data, and disconnects from the database. ... > database to the report, use a SQL JOIN statement to join the tables ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Multiple Databases
    ... "Allen Browne" wrote in message ... > probably the wrong storage database. ... > compacted it is more than 1gb, then splitting it into multiple mdb files ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Creating a directory
    ... I tried to adapt this code to my database. ... Allen Browne - Microsoft MVP. ... In another report I use the On Format event for the Detail Section to trigger an option to add a border to a field's value "if IsNull" is true or no border if false. ... I tried something similar but there were no events to trigger the VBA code I want to use which would open the second table and find a record/name. ...
    (microsoft.public.access.reports)
Loading