I have the following:
Function RunUpdate()
DoCmd.SetWarnings False
Dim dbCurr As DAO.Database

I have a query using table liked using ODBC when i run it
i get password prompt. How can I program it so I don't
have to enter the user ID & password

Hello...I have a Search query that requires user imput(for Keyword(s)) and I
am looking to find a way to make that a stand alone file so that it links to
the tables in the database. The database will be in the same folder as the
standalone file but will be hidden and password ...

Good afternoon,
I am working on controlling a Mail Merge from within MS Access using the
Word references.  I have my main document and my datasource already linked to
it.  What I cannot figure out is how to do the equivalent of Merging to a New

I need help getting started with the Access help file article:"How to display
images from a folder in a form, a report, or a data access page" (In the end
I need to store images in a database):
The help file instructs: "2. Create the following table either in

I need to make my database work until certain date.
After that I need it to close, and doesn't work.
How can I do that?
Thanks

I am getting MSCOMCT2.OCX missing error in MS Access 2002 version software
for the Access 2000 version database.
Where do I find the ActiveX and how do I download and install it?

I know when i start a db i can make it so i close tollbars and and so on
This i can see in tolls/start
But can't i not say if user = "1" then show somthing
and if user ="2" then show me something else

Following the advice from this newsgroup I am trying to test for EOF in the
rstEncounters, I've tried a couple of things, adding another loop statement
which didn't work and an "If" statements in different locations within the
code.

Hi!!
Is there not a way where i can put my dbname in a variable?
Alvin

I am using the Call Shell command in VB code to directly start and open an
Excel file by name.  If the folder name or the filename has a spece in it, it
does not work.  It works fine when there are no spaces.
Does anyone have a suggestion for this command syntax or any other ...

Hi Experts,
Most porbably this had been asked before and my unfortunate luck continues
iwth groups.Yahoo. search engine. Thus I'm again here...
I'm trying to add time beyaond the 24:00 hour format. i.e. past 24, it

Having created a table, is it possible to make the table read only (aside
from using workgroup security)?

I have to produce a report which displays page numbers and totals for
seperate sections in the report. I can detect changes in the header to reset
the page number to 1 for each section but would like to add a total page
count for each section. Any ideas please.

In a VBA routine I want to check a value against a field.validationrule, but
I don't know how to implement this in a generic way (maybe with Eval()?).
Example:
A field called "ABC" with validationrule: "A" or "B" or "C"