I have a continuous form that displays records like so:
Environment        RFC #
========       ====
Production          123456

Sorry
Newish to the Forums and not surte where best to post this question
Looking for a method to automatically acknowledge access prompt boxes from
VBA ... Using a Make Table Query in VBA and dont want the associated popup

Hi. Trying to open a form and display only records where the
ReminderTypeID field is 3 using the DoCmd object and a
Where Condition:
DoCmd.OpenForm "frmReminders", , , "[ReminderTypeID]" = 3

Access XP 02
Whether i switch snap to grid on or off makes absolutely no diff
Doesn't matter what i set GridX & GridY to - makes no diff
I know about the alignment controls but it doesn't help much

Hello --
My app tracks a stock portfolio.
I want to get stock prices from a web source; example finance.yahoo.com
The URL Yahoo creates when I manually enter a symbol is

I have a MS Access 200 application when the user has the front end and the
tables are linked tables to other MS Access databases. When the users open
the front-end, the linked table database has a lock file created - ie, .ldb
The linked tables are created every evening by our ...

access seems to change the format of date fields just for editing e.g
20-Sept-05 (defined format) becomes 20/09/2005 13:07:00 (whilst editing)
it's not the first time i've noticed this strange behaviour (97, 2K & XP) -
at first i figured it was conflict between formats of the main ...

Hi,
I have a form, developed with the help of others on this site, that allows a
user to do the following:
1st, select one of three groups

I have a command button on my Project form which until now had code which
hid all completed projects whenever it was clicked.  The code is:
Me.Filter = "Status <> 'Completed"
This works fine, but now I want it to filter out everything except those

in my a2k app, i have three tables:
IRB, Evaluations and Patients.
the PKs are as follows:
IRB            = IRB Number

I am using the following code.  When run, I get RunTime Error  424:  Object
Required.  The line where the error occurs is:
R.FindFirst "[PropertyAddress] = " & frmPICKLIST!Names
Any help determining what I am missing would be much appreciated.

After a form record has been "Verified" as correct, I created a
DoDairy function to create a log entry in another subform on that form.
When someone edits a verified record, I create a new record in the
Diary subform to track the Field, DateofEdit, User, and any

Gurus,
I am new to Access coding and need help doing this.  I appologize for the
long mail.
What I need to do is when I enter the data in the form and before I go to the

I have a subform that consists of a continuous form that gets its data from
one of two queries.  I want to change the recordsource between queries when
a button on the main form is clicked.  
My onclick code is      

I've got a form with three objects: objExcel (an unbound object frame),
cmdEmail (a command button) and cmdDelete (a command button). The two buttons
are below the object frame.
I want to have the object frame expand down and to the right as the user