I have a subform that lists guests attached to a reservation using
CONTINUOUS view. Guests are selected using a comboBox. Since a guests
SHOULD NOT be listed twice on a reservation, I want to put something
together where if the guest is selected, the user is advised that the

Hi, Guys
I got thousands of same format Excel files which needed to be imported into  
access, is there a code or tool can help me out? u quick response is trully
appreciated.

i have a process where multiple action queries are run sequentially to
generate data for a report, including some make-table queries. this process
is used repetitively, so the tables that are created by the make-table
queries already exist after the first "run".

Hi everyone....
I have an application deployed with front-end / back-end, and have periodic
need to replace front-end with a new version.  Sometimes, this new version
requires some structure changes to the back-end (add a field to an existing

I am using findfirst to locate records within my recordset. I would like the
record to be found only if the whole word exactly matches any word within the
sentence being searched. i.e.
String “Johnson Foodstore” returns false when searching for “John” but

I am not family with foxpro. I have tried to export foxpro db to xls before,
i found a field is minutes format. all this fields data cannot export to xls.
then how can i export foxpro data completely to access mdb. Thank you very
much

I am recieving the following error when executing the following code in a
report:
Run-time error '2427':
You entered an expression that has no value.

Can anyone explain the difference between these and when to use each,
particularly in conditional statements?

I have Access 2003 mdb file with linked data from SQL Server 2000.  I have
created a stored procedure on the SQL server that manages role memebership
and data access.  I am looking for help/article to assist me in creating the
connection string to the SQL Server and execute the ...

I have data in a field e.g.
1
3
0

I have a LongInt field in all my tables called "SetupID"
I am looking for a function that will go through all my tables, except the
system tables, and reset the "SetupID" to the "SetupID" value in the
tblMyCompanyInformation table

I saw an article recently that described how to programmatically check to
see if the users version of Access had then necessary VBA references
(Microsoft Office 10.0 Object Library etc) If the reference was not found,
the code would add it to the users References on startup.

I had posted this before but didn't get help.
Somebody had helped me put together a VB code to add some textboxes from a
form to a table. Anyway, I get an error message when the code reaches the
a point refering to OpenRecordset; a message pops up and says "Item not

the f5 or command in the immediate window pops the dialog to enter the macro
to run... if I create a macro, and a function to call from the macro, where
the function then invokes the sub proc I want to step through, that macro is
still not found.  office access 2003 sp1;  The ...

I have report that summaizes rolling periods.  It is based on a Crosstab
query, but some label captions and rowsource properties of fields change as
the column headings potentially change each time the report is run.
So I am using DAO statements on the Open event of the report to ...