I have a form where I am adding records. There are two boxes where one has
to put the lineitemnumber and another box where one has to put the
description. Unless the above two boxes are filled in the Add command box
need to be disabled. Now, the problem is after adding one record ...

I am trying to figure out what is the best way to hide/show a command button
based on the current user priviledges. Basically all I have so far is a
module that captures the NT id and inserts it into a Users table.
I am not sure how and where to place the rest of the code, if the ...

I have asked this before, but I never got an answere. I guess because I was
not very clear.
I have a form that has plain text boxes and combo boxes. I enter data in the
form and save them and then make changes to them later. For example I enter

Me.[form subform].top =Me.[form subform].top - 0
run-time error 2100
the control or subform control is too large for tis location
Can anybody give me an idea of wat is going wrong?

how to convert the extension .mdb to .mde and what's the use of this?

I have tables with this fields:
expenses_control: expenses_code, profit_center, date, value.
date: date
profit_center: profit_center_code, profit_center_description

I have an Access 2002 application that uses the FileSearch object to search
the Excel files within a folder for a given text string. Something like
this:
   With FileSearch

I am having trouble figuring out how to accomplish the following in Access
2003:
I have two queries as the basis for my form.
1. One with a set of baseball teams in a league. Each record is one team,

There is a situation in which the client uses 2 fields in the table as the
primary key.  In a search field (Combo59) the 2 fields are concatenated
together and called FileNumber thru a query.  I get a type mismatch error in
the after update event of the combobox.  Below is the ...

I have played around with Terry Kreft's API clipboard function.
I set it up so that on load of the form, if the clipboard = 0, it sets some
text in the clipboard automatically.  But if I start in word, copy some text,
then load the Access form, the function still sets the text, ...

I am using a notinlist event to open another form in dialog mode to force
the user to make a new entry then update the cbo.
To simplify the user's life i would like to transfer the NewData value into
the newly opened dialog form but the code pauses as soon as the form is

Is there a way to determine which form had the focus before the current one?
Daniel P

Can someone tell me how to identify a field on a subform using code?  I am
trying to create a routine that, when a customer is entered into the main
form and they are not in the list, the subform will accept a new entry.  
Currently I know that when specifying field names on a ...

Here's the table structure...
dbo_IMITMIDX_SQL
item_no
item_desc_1

I am having a bit of trouble trying to get a calculation to work on my form.
Here is what I am using:
Private Sub DaysLeft_Click()
If Me.DaysLeft = "Full" Then