I am using a VB procedure to ensure that all the fields in a form are
populated before a save/close action is allowed.  I'm using code like this:
If IsNull([First Name]) Then _
       MissingFields = MissingFields & CRLF & "First Name"

I have 2 tables, TblOrg and TblQty joined in a one to many.
I have a main form "FrmSignin" with a subform "FrmSignIn subform" displaying
related records.  From the main form's "Add New Record" how can I not save
the main form until data is entered into the subform. I've looked at

I have a form where a series of buttons are being used to display underlying
information realting to appointements.
I've used the tag, and status bar text to hold data about each appointment
using mousemove to change the caption.

I have always had trouble with this one.  Almost every database I have
created needed the Reports to look up a certain date range, Just need a
little help.
Joel

I have created a form (frmDesignInfo) that I use as a reference while I'm
designing other forms. It is based on simple calculations such as adding the
top value and the height to give me the bottom y coordinate of a control.
At the moment, I have to copy and paste the top ...

I have an AutoExec macro in an MDB file, which simply does a RunCode of a
function that checks if linked tables are OK.  It works, but no matter what
I do, the debugger always comes up in break mode when it gets to the first
line of the function code.  There is definitely no ...

I don't know if this is the forum where I should post this question but I'll
ask the question and hope for some advice.
I have developed an application in MS Access there is an increasing problem
of record locking issues creeping up. I have one table which two people add

Is there a way to right justify a field in a listbox.  I have a field that is
a number , standard , 2 decimals and it looks awkward with being left
justified.
Here is the code for the listbox:  It is the Amount field I am working with.

I'm inserting data into a table and it doesn't seem to be going in, I
think my Syntax is wrong....any help appreciated.
Private Sub List1_Click()
Forms!AddItems!Text22 = Me.List1.Column(0)

I want to display the result on a form when i run query in access.
Actually I am taking input from user on the first form and the pass the
values to the query and then get the values for specific fields based on that
input. And I want to display that result on the second form in ...

In a continuous form, how do I change the color of the field background on
the current record, and then reset it when I move to another record.
Thank you in advance.
Mark

what is the code to go to the last record (docmd) what ?

I'm trying to build up my own code and I need to be able to identify last
Wednesday, next Tuesday, that sort of thing. I believe the following
identifies last Wednesday,  but I don't really understand how it works:
DateAdd("d", 1 - Weekday(Date, vbWednesday), Date)

I have a form with two txtboxes and a subform.
The txtboxes each represent a start_date and end_date
The subform has payments made.
I want to filter the subform to show payments made between the

I have a basic scheduling application.  It uses a start date and a finish
date.  I can copy schedules to new projects and can push back or up dates,
but after I copy a schedule template to a new schedule I want to be able to
extend the finish date if a weekend creeps in... ...