I have a Main form with a subform named Payments.
I have a button on the main form named NewPaymentEntry  that opens a small
popup form to enter a new payment.
There is a "Save" , "Cancel", and "Close" button.

When entering data into a continuous form in A2003, if I click the
"New Record" button on the navigation bar, the form scrolls and places
the new record at the top of the details section ready for data
entry.  The data can then be entered in the usual manner.

Hello, again. What a great resource for us beginners is this forum!
I've got another question...Even though the record selectors and
navigation buttons are removed from a form you can still advance to
the next record in a table after the last field is filled. Does anyone

I'm building a bookings database for trucks that among other things
captures the TruckName, LoadDate, LoadTime, UnloadDate and UnloadTime.
Is there a simple way to prevent double bookings for any particular
truck so that when a new entry is being added, if the LoadDate and

Hi. I have a button - Command9 with the Click event to run this code
on a form called frmSelforDel.
Dim SQL1  As String
DoCmd.SetWarnings False

I know this should be simple, but in a sub-routine that's printing a large
batch of reports, how do you code the routine to look for an escape key to
allow the user to break out?
Thanks!

Experts,
Can you have "Or" allowed in the expression of a IFF Function?
The following function works perfectly:
IIf([Alphabet]="A",0,1)

I created an application in Access 2007.  One of the features required
by the client is to create an .mdb file with one table in it for their
use (strange yes -- I provided alternate solutions, but their IT guy
insists).  I use adox and the following line of code to do this:

I've been trying to optimize the performance of the queries in an
Access 2007 front end that utilizes SQL server for all tables
(linked).  The application runs fine without error.  However, when I
run SQL Server profiler it clearly shows that every entry in a

Hoi,
In een formulier roep ik een module aan. Hoe kan ik de waarde van een
variabele uit de module terughalen naar mijn formulier?
Dank jullie,

I have a user defined type BoatDetails in a standard module
Public Type BoatDetails
   BtID As String
   BtName As String

I am trying to make a golf scorecard.
I have a Course Details table that provides facts about the course,
using the CourseDetailsID as the PK.
My problem is entering in hole distance and par values for a given tee

Wholesale Swatch Diaphane Watches Replica - Fake Swatch Diaphane Watch
Wholesale
Wholesale Replica Watches : http://www.wholesale-watches.org/
Wholesale Swatch Watches Brands : http://www.wholesale-watches.org/swatch-watches.html

I have created a 2002 access database for which I want to lock
specific fields depending on the user. The database contains text,
memo,yes/no, number, date/time and autonumber fields. There are
curently 42 fields and 234 records in the database; the size of the

I'm hoping for some guidance here! The problem is this: I am running Access
97 under Vista, everything works great except I have a macro that does a
mail merge with data from the database into a word document. When I invoke
the mail merge, the open file dialog opens, I select the ...