Search results

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

Louie Thanks for everything I figured it out, I couldn't have done it without your help. :) :) SELECT DISTINCTROW tblPeople.pkPeopleID, tblPeople.fldFName, tblPeople.fldLName, tblPeople.fldTypeID, tblPeople.fldNotActive, (Select Count(*) From tblAppointments Where (pkPeopleId=...

Louie I'm sorry, for not being clear in the last post, I DO want a paticular date, but I need the count of appointments per employee not the total of jobs for the day. For example: Jack has 2 jobs for Today Sue has 3 jobs for Today Tim had 0 jobs for Today ... I do NOT need 5 total jobs for...

Lou, I'm sorry, I really do not understand, how to modify the "code" :eek: , but I just copied and pasted. Your example is very close. It shows all employees even with no appointments, but intead of a total of jobs per person, it shows total jobs for that day. Thanks so much for the time...

I'm counting total jobs for each person on a paticular day. It only shows appointment data for the first appointment, and gives me a total of appointments for that day. I attached the results I'm getting now. I want to also see the people that have no appointments. Now, the names of the...

Louie, I just did a copy and paste of the select you posted and I still get the same results. No one listed with zero appointments. Any suggestions would be greatly appreciated. Cathi :confused: