we have a big big problem.
We have a large ADP project (900 objects Forms-Reports-Modules)
Recently the project has become unstable.
Not always, but often, when modifying a Form or a Report the program crashes

Can an insert query that inserts values from one table into another take one
of its tables from an sql server database? The sql server is accessible
either via domain or ip address. I prefer not to link the sql server tables
as linked tables raise issues form time to time and ...

I have an access database that you can input students answers to a
test. A field then determines if this is the correct answer or not
with either a 1 or 0.
Here's the formula:Correct/Wrong1 =IIf([Student Answer

hi... i want this code record fields(name,IPCMref and POTdec),only with value
of  fields is not exist in table...the problem is that code record fields
when this
exist in table.

I have a TblProjects that contains details referring to a project. I have
another table called TblProjectUpdates that contains weekly updates for each
project, the realationship is one-to-many, because each project has many
updates.

I have a combo box that is populated with state abbreviations.  For some
reason, this one box does not autoexpand.  For instance, I type in az, it
should choose AZ from the list.  The Auto Expand property is set to yes.  I'm
sure I'm missing something totally easy, but I just ...

I have a data entry form and wanted to use the bookmark feature to allow for
managers to lookup or access a completed form.  it seems the bookmark only
works for the most recent entries but when you go out of the database and
back in the bookmark doesnt seem to work.

Would it be possible to make the primary key of a table which is AutoNumber,
have or start with 3 digits?
Instead of 1 can I make it to show 001 then 002 and so on?
Thanks

I am working on adding a user function where users "log on" to use the
database. Each user will be assigned certain records and only the
assigned user can make changes.
My plan (and please tell me if I am going about this wrong) is to

Is there a way to show a Form on a corporate intranet, and allow a user to
input information into a Table in an Access DB.  I was thinking of creating a
tool, like an HTML browser, that allows a user to input some information into
one of my tables.  If so, how can I establish a ...

I have a Access query that pulls a UPC code from a field in a linked SQL
table in our company data base (Great Plains) I have a number with 11 digits,
and I need to generate a 12th digit which is called a check digit. I have a
formula by which I can calculate this check digit in ...

I am working on setting up a new database that has one main table and a sub
table linked to show a list of all workers, the table with the workers needs
to have their supervisors listed for each worker, I have two columns one to
show the supervisor ID and one for the supervisor ...

Greeting,
I have a form that has two textbox which they service start date and service
end date. Also, it has a three text boxes to represent the service period.
One of them is for Year, the second is for months and the last one is for

For some reason, hopefully someone can enlighten me, opening linked tables.  
When I open them in the back-end, they open immediately, but when I open the
same table from the front-end it is measurably longer (30+ seconds)?  Does
anyone know why the huge difference? and are there ...

I have a table called TblProjects that contains all details related to the
project, I have a table called TblProjectUpdates which contains a weekly
update for each project. The relationship is one-to-many
TblProjectUpdates