My app is hanging up after the last line below.  How do I retrieve the value
for 'BlockUser' in table 'tblBlockuser' in the database 'LogKeeper'?  I'm
using Access 2002 SP3.  The database is located on a LAN server.
   Dim MyDB As DAO.Database

I am wondering if there is a case statement similiar used in Visual Basic
that I can use instead of using IIf statment.  Any tips will be appreciated.
Thank you.

Access 97
I have three Access programs (MDE) running on a variety of PC's
throughout the office.
In one case all three are running on one PC.

Hi;
Do i have to necessarily compile my program before distributing it?What
benefit it has for my program?
Thank you.

I asked this question about 12 months ago, but I cannot find a copy of it
here and I have not located it in the archives.  I want to display the
parameter from a query in the form header of the Form driven by the query.
The parameter is [Type Arrival Date].

I’d like to combine the following 2 buttons into 1 button. In addition to
that, I’d like it to NOT open the form (in the Short Sheet Compare Button) if
there is not match. That is, save the record and open the form if only there
is a match. The purpose of the save function is to ...

I have a datasheet form that has a text box named txtBalance.  I would like
the txtBalance default value in a new record to be the value entered in
txtBalance of the prior record.  Thanks in advance for your help!

I have a project form which shows a record for each project.  On that form I
have a subform which shows, in continuous form view,  all the tasks for each
project.  I have a command button which shows up beside each task (ie. if
there are two tasks per project record, then there ...

I have a command button on a form, cmdComments, and it has the letter "i" on
it.  This command button opens a Comments popup form and allows the user to
either view or add comments for each record.  The comments field (called
TaskDesc) in the Comments popup form is a field that ...

I have a form with 3 comboboxes that have the folowing for a value list
1st combo is an hour list from 1-12
2nd combo is a minute list from 01-59
(which doesn't want to display right, like 1 instead of 01)

I have a script that works fine when called by itself.  I need to execute it
from within a form or macro.
It places a short cut to a newly created folder on the users desktop.
Here it is--- Any help would be appreciated.

I've not programmed in a few, but I remember that in VB one can use a short
name (e.g. AppPath) to code the file path name for your application
("c:\windows\system").  That way if the program should be moved, let's say to
the network, you don't need to hard code the file path ...

IS there anyway that I can add code to an existing SAVE RECORD button. What
I’d like to add is a way to compare the Work Order: number to the Work Order
number on another table (Short Sheet). If there is no march, no popup
dialogue will appear and it would just save the record. ...

I have a big loop in the OnOpen event of a form.  Inside this loop I want to
change the color of these boxes as the records are processed.  It seems like
when the myControl.BackColor = vbBlue is ran inside the loop it doesn't have
an event to make it change.  The color of the boxes ...

I have a big problem.  I can create Macros, Event Procedures, etc. for error
checking, but I can't seem to get the system to look at each individual field
as I tab through (the very first time).  
If I've typed a character (e.g. a space), then the macros/procedures