I have a form in which I want to put the results of a query. Normally, I'd
create another form using the autoform: datasheet wizard and then attach that
subform in my main form.
However, this time, I have a drop down of a list of tables names and

in running a loading macro, after importing data, it closes the splash form
and opens the main form.
Unfortunately, when it opens the main form, it shows only an empty record
set.  if i close access and reopen, however, voila, the records i've just

i have 2 excel books that are generated from an access program, after a
series of updates.
one book is labelled as 'facility  - followed by name and date
the other is 'non facility - followed by name and date

I need to pass a variable multiple times to an unbound form.
I have a module names modSetPublicVariables with just one statement in it at
this point:
Option Compare Database

I have some VBA coding (in form_current) that sets allowedits for a sub-form
depending on certain conditions.  The coding looks like:
       DDAssigned.Form.AllowEdits = True
where DDAssigned is the control name of the sub-form on the main form.  This

Hi.  I'm very familiar with VBA as it opplies to Excel... Access?  Not so much.
I have some stuff that I'm going to need to do in Excel, but will need to
run a few things through Access along the way.
Here's my start:

I need some help with the following
When I open this DB and click on a label which supposed to open a calendar
form I'm getting the following error message
1. there is no object in the control and it give me 3 option 1. end, 2.

I am using a hidden listbox to pass a resulting value from a SELECT query to
a cell in an Excel spreadsheet when the user opens it.
For one spreadsheet it works perfectly. The values are displayed in the
cell. The code I am using is shown below.

Hello Group!
I am working with a form that has 4 list boxes with multi select
enabled.  The multi selects are used in a query that is coded into the
reports on open event.  The query uses an "IN" statement to filter the

I have one recurring problem with this program.   The user updates an Access
db one record at a time.    I want the records added one at a time to the
Excel sheet.
Right now it does it but it writes over the first record, and always stays

Hello everybody, I'm just a newbie in programming and I need some advices.
What I want to do is to have all fields filled in before to go to a new
record.
The code below appended to AddTitle button changes the backcolor of each

The date is used in a query definition in the "Where..." part.
The code is:
WHERE (((GuestStay.GuestID)=" & lngGuestID & ") AND ((DateDiff(""d"",#" &
dteCancelledDate & "#,[GuestStay.StayCreated])) Between 0 And " & intDays &

Below is Programming code for get the result( Statusitem) for camparison
item1 between item2( if item1 = item2,means "ok" then "not"). This output
must be fill in status item field(column). This problem is wrong code for get
the result.Any body can help me to correct that code ...

How it works is, the user updates only one record in the access db at a
time.  I want that one record to be added to the Excel sheet and then saved.  
There is a runtime error and it stops in  the Else clause on the line:
Set wbk = appExcel.Workbooks.Open("Employees.xls")

What do you make of the following error dialog that appears upon launch of an
application on A2007-runtime.
See example at:
http://ourworld.compuserve.com/homepages/webspace/test/ErrorMessage.jpg