I am trying to stop a user adding data into a subform before it's
parent record has been created, so I am testing the key field of the
parent to see if there is one:
If Forms![Order Form]![Order Details].Form!PK_Order = "" Then

Typically you use a variable for criteria in a query, but can you use a
variable for a field?
Lets say there are multiple fields in my table, i.e. field1, field2, field3
and so on.  At design time I do not know which field to query because the

I have 4 columns, 2 start date and 2 end dates.  In most cases, both are the
same.  In some, the start date is the same and the end date is different and
vice versa, how can I accurately get the number of days overlap?

I think I've finally got my guys talked into buying a dedicated
PC so we can fool around with SQL Server and see if it offers any
improvements over the various .MDB back ends we have now.
We're talking 20 concurrent users max.   More like 4-6 most of

hi i miss you alot dude

I am trying to create a drop down menu on my entry form but when I do, it
changes the field in all records. How do I make it so that they can be
different on each record?

Greeting,
Is there any code for display msg box in case of wrong input instead of
access warning? For example, if user input letters in field of date and time
property. Of course access gives warning msg, but as you know most of user do

I have a form with a subform on it. The subform is displayed in Datasheet
view. If a user right clicks on a row it allows for the user to insert a new
record or deleted the current record. Is there a way to prevent the user from
deleting the record?

I have a line chart that has a line with positive values and a line with
negative values. The labels of the X-axis are just below the horizontal zero
line, which is not pretty because that's where the 'negative' line also is.
Is it possible to have the X-axis labels show up just ...

I have a Make Table query.  Once this table is created, later in the process,
I would like to add a field to this same table.  I need to do a calculation
using some of the data in other fields within this same table and place the
results in this new field.  Normally, I would ...

I'm currently attempting to use the "DAvg" function to report an average for
a given month of the current year.
 A little background:  The form I'm building looks similar to a calendar
with text boxes under each month's name label.  I would like each text box to

I have an Access 2003 .mdb file of about 20Mb which has extensive VBA code to
help automate the processes. I can use this file in Office 2003 on an XP
system just fine. Put the same file on Vista Business running Office 2003 and
it has no end of troubles trying to start. The file ...

Hi, I was wondering if someone could help me... I need to create a macro or
VB script that selects certain rows from a range of rows in Excel (if not
empty), and then Creates a new entry in Access, and pastes data in line by
line, until all the data is copied.

I have a subform and based on a combo box I want to change the data entry
property.
Ive had a google to look for the property name, however the code below
doesnt work as it cant find the data entry property.

I have a field in access that does calcuations. When I export data along with
this field into excel the exported data is set as text, I need it to be a
value, how can I correct this in access before it hits excel?