I have spent the last eight hours scouring the newsgroup trying to find a
solution, and now I am home I can ask for assistance from you peoples!
I need to filter records with data in one of six fields, dependent on the
option group selection, and then create a report with those ...

I have a data entry form used for gathering payroll info. I have code in the
Before Update event of the form that checks Empl#, BudgetCode, and WorkDates
against a history file to see if that person has already been paid for that
job. I'm OK to that point - my code works. When it ...

Hi! I am working on a form and am a little stuck. I would like it if when the
form was opened an input box appears asking my user to enter a PHCO Class.
The PHCO Classes are letters, A, B, C. I have done this sort of code before
to enter quarters. I know that the "IsNumeric" is ...

I am working on a database and I am trying to get my records to come up right.
When I enter a ss in an unbound combo box if there is a record for that ss
then it will come up. When i push the perform intake button for that same ss
an incorrect record comes up. The record that comes ...

Is there a way to close a pop up form by clicking the same command button
that was used to open it?

Hello again.  I can't get the other problem resolved completely, so I'm
going to try another solution, but still have questions since what I've
tried isn't working.
I want to use a combo box for my user to select the record details they'd

Is is possible to have use a subdatasheet in a form?  
I have a form that opens from a command button in datasheet view.  The query
that it's based on has a subdatasheet embedded and I would like to be able to
do this in the form-datasheet view.

I tried looking for something similar on the site but could not find it.
My problem is when I add a client on one form I can not see the client on a
different form unless I close it and reopen it.  I have tried doing requery
on the got focus event but it didn't help.

I have a combo that lists all items from a table.  
That's fine, but I want to add an item to that list, preferrably at the top.
Is there a way to do this in code without having to add the item to the
source table?

I am trying to change the application title of my project.
This is my code:
Public Sub ChangeProjectTitle()
   Dim obj As Object

I have a form that is opened with a command button and the form opens in a
fully maximized size.      I don't want the form to be fully  maximized,
since it only shows a small amount of information.  Is it possible to cotrol
the size of the form when it opens?

I have 12,000 bank account numbers in sequential order in a sheet. How do I
go through the record and extract the missing account numbers?
Thanks.....

I need to invoke a function(fx) once a user clicks on button1
ex. Application.Worksheetfinction.CountA  -- Is this correct?
Thanks...

Access 2003 has developed a bug where it hangs when I try to open VBA
environment.  This happens in any database including blank ones.  It was
working fine until yesterday :S
Any tips would be great - IT support here is pants.

I am changing a program from an MDB to a Project and having a problem
assigning a value to an Autonumber field:
Dim rst As New ADODB.Recordset
rst.Open "seller", CurrentProject.Connection, adOpenStatic,