Recent content by EliteDesk@aol.com

When I insert the clip art boarder it is only about 4", when I stretch it to fit letter size and landscape the right side get cut off. When I use word template via microsoft.com for a certificate, and copy and past the boarder, it cuts it off at 8.5 inches. The page is set to landscape letter size.

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!

THANKS! its just want I needed!

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

pbaldy, thanks for the advise, I appreciate you taking the time to reply!

You make it sound so easy ... :eek: Would you store the totals? Should the payroll start and end dates be stored in a table, or just calculated? Thanks in advance for your help?

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

Thanks! Thanks, Pat! I will try it, as soon as I get the scanner via snail mail. Thanks again!

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

Finally got it! SELECT tblAgentList.AgentID, tblAgentList.LastName, tblAgentList.FirstName, tblAgentList.Agency, tblAgentList.AgencyCity, tblAgentList.DeliveryAddress, tblAgentList.DeliveryCity, tblAgentList.DeliveryState, tblAgentList.DeliveryPostalCode, tblAgentList.[AgentOffice#]...

Thank you for taking the time to reply! I'm getting the following error "Syntax error in from clause".

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!

FIXED! I just deleted all the data out of the new table, set the primary key, then ran the append query again. Thanks ! ;)

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