I am tryin to prevent new additions in a subform, if the main form has no
record, without success.
Main Form name: "Order"
then

Hi, I got a weird problem:I got a list box with a sql statement as row
source.
If I run the sql statement manually, it shows the values (a list of
names) but if I run it as forms-view the values are blank (but I'm

I have a combo box and a field on a form.  The following code copies the
text in the combo box and pastes it at the end of the field .  This enables
text from the combo box to be continually added to the field.  The code works
fine in earlier versions of Access but in Access 2007 ...

I have a table tbl_Credit_Application_Input that uses text values for
Corporate Name and a DBA/Trade Name columns.  Users have a tendency to
input a name like Subway #34545 in one of the columns.  When I use my
search query to try to pull the row that includes the Subway #34545 as

I have an Order form with a subform for the Order Detail.  In the Subform,
the Product ID, Quantity (Square Feet), etc is entered.  Then the next item,
etc. Here's the clitch - When the total square feet is over 100, the pricing
changes  for all the items(starting with 3 or 4), ...

I have in my switchboard a command to maximize the form: docmd.maximize
But this as a problem, this make all other  forms opening in maximized and I
restore one the swtich board also restores.
How can I control this?

I'm using MS Access 2003.
I've created a form that has a function which polls individual computers in
a loop, adding data as it goes along to the database.  The process can take a
long time to complete, and I'd like to have the option to cancel the function

I'm wondering if someone can suggest an efficient way to code the
following:
When entering a person's name in a field, I want it to be intered as
surname,prename (without a space after the comma.

Is it possible to have a sub-from on my main form which lists the contents of
say "table 2" in a datasheet, this way I can see all entries, and then with
in that sub-form double click on one of the entries and have it open up in a
new full form for editing and what not.

I have two fields with dates on my database that I need calculate between:
Field 1 - Date of Referral
Field 2 - Date of Discharge
I need the results to be displayed on a form.

Searched group & found no previous post using this simple method.
Trying to resolve a code problem, I'm trying to lock all controls on a form
On Load, and unlock all for an edit, with a check box.
My below first step is giving errors in AC2003.

I have a combo box with the following Row Source in oder to enter new records:
SELECT tblSubTrades.SubTradeID, tblSubTrades.SubTradeDesc
FROM tblSubTrades
ORDER BY tblSubTrades.SubTradeDesc;

1) The code below run in XP but not in Vista. An error message will pop up
and the program closes.
Me.LinkTo1.SetFocus
DoCmd.RunCommand acCmdInsertHyperlink

I been asked by my employer to create a photo album of all the clients we
have served. There are currently over 7,000 photos in a folder with more
added daily. All the photo are bitmaps. (ie 1234.bmp). There is currently a
form that show the client's photo and their information, ...

I have a subroutine that backs up our database backup before updating it each
day...
       strMyDB = CurrentDb.Name
       strPath = Left(strMyDB, LastInStr(strMyDB, "\"))