I have a query that calls a user defined function in Access.
e.g. GetCurrentBatchID (gets the current batch ID).
Query1
Select getcurrentbatchID(), items, destination FROM Tbl

Is there anyway with vb code to send a popup message to my desktop to inform
me of a soon to be birthday without having opened my database.

I am trying to call the excel function linest from VB using automation.
the call
Slope1 =
Excel.WorksheetFunction.Index(Excel.WorksheetFunction.LinEst(y, x),1)

Hi to all,
I am facing a problem that when everyone try to access my database via a
hyperlink, it shows a publisher not defined and will not open!!!
when I open the database directly and go to database properties under File

Today i tried to run an access program and realized that all modules and
references are missing!
I checked also my backup (two weeks old) and the happens also to this copy.
It's a .mdb file and thousands lines of code written there.

Please help!
I want to create a insert button on a form so that the user can open a
dialog box and select the picture stores on a file, and insert that picture
on the form which shows that record. Just like when we click the insert on

Thanks for taking the time to read my question.
Just wondering what the best way to have a calculator on a for is.
I'd like it to work just like a regular calculator.  I'd like it to use the
* / + - buttons on the keyboard too if possible.

I am soo Stuck!
A nubie question: (I haven't programmed since VB 3)
I need to have 2 or more users cycle through records in a table. Starting at
the first record until they reach the end Without Opening the same record.

I have to migrate data from a spreadsheet into database.
When I link the spreadsheet into my database for processing, one of the
fields (which Access defines as Number/Double) contains spaces in some
records. This field displays #Num in those records.

I wrote a function to look thru all tables and queries in a db to find a
specified string.  I used keywords: TableDefs and: QueryDefs in my code.  I
want to create a similar function to look through report definititons.  Is
this possible?  I see no: ReportDefs variable......

I have two sets of databases: Production and Test.  Production is on the
server and the Test data is on my c:\ drive.
The Problem: Linking the tables.
Right now I am using the table link manager to change the links.

I want to import into 'Outlook Contacts' records from Access. I found sample
code in http://support.microsoft.com/?kbid=170320
I use a Dutch version of Access2002 and Outlook 2002. Problem is: where can
I find the names of the built-in Outlook fields (I found two field names in

Who know about this problem cause by? Thanks for your help.
My VBA codes which open an Access Report window. When this program runs
in my computer, everything is okey. But, copy this program to other
computer, when it runs, the report window is opened, but it can't be

I am writing a database that transmits information to a report for leases, I
would like to print only the current page (in the form) that I am using from
the report, but everytime I click the "print report" button, the entire
report (every page in it) prints out.  what settings ...

How would I write an SQL statement that would find the value (from a variable
strCheck) in a table (tblNames) in field named [Value]? and if that exists
then GoTo GetMeOut?
Thank you.