I am running into an issue with a combo box in an Access 2002 .adp where I
have more than 65k of records.  Are there any easy workarounds for this issue?
Thanks,
Doug

I just installed Office Enterprise 2007 and opened a database that I've been
using under MS Access 2000 for several years.  
When I double click on one of the date fields I've set up on the form, code
is executed to set the field to the value of Date; e.g., "OrderedDate =

I have a table with about 30 fields in them. In the report i am creating , i
want the user to choose one of these fields to get the report.
How can i make it possible that the use can choose the field rather than the
contents of the fields.

Please assist.
I am using the code below to change the field positions:
Function chgfldpos(strTableName As String)
Dim db As Database

I want to use on Datasheet View On open code that will freeze the columns,
organize columns and update the widhts in a way that form will open in a same
format each time.
I have been able to write code that peforms:

(This is a repost of a posting in microsoft.public.access which was an
accident, sorry)
Is there a way to call a function (or sub for that matter) where the
function/sub name is stored in a variable?

Is thier a better way to condense this code then to have read the same way
over and over each time? I have 5 sets of these and each field is set to be
visible if the option box has a check mark in it. I am only showing you one
full set for the "IsDisplayHistoricalGrowth" option ...

Is there a way to run function from access that get name and path of file
and run software according to the file extention?

Does anyone know the code to get your computers name using VBA?
Thanks,
David

Hi I am new to access and was hoping someone could help me.
I am getting this message:
The INSERT INTO statement contains the following unknown field name: 'CELL''
Make sure you have typed the name correctly, and try the operation again.

I have a form (frmContacts) in which users enter home visit data pertaining
to specific clients.  On this form is a button which opens a linked form
(frmSummary) used for entering a monthly text summary of those visits.  
Sometimes users will add data in frmContacts and then ...

I have an access form that does an openReport based on selectio
criteria; see code below:
Private Sub Report_NoData(Cancel As Integer)
   MsgBox "No Data was found for your criteria, The Report will not

I have had Office 2003 sp2 recently installed. Now one of my mde db's
fails with a missing reference error. It still works on my friends PC
with sp1. If I make another mde from the mdb it works for me but not
my friend. I suspect the utility reference is causing the problem so I

Hi, I am pulling my hair out with this Syntax issue, I am trying to load in a
linked Spreadsheet and then append some fields from this into a table that is
sitting on another drive but I am connecting to it via ADO. For some reason
when executing the code it doesnt seem to like ...

In one of the field of the forms shows "#error" when I open the form, and
when I click the fiedl it says " Reserved error (-1517); There is no message
for this error", then there is a button of "OK" and "help".
Please help why this occurs