I have a form with some fields of names and address on it and the LastName
field is a required field set at table level.
Im having dificulty finding a way to check the forms fields and making sure
the LastName field is filled in before the error message gets thrown up. It

Access 2003.
I've created my own Linked Table manager for use in several of my
applications.  It is running fine when I use Windows authentication, or when
I use a valid userid and password, but when I try to log in with an invalid

The issue:  When I append a new record based on values obtained from a form's
text box and combo box values into an external db table, one field ("Role")
in an existing record in the table is blanked out.  Can someone please share
why this might be happening?  

I am trying to figure out the best work around for running a delete
query from a bound form.
User inputs data into frmProduction bound to the table Production.
This data details items needed to be sent out for repair.

I've completed my own Linked Table Manager wizard, so that the connections I
create to SQL Server and Oracle database on my network don't require a DSN
(DSN-less connections).  This wizard exists in its own mda file, which I have
added as a reference in several of my databases.

I have a continous form control that only displays the results when I click
on it (them). Can someone help me make it so they display permantly.
the name of the control is: txt_Timer_Elapsed
the code for the control is:

Can anyone give the macro overview of how to do the following task.
Have an enrty box in which I can enter a record number, search for that
record and that record be displayed in an exsisting form for editing.
Thanks a bunch

I have a main form (frmAddProd) which contains a tabbed control with 2
pages. Each page contains a subform bound to the main form on fields:
ProductionDate, Dept, and Shift. The subforms (sfmProdOp and
sfmEmpProd) are not directly related to each other though. sfmProdOp

I have done this in the past without an issue, but can't seem to
get it to work on this particular database and I can't figure out
why.
I am running Access 2003.  I have a form (frmConcern) bound

Multi record form, text field enabled NO locked YES.
Produces an #Error.

Please tell me what's wrong with the Where clause in this SQL.  This is in
the OnLoad event of a form to populate a list box.  I've tried every
combination I can think of and either get a prompt for
tblOrders.RemainingQuantity , nothing displayed at all, or all records

How to wite a module to check folder " Report " exist or not.
If it doesn't exist ,then vba create one.
Later I need to keep my access pdf report to this folder
before attach it to my email.

I have a routine that creates a list of e-mails to be sent out, when the list
is completed it then loops through and uses the Docmd.sendObject to send each
mail (Access 2000). This used to work very well and I have not had any
problem with it until about 3 months ago when it ...

I write the following in the Control Source property of a form text box, but
get a message that the syntax is wrong:
=DateDiff("d", date, [SidsteOfStatusændringDato])
What am I doing wrong?

Hello all...
I have a edit record form, which was working, until I added record
navigation buttons to the form (memberinfo) that has the edit record button
that opens it.