I have an order form with a subform for the order line items.
I have a second subform that has all items we've ever ordered from the
supplier of the current order.  (linked by supplier)  I have a place to put
order quantities in this listing.  

I have a database with tables: tblProviderData, tblClaimData, tblRRC.
Forms are: frmLoginClaim, frmAddClaim, frmAddProvider
Relationships are:
tblProviderData.ProviderID -> tblClaimData.ClaimProvID

I have three boolean (yes/no) fields in my table to indicate how an order
was submitted, by phone and/or fax and/or email. I have also added a text
field in the table called submitted. In my form, I want build a text string
into the "submitted" field with the words "phone " ...

have this data access database which I modifed.
In the Search form code I need it to modify code so, it look and match more
then one field. If the record is not in one field then it should go and look
for the second one or third. pl see the code. pl some one hlep me.

I  have a form that contains a subform.  The main form executes a parameter
query linked to the "After Update" Event.  The query runs against a table
that contains order number, name, office, date, and a primary key.  The
results of this query populate text boxes on the form.  ...

Hi All,
I need some vba code to run once the form is loaded and once the query has
been run so that there is data in a text field. Then it will need to run each
time the navigation button is used to change records again. Any ideas?

Morning,
I have been tasked with writing a database which will allow a telesales team
to call up customers about certain promotions e.g. No Smoking.
In the database already is a master list of customers.  Details of the

I am trying to fit the following in code behind a form button:
SELECT tbl_MasterPop_new.[Loan Acct #], tbl_MasterPop_new.PopEnterDt,
tbl_MasterPop_new.Status, "x" AS prevsta, tbl_MasterPop_new.[Buying Center
#], tbl_MasterPop_new.[Division Name], tbl_MasterPop_new.[Region Name],

Does anyone know a way to create an input form which looks and acts like
Microsoft Excel without using Active-X controls?
Thank you,
Sarah

Jesper,
You posted a question about displaying a crosstab query in a subform, but I'm
missing an important piece of information. I can't get it to work based on
you explanation in your post. Here's your post:

In access if a user enters data in Textbox 1 for example and does not enter
data into Textbox 2, how can I code that to say,
"If data is in Txtbox 1 then Txtbox 2 is required to be completed? Is there
a simple code you could help me with?

Every now and then I get an error of record deleted with my application. I
have checked with the users who are logged in and no one has deleted a
record. Has anyone ever dealt with this? I know that it usually happens when
one specific pc is logged in.

Hello.  I have 2 textboxes on a form (StartTime and EndTime) that I need to
calculate out how much time elapsed between them.  This goes into another
textbox to display the difference.  The form's source comes from a query.  In
the qry I added the extra field and the extra field ...

Where am I supposed to post bug reports about rdp or generic windows issues?
I'm invariably redirected here, so blame yourself that it is in the wrong
category. I'm spending too much time on this as it is.
When using Remote Desktop connection in fullscreen mode, the Alt Gr key ...

I do NOT want to use a combo box.
The objective is to display records in a list box and then programmatically
select one (lst.selected(x)) based on contents of a text box.
eg the list box source is a query. The user enters a person's name in a text