I have inherited an application that was originally developed in Access 2.  I
have converted it to Access 2003.  It works really well except for one form.  
This form can display 2 further forms (not subforms) that are made to
position themselves on top of it when a button is ...

Greetings all,
Is there a way to find a where a function is being called from within a
module? (Other than Ctrl+F which returns nothing)
Can a module be called from another application through and adodb connection?

Is it possible to use Access to automate the extraction of data from a
zipped file (WinZip) into a text file?
Thank you,
Alex

I dont know exactly how to explain this but I'll give it a go. I apologize in
advance.
I have a form where I enter a date range and access goes to another
application and extracts claims where the claim date ranges matches the

I recently started using Access 2003, moving up from Access 97. The one new
behaviour which I dont care for is its prohibition of saving codes stored in
a referenced library. For instance, if I open a module in the local database
which has a function call to a procedure stored in ...

Sorry apparently I hit a keyboard shortcut and sent before I was done
typing.
Here is an excerpt of my sql statement, than my report is generated from.
WHERE (((tblEZPassTolls.TransactionDate) Between [Start Date] And [End

i am designing a database to get monthly and yearly result.The out put
seems as
TOWN YEAR MONTH PARAMETER YEARLYRESULT
A,B,C 2001  2        x        100%(total pass results)

Here is the code I have. The FillArray procedure loads up an array with
values from a Record set on a Tabular form. (Thanks to Carl Colijn for
helping me get the FillArray set up.)
Private Sub FillArray()

I would like to change the absolute path of a linked table in code behind a
button.
I have a linked table named "TestTable" and would like to refresh the link
to C:\test\testdb.mdb

Here is an excerpt of my sql statement, than my report is generated from.
WHERE (((tblEZPassTolls.TransactionDate) Between [Start Date] And [End
Date]) AND ((tblPersonnel.IDSA)=[ID?]));
The Query has thre critera required to make it run.

I have made programm with visual Basic 6 Professional Version
and i have use the  data-object to contact to access 97 tables
I have convert the access97 to access 2003  and
Now i triy to use access 2003 tables with same program (vb6)

I've copied the function recommended to add workdays to a date from the MVPs
website (http://www.mvps.org/access/datetime/date0012.htm) but when I try and
use it in a query I get an error message:
Data type mismatch in criteria expression

I have what is probably a very simple question but I can't seem to make the
windows in the VBA code environment tile the way I want them to.  I've been
using them a certain way all along and now I must have accidentally reset
some switch somewhere because they won't go back to ...

I'm trying to write a procedure and I want to change to small image attached
to this button, when I pass with my mouse over the button."
Thanks

In MS Access2k I'd like to detect when the prinert has finished printing a
report so that I can start a .wav file.
At the moment I am using a timer code but I can only set it for x seconds
which means that depending on the size of the report the .wav file can start