I have a form frmParts with record source tblParts.  In frmParts, I'm using
the macro action setvalue to set the value of many fields in my form, which
are then stored in tblParts. The setvalues expression is a dlookup looking at
fields in other tables in my database, tblA and ...

Hi, in my case, the the user opens the mde file, the forms does not
have a full bar toolbar expect the print preview and print button (the
one with the printer icon) nor the menu bar. If i compiled on my
machine to make the mde file, it will pick up my default printer (for

After some testing, I've determined that most if not all of the errors that
our application generates on a daily basis will go away, if I can change the
network packet size from 4096 to 16384.
For the life of me, I cannot figure out how to change my .adp file to make

I have an unbound form which host a tab control with 6 pages.
On any of this pages there are many controls eache of them unbound and with
some labels NOT joined to the controls that will receive data (this is due to
the need to design the form to look like the paper form).

I'm writing an application to register 2-person relay teams for a 10 mile run.
But whenever I run my code to add both people to the table of runners,
VBA returns the following error:
"Number of rows with pending changes exceeded the limit"

My report's recordsource is a single-table query.  I would like to record
the date/time that each record was printed in a field in that same table.  It
seems to me that the report detail's OnPrint is the right event within which
to try to update the Date/Time field in the ...

Let's say that I have a file with path C:\TEMP\LRQAD362.CHK
The 3 numbers are significant to the purpose of the file...how do I get those
3 numbers out, and use them in as a string?
Thanks in advance!

I have a form with Tab control.  One tab has a form in datasheet view,
based on a query called Open_Items.  When I double-click the
Date_Reported field, another tab appears, with the details of the
selected record.

I have a .TXT file to import to a DB. The file is Space delimited. The
problem is that the file has more than 255 columns, and the number of columns
can vary. Is it possible to create a routine that imports this file spliting
it into multiple tables?

How do you create a function procedure that calls a sub procedure?  I am
trying to execute a Sub procedure by using the RunCode Action in a macro.....
but it tells me: "To run a Sub procedure or event procedure, create a
function procedure that calls a Sub procedure or event ...

I want to create a list of pdf documents using a listbox and then by
double-clicking a row in the listbox access will open the appropriate pdf
document, any ideas?

I have a tab control with two pages. I have a ListView control in each of the
pages.
My problem is that when I navigate from page 1 to page 2, the ListView in
page 2 is not displayed properly. Navigating back to page 1 and then to page

I was wondering if it is possible to specify an SMTP account/service when
automating mail through Outlook using Access 2000.  Most mail will be sent
via the default Microsoft Exchange server, but there are certain emails which
need to be routed through internet mail.  I am using ...

How can I change a form's defaultview with VB?  I've tried the following and
get a message telling me to go to Design view.
Me.Defaultview=2
me.Defaultview=Datasheet

I have an unbound form and many textbox on it which I should like to change
into checkbox instead.
Since I'm talking of about 75 controls...I was figuring if there was a
shortcut to achieve my aim by code.