I have an Access 2007 problem and I would just like to know if there
is some sort of solution out there.  The problem is, when I build a
report that will 99% of the time be one page or less maybe even a
half

Every once in a while I modify one particular form (could be anything from
adding code to tweaking properties as far as I can see) and upon loading I
get;
"You can't assign a value to this object"

I have a corrupt record that disappears after a compact, but reappears
several days later.  This is on a widely distributed Access 2003
application that is used by about 100 users.  The database itself is
only 70mb, but the problem this record causes is widespread.  As soon

Barcodes encode numeric or textual information in a printable, machine-
readable form. The use of barcodes can significantly reduce cost of
warehouse management and inventory. Two main forms of barcodes exist
today: Linear or normal barcodes encode data over a horizontal stretch

   I am creating a music database for a friend and have run into a problem.
Within the ALBUM table, I wanted to store the ARTIST_ID rather than the
ARTIST_NAME. To do this, I intended to have have a command button on the
album form which would open a search form (based on the ...

Hello everyone:  Using Access 2003 with links to SQL tables.
Trying to create a persistent recordset connection to help with
perfromance.
In General Declarations I have the following Code:

My DB is used to order materials for a number of different building
sites.  I have a form for the orders which lists the obvious details
of whats being ordered etc.  each site has a reference number and each
order has a unique order number.  i.e a site may be site number 12 and

I have looked far and wide and i am sure someone has done this but I
can't find anything on it. All I want to do is convert a access table
with lat long like 32.15665 -95.56954 to 265568.82 761586.48 (note
these are not real cords just some i typed in i can provided some real

We have a database of books, which includes a field "Author"
Authors are listed like:
Annabel Langbein
Alison Holst

I work on an app developped with Access/VBA and communicating with a
SQL Server database via ODBC.
My problem is that I have to manage a big string which can be 0 to
1024 characters long. The string is correctly stored in the Access and

Sorry, I know this has been done 1000 times.  The problem is i need to
loop though a recordset and I dont know the field names, so they have
to be looked up.  When i pass them to get the values, it passes as a
literal.

Has anyone ever encountered this problem?  When I open forms or
reports, everything seems to have reverted to Arial & Times (displays
and prints whether in preview or design view) .  If I select a
particular control, the correct font appears on the formatting toolbar

I am using Access2002
I have a form with 5 text boxes which are parameters to a function
3 parameters are optional in the function
How do I pass the empty textbox values to a optional parameter?

I'm using Access 2003 and will have to separate databases with the
exact same tables and table structures.
I need to be able to compare the table from the second database
against the same table in the first database.  I need to know if there

Good morning,
I am a relatively novice access user.  I was given the grand
assignement yesterday of outputting queries for a sales organization
to excel and repeating this once a week.  The queries are simple, but