Search results

I need to print a report that looks like a certificate, with the Scroll Border. When I paste in a Microsoft clipart boarder, access cuts off right side. Page setup is set to letter size paper landscape. Any suggestions will be helpful... Thanks in advance!

I have a sub form,Default View Continuous, with an unbound text box TotalPay control source =[Percentage]/100*Charge but I need to change TotalPay to something like... If Me.Request.Value = True then Me.TotalPay = [Percentage]/100*[Charge] Else Me.TotalPay = [PercentageReq]/100*[Charge] End...

I have an order database Access 2000 for an inspection company, tblInspectors, tblOrders, tblCustomers, I want to be able to calculate inspector pay within order database. Each inspector is an independent contractor, so it just needs to calculate percentage, for each inspection performed and...

I want to use a business card scanner, and use the data for my Access 2000 order database. Most card scanners, can send data to Outlook, can you go from Outlook to Access? Any advise would be appreciate it . . . THANKS!:o

I have an order database using Access 2000, I need a report to list all agents that have ordered in the past year, how many times they ordered and sort by Office city. I have SELECT tblCustomers.Type, tblAgentList.AgentID, tblAgentList.LastName, tblAgentList.FirstName, tblAgentList.Agency...

I'm using Access 2000, and I have a report with checkboxes and a linked picture. In print preview the report looks fine, but when the report prints on the printer the checkboxes and picture are missing. I'm using HP 1350 as a printer. :eek: Thanks in advance for your help!

:eek: I have an order database via Access 2000, the backend became corrupted. I ran a a software program to recover the data. It recovered the data, but the autonumber was changed to just number and it removed primary key setting to the same field. I created a duplicate table, then ran an...

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"...

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...

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...

: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...

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:

: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?

I developed a database that will be run on a pen based laptop computer. BUT... The pen will not "write" in the text boxes. I can point to items in a list box with the pen and it works fine. The pen "writes" in MSWord without a problem. Is there something I need to do within Access for the...