I have a form with a couple of calculated fields.
I want to put some code into the 'Form-Load' event to set various
object states on the form, depending on the value of these fields.
The problem is that the calculated fields are blank for a split second

I am fairly novice at VB and access in particular and I am having
problems trying store a date into database field.
This is the scenario I am faced with.
I want to when click on a pause button and store the current date time

Hello, I am fighting a losing battle with Access's Image control. At one
time it was able to load TIF images that my users were viewing. I had
written two totally different Access apps. Basically on_Current event
triggers updating of the image control to a specific field in an ...

I've been trying to install the runtime environment for Access 97 on
the Citrix server for two access 97 applications that will be remotely
used by several users. Now here's the problem, I keep getting the
error "Unable to find DLL-file vba322 for Visual basic for

How do I find the dates of the Sunday and Saturday of a week if I have the
week number of a selected year?
Thanks!
Jerry

Access 2000
I have a text field that data was imported into.  Now I have a field
that has SSN's in different formats. (123-45-6789 and 123456789)
What I would like to do is to update the field removing all "-".

My first time to this group so please be kind.
Anyway I have this questionnaire that has two parts (2 tables).  I
created a form  for each of the tables and I am trying to make it so
that when I go to the other form I would go directly to the

I am trying to link many Excel files into a database with no luck.
Here is the code:
'==============================================
Sub LinkExcelFiles()

In Access 2002, I create a query with parameters that prompts for Start and
End Time, the data is in SQL 2000, the field is defined as a datetime field
and the data in that field is only time, i.e. 17:34:27, it always returns
zero rows.  Any help would be much appreciated.  ...

I'm querying a Mas90 db via ADO in Access.
The following SQL gives me the error "Invalid Operand for Operator: ="
"SELECT * from GL_DetailPosting where PostingDate >= '#01/01/2004#'"
These other queries work just fine, and they return valid data in the

I have WindowsXP Pro and saw somewhere that it contains IIS whereby if it is
installed, ASP pages can be run locally. I would appreciate any information
anyone can provide regarding this and what it takes to run ASP pages
locally.

I have had an application in MSAccess 2k for about year now without issues
until recently. My users were using it in W98 without issue, but recently
moved
to WindowsXP and now are getting an error. It is with the standard image

This is only happening to a couple of our clients.  We have to have
them e-mail us their data.  Then we do a compact and repair and e-mail
it back to them. Then they are fine.
The one that it happens to the most is using our application on a

FYI,
Using DLookup("ResultsField","Pass-thru query") consumes 2 SEQUENCE numbers
each time it's called.
Anyone know why?

I have a query that pulls data for the month, using the Month End Date
from a form (user enters) as criteria.  It works.  I want to use the
same query to pull "month to date" data, on a weekly basis.  So, for
week 1, it would only show the first 7 days; week 2 the first 14 days,