My little access 2k prog should be able to exchange data between 2
standalone pcs placed at different locations.  I thought that exporting the
data to a number of text files would be the best way to handle it.
I've tried a macro using MS-DOS text .... but it has headers in it ... ...

I have a main form and a sub form that are currently linked as follows
Master: combo box 1st column (the bound column)
Child : OrderNo
The combo box is called cboOrder.

I have a networked application that links to another program's data files and
appends updated information into my networked Access application. This
networked application is split. The problem I am having is suddenly when
running Append Queries I now get an error "Invalid ...

I downloaded a sample database "A2kTooltipver34.zip" from Stephen Lebans web
site at http://www.lebans.com that demonstrates how to create tool tips on a
form.
Everything works great, but I would like to keep the tool tip visible until

I have a sql server 2k database that I want various apps to be able to link
to. Is it ok for multiple apps to connect a couple of ODBC sources each ?
cheers,
Adam

Well, I've been giving my debugging muscles a workout (think 98 lb weakling,
sand in the face, no date for the prom...), and I am stumped. I have a form
with a subform. It works perfectly. If I open it from another form, using
OpenArgs, I get an error message. Why?

I have a field in my table where the data type is Yes/No and it is a
required field.  The user wants the default value for the control to be
blank yet whenever we go to a new record the default value shows up as No.
Can you set a Yes/No field that is required to default to blank?  ...

Hi there everyone
Can you tell me how I go about the following:
I want to put the value of the last primary key number in a variable so I
did the following code:

I have a form that accepts
BegDate1  BegHour1  EndDate1  EndHour1
BegDate2  BegHour2  EndDate2  EndHour2
BegDate3  BegHour3  EndDate3  EndHour3

I have been working with Access a long time but just recently started with
APD -  Sql Server 2000.  I have a popup form where I pass a contactid to the
form and set the recordset (a stored procedure with a parameter) after the
form open event.

how can i refresh MS access form every 1 minute

Hi to all on this monday morning,
After spending an hour on how to write this, it look like I need some help
can anyone tell me what is my mistake here:
I am always getting  the following error, "expression contain invalid

I have a database of clinical patient records that is generally working
well, but does not alert the data entry person if they have entered in a
record w/ a duplicate 'key'.  I check to see (in Sub 'Next_Click' below) to
see if certain required fields are filled in, and, if they ...

I have a table that acts as a timer to update data early in the morning. Once
runs, it puts a date in a table to indicate that the procedure has or has not
been triggered that day. This form is working but I have found that it does
not indicate that the macro that it triggers was ...

When a text box has the focus how do I programmatically select
all the text in the field. I want to keep the Entering Field Behavior
in Options set at Go to start of field.
Thanks,