I have a purchase order form, when Items are received, they are 'posted';
   Dim db As DAO.Database
   Dim rs As DAO.Recordset
   Set db = CurrentDb

For some reason, this simple thing is getting me.  I have a form that a user
will type an account # in a text box in then click a button to open a new
form.  It is an unbound text box with no calculations on it or anything.  If
it is empty/blank/null, then I want a message box to ...

I often want to save user-input parameters between runs, but Access seems to
make this much more difficult than it should be, so I wonder if I'm doing it
wrong.
I can't get the right behaviour from the form, which contains 2 Text Boxes

I've been using the functions recommended here for browsing directories and
selecting files, etc. I need the same but I only need the user to select a
directory they need some files created in.
Any help greatly appricaited.

I am trying to populate a combo box using vba?  Can anyone help direct me in
the right direction?
Thanks

I am written a procedure that imports .txt file using transfertext method in
VBA.
These.txt files originally comes in .res file format.
I would like to change the format from access.

I have it passing one line item from my multi-select capable listbox, but I
do not know how to code the linkcriteria to pass multiple selected lines to
the continuous form.  I really need to be able to pass multiple lines.  I
really hope someone can help b/c this is precisely ...

I have to run queries as soon as i open aceess DB tht i have developed.
I could run these queries, either when it open up or when the DB closes.
What is the even tthat i have to use to perform this?
Thanks

On my report I am showing the totals by Target and then by priority.  How can
I get the priority to subtotal within the target? Priorities are either 0, 1,
2 or 3.

Hey Folks!
I'm hoping you can help me out. I've spent a few hours on this and I
just do not have the knowledge to complete this. It is a simple
snippet from SQL that I need to translate to VBA in Access give me

I have written an Access procedure that retrieves a XML table and saves it
as a .csv.  This is then imported into my database with the transfertext
method. All is well so far.
The problem is that within the data retrieved from the web it returns a N/A

Acc03/WinXp
I am using an input box for a user to enter in a date.  The variable is
defined as a date field, but I'm guessing that InputBox automatically reads
as string.  I would like to verify that the information entered by the user

I have a table with a field type of date/time. A date is entered into by the
user in the form, but when I look in the table it has somehow converted to a
time 12:00AM.  When I scroll through the table or move the mouse from side to
side the date reappears briefly and then ...

How can i find a value from a field in the last record entered in my table?
I use Dlast function but it doesn't update if i enter a new record. I used
the following code in a label on a form. it worked the first time i created
the code but dont update when i enter a new record. ...

Corrupted Access 97 Database
This problem I haven’t seen before
The database opens fine (except for an index error) for the uses and all
reports and forms function well