Now I can add images in a Report who change in each record.
But if the image-field in some fields is empty, then in the Report stands
the image of the previous record...
How to fix that ?

I hope someone can help...I feel like I'm walking in the dark without a
flashlight (I'm NOT a programmer but have been called to task to do
some work in Access that is above my head).
I have code that will successfully copy a record and append the

order button and are then taken to the orders page. From here comes the
problem, I want the user to select a combo box unique to the supplier.
Currently the combo boxes I create show all records for every supplier ...

I'm running through a database in a loop, and each time the loop
finishes I would like to export the values of some variables to new
text files.  In reality it's more complex than this, but this is the
simplest way to state it.

This is bizarre.  I've check and rechecked the spelling, cut and paste
the name of the form (when trying to rename the form) and the control
yet I still get a parameter prompt when the form runs.  I've even
deleted the control and started over.

Hi,.
I'm trying to make a inventory and average cost that includes receivied
weights and cost.
The cost changes everytime we receivie product as cost from vendor

Does anyone know of a way to accomplish this?:
I have a table of assets
I want to change my asset number field to auto-number (caution: I
already have hundreds of records in there so this change alone may be a

I am getting database corruption more frequently than is ideal.  I have
a form used in a call center environment with about 5-10 users at any
given time.  The application is split between front end and back end
and the back end resides on a network server.  Each user has their own

'Search all reports for a text box named something
Dim cMsg As String, db As Database, rs As Recordset, rpt As Report, ctl as
Control
Set db = CurrentDb()

Access 2003 Frt end,  SQL 2000 Back end
My listbox has 2 columns "UserID" & "FullName" (UserID is a Primary
Key)
I am trying to loop thru the multi-select listbox to print a separate

Ok...I was persented this problem and i have it almost worked out (I think).
A customer of mine has asked for a database to store information based on a
written form he used in the past.  The nature of the form is such that there
are several areas of info but the tables would NOT ...

I'm doing some data warehousing for this charity and I can't enforce
referential integrity.  I know there is a value out there that violates
it and I was wondering if anybody knows a way to design a query which
will give me the values that violate RI.  I'm using Access 97 and I

I'm developing an HR package which would contain the Employees Photo +
upto 3 pages (pictures) of his Passport + pictures of his Driving
License and Residence Card.
If the user wants to print the Passport Copies, Driving License,

I hope someone can help me...I haven't got a clue how to do this.
I have a table with several one-to-many relationships.  One of the
related tables has it's own one-to many relationships as well.
I would like to copy a record when I am in a form and append it to the

I am having a problem coming up with the correct SQL string to take care
of a issue.  I have three tables (tblRoster, tblAssign, tblAppointment)
 All three have a field intSSN which is the primary key.  I have been
trying to figure out a SQL string to populate tblAssign with all ...