I have a table with values I need read into an array, and I keep getting
"compile error: can't assign to Array" even when I know the code has worked
on previous occasions.  (I copied code for an array from a sub procedure that
does work, into a "trial" function, and it didn't ...

I thought this was simple but what I've done isn't working.  I want a
variable to be packed to 4 digits (with preceding zeros).  Here's what I've
done:
lngBatchID = Format(lngLastBatchID, "0000")

Thanks for taking the time to read my question.
Right now my program can output data to a file and place
that file into a new e-mail using MSOutlook.
Some of the clients have gone to webmail.

I have a data string form another program. The data string
has a defined format in chunks of 16 bytes. The 16 bytes
can be 16 individual bits or a 16 byte integer.
I can create a table design with yes/no fields and integer

ive been told that creating a database using SQL is far better than using
access.  can an access database be easily converted to SQL and if so what are
the benefits?

I have a search form with several criterias fields (Num,Dates etc..)
and by pushing the Search Btn, an hidden subform is apearing and i want the
Data that i retrieving to enter the subform. I get acknoledge abuot the
valitidy of the data (using the recordset method). and when i ...

Every once in a while when I'm writing some new code, I debug, save and then
switch over to the form I'm working on.  When I attempt to run the program,
however, I get caught in some error loop.  The first thing I get is an error
msgbox stating, "Object doesn't support this ...

I have both 2000 and 2003 installed.  I can open  a 2000 format database in
2003 and view its code fine, but when I then open it in 2000 it won't let me
look at the code.  I get a dialog box titled "Project Locked" and an
informational icon with the text "project is unviewable", ...

An mdb sets a VB reference to a 2nd mdb and uses code to open a form in the
2nd mdb. This form in turn is supposed to display a custom toolbar. However,
I am getting an error message that it cannot find the custom toolbar.

I need to determine what menu option a user has clicked on:
EXAMPLE:
Menu Bar Command = Update
  Sub Command = Drivers

Can anyone tell me why I get a compile error: Method or data member not found when I try to compile the following code?
This code works in Access 97. I am now using Access 2000
The compile error is on ==> fld.CreateProperty   and on ==> fld.Properties.Append Prop

Can anyone help me with this one please?
I need to return the string "Record is Null" is the field is in fact a Null
but I keep getting an "object required" error message.
I am using the following code.

I have an OLE Object and a text box below it on my switchboard.
How can I set animation to both?  For example: Have the object and the text
box fly in from the top or something that looks cool.
Thank you

I am exporting data from ACCESS database to EXCEL.  The datasource is a
query.  
There are numeric fields in the query but after exporting, the numeric data
type is changed to text.

i have an access database that produces our company billing run from a
single report containing multiple sub reports.
The report is then printed to pdf format as it is quicker to scroll through
than waiting for access to format the pages (in excess of 1400 pages)