Back in Access 2.0 I used to use 'AddToWhere' to build SQL criteria from
disconnected input boxes on a form and set the recordsource property of a
subform to the returned recordset.  This gave me Web like querying before
there was a web.

Does anyone have any information on filling tables via code?  I have an exam
database and am writing a program that builds an exam based on a variety of
user input.
As the user input changes each time the program is run, I have a great deal

The following code gives varying results.  If the PurchaseOrderNumber (which
is a Double) is 1234 or 1234.01 the form opens and the data is displayed.  If
the PurchaseOrderNumber is 1234.02 or greater, the value of the
PurchaseOrderNumber in the PurchaseOrderDetail form is 0.  ...

Good Afternoon,
I have a user that uses a database on a regular basis.  As of today, when
they open the database the Switchboard that normally appears (created by
Switchboard Manager) the following error is recieved.

I believe that I need to create a temp table to hold data at runtime.  Can
someone give me information where I can find out more about temp tables?
background --
a user of my Leave Tracking db can either be a supervisor or an employee.  

How do I add a button to an access tooblar in vba?
Is it possible and how do I do it?
Thanks
Melani

very strange problem:
I upgraded to windows XP and Access XP simultaneously (I have office
xp professional).  When I write VBA code in modules and click save,
often several times, I find frequently that the "saved" code is lost.

when i had my pc cleaned i lost word & excel. have tried to copy files from
disc but cannot. how can i get excel & word back on?

I want to allow multiple users to run my *.mde file on a
terminal server.  However, I use a custom login system
within my database that currently puts the userID in a
*.mde table. With multiple users running different

when i had my pc cleaned i lost word & excel. have tried to copy files from
disc but cannot. how can i get excel & word back on?

Is there a data type fo just one single bit?
The boolean type is 2 bytes long. In a table I can define
a yes/no field which is only 1 bit in data lenght. But is
there a VBA data type for that kind of value?

I am trying to write some code to be able to modify a recordset based on 2
criteria but I'm always getting errors like "no value given for one or more
required parameters".
I have tried different way to find the required recordset but no success.

I have function that set date on date variable that return it by the
function
If no date should be set and i leave the date return value as it was on the
function the function returns 00:00:00 (leagel date on access and not on sql

Hi:
I am thinking to get some images from other folder to my Product Form.
My problem is: my image name is like this: productCode_productName.jpg, such
as: ABC001_super drink 250ml.jpg, or AAF003_ArtAFace Cream 50g.jpg, the

I do open a table by using the docmd.opentable "xyz" command which works fine.
But by opening it, i need to sort the content by column 6, 7 and 8 (named
Subjekt0, Subjekt1, Subjekt2), but can't get it working.
The used command DoCmd.RunCommand acCmdSelectAllRecords sorts by ALL