Using the database Results wizard in Frontpage I have set up a database
editor page but get a database connection error when I verify the criteria:  
Server error: Unable to retrieve schema information from the query:
UPDATE Results SET Sector = '1' , Company = '2' , Contact = '3'  ...

Here's my question, stripped down:
I have an organization table.  
I have an employee table (multiple orgs each have individual employees).
I have a training session table (employees attend training sessions.)

I've searched and searched but cannot find an answer for this question:
I want to associate an image file for each records in my db.  On the
form displaying the records, I want to add a button that when clicked,
will open up the image using the program associated with it.  Currently

Hi I need to get 3 reports out of the same data and they mainly have the
same data.
But they need to get a unique number based on the date and  then 3 different
numbers (one for each report) for the same data, to be continued per sets of

i am using lexmark x73 printer with a me system and i can not get word from
office 97 to print an envlope. It will print a document just not envlopes

i am a lawyer and in india. here the saying goes that courts are a place
where you get dates, not justice.!!! thats where my problem starts.  i have
prepared a database of my cases, with fixed fields as names, section etc. But
in a life time of a case, i get many dates, all other ...

I'm a first time poster and I apologise now for any protocols I may have
accidently trampled over in posting here!
I'm trying to create an update query in MS Access where the query counts the
amount of addresses in a table that are the same, then if there are any

My Company uses excel sheets to track the daily production. These sheets are
used at other facilities and emailed to me. I am wondering if there is a way
I can take these daily production reports and just import them into access. I
have already imported one and the formulas didnt ...

I have a problem with opening forms.I have situation with 8 forms (small
ones!) which must be open based on values in ComboBox1 and ComboBox2.
imagin situation: if the cmbOne=5e and cmbTwo=UTP open Form1,
if the cmbOne=5e and cmbTwo=FTP open Form2,

I am trying to do a simple timecard databse, my tables are: EmployeeData,
DailyTimeEntry, LeaveAvailable, PayPeriod.  The managers enter employee data
including initial bank of leave hours.  Employees enter time daily including
use leave hours.  Employees view a timecard report ...

At first I was writing in to find out how to merge these two tables I have.  
Now I am thinking that it would be more expedient if there was a way to
create a new table (#3) that would automatically copy all the fields that I
already have set up in Table #1.  Is there an "open as ...

a search collectively ? I have a small database with just one table to log
Gas Installation Revisions and upcoming due revision dates. If I search for
all revisions due in a particular month, can I print out the results in one
go ?

I work in a theatre and we use access for our mailing list and a FoxPro
program for our ticketing software.  The FoxPro program is not versatile when
it comes to database maintenance (Choice ticketing).  It is limited to
deleting and changing customers one by one.  Unfortunately, ...

Hi there, If some of You might have noticed, I've been asking You questions
daily over past week. And Thank You once again, for answering me simply and
kindly.
Today I have struggled with a simple queestion, but can't figure out how to

I want to add to different DSum's and divide by the sum of two DCounts.  I
started by just adding two DSums and getting error(#Name?).
=DSumAvg("[TurnAroundTime]","qryCollateraQualityListPartsShippedTurnaroundTime")+DSum("[TurnAroundTime]" ...