Search results

I just went to view then View Join Properties, then choose option two, which is stated above. I do not know what a LEFT join is. Cathi SELECT DISTINCTROW tblPeople.pkPeopleID, tblPeople.fldFName, tblPeople.fldLName, tblPeople.fldTypeID, tblAppointments.fldDate, tblPeople.fldNotActive...

Count Zero I have an schedule database using Access 2000... I have tblPeople with pkPeopleID,fldFName, fldLName,... and tblAppointments with fkPeopleId, fldDate, fldTime,... I created a query that counts the number of appointments per person for a paticular day. It works fine BUT It does not...

I'm using Access 2000 and I'm having a problem with a picture in a report. I have an image box with border set to transparent, but I still get a border with three sides, no bottom line shows, around with the image. If I set the border to solid I get a complete border but uneven "white areas"...

Thanks I guess I was making this way too hard. You make it sound so easy. Thank you! Cathi

I have two order databases, Access 2000, both with tblCustomers and field Job# (autonumber) as pk. Datebase1 started with Job# 5000, and database2 started with Job# 100001. The problem is database1 in now at Job# 100091, thus creating duplicate Job#'s. I need to merge the two databases which...

Thank You JON K it works like a charm, thanks for taking the time to help. Sorry it took a while to get back, but I went on a much needed vacation. Thank You, to all of you brilliant people who reply the endless questions. Access World Forums is priceless. :p Cathi

Bert I have Microsoft DAO 3.6 Object Library checked via References. Do I still need to declare DAO? :rolleyes: Thanks, Cathi

I need to open a recordset with a query, but when I used the code below I received "Too Few Parameters. Expected 1" Error Message. rsReports.Open "Select DISTINCT InspectorID from qryCreatePDFs", conn, adOpenStatic, adLockReadOnly due to the following site...

HELP! I'm trying to output a single report to multiple PDF Files. I have a query qryCreatePDFs, with a date criteria and check box False criteria, it is my reports underlying query. The query is also used as the base of the recordset. I used the code below and received "Too Few...

Thank you again! Wayne, :) :) :) :) : A a ton of bricks just fell off my shoulders! It is exactly what I needed. Cathi

Thanks Wayne, Thank you, I will take a look at it! I really appreciate you taking the time to help me. Cathi

:cool: I have searched this great web site, and cannot find an answer to this. I would appreciate anyones help. I have a continuous form listing up to 100 records, I need to use Conditional Formating via Access 2000, but confused on the syntax for Expression Is. I want to change the color...

thanks Thank you! :D It was a perfect fix. :)

I have a form based on a query, I want to display a msgbox informing user when there is no data and canceling the open form action. I was hoping for an easy fix like NoData event for reports. What is the easiest way to do this? Thanks you for your time. :confused:

Thanks Thanks I will try that! Cathi

:confused: I'm building a database and need all the cities in California in a table. I would hate to type in every city. Does anyone know where I could get such a table? Thanks in advance for your time.

Hello I have a Access 2000 database running on a pen based computer. I want to literally save signitures in the database, any ideas on how this can be done. Thank you in advance! Cathi

I have a form with several pictures on it, when the form opens it eats up the system resources by 50%. I do not recover the resources when the form closes. What can I do to recover the resources, without rebooting?

I'm saving my Access reports as PDF via Adobe Acrobat 5.0, when I choose Distiller as printer for creating my PDF it changes Distiller to my default printer. Adobe says this is problem in Access not Acrobat. Does any one know how to prevent this from happening? Thanks in advance!

Is there a way to merge several one page reports into one report snapshot?