Recent content by jamie13

Hi, I have both windows and office XP. I have installed Adobe PDF Maker. I am trying to generate reports and use a loop to automatically send them out usually I use the following code. DoCmd.SendObject acSendReport, "Report Name", "SnapshotFormat(*.snp)", Forms![formname]![TO].Value, , , ""...

I am currently runnning outllok 2002. I need to setup an autoreply so when a customer e-mails that account they get an e-mail right back. I don't want to use the out of office assistant because i don't want the customer to think noon is here. I tried using the rules wizard but i only seems ot...

fantastik thanks

Hi, I'm currently using access 97. I have a long list of numbers which were provided for me in a table. Each cell contains from 7-9 digits. It is important that for my task all the cells have exactly 9 digits. Is there any way i can count the characters in a cell and generate a list of all the...

I tried deleting that file but it told me it might be a read only db or i might not have permissions to delete. THere are definately no users in the DB as i haven't ginven anyone access tot he shared drive yet. I need some way to unlock these files. Jamie

HI, I've run into a situation i have never seen before and i was wondering if anyone else has had this happen to them. I have a database in acces 97. its a bout 500 MB. I just compacted the DB, but when I do this the DB doesn't unlock, and thus the compacting creates a new DB. How can i close...

John, Basically i have a loop set up now which runs through a list of customers, develops the invoice and e-mails it automatically. I am currently using snapshot format, but i have got some complaints that users can't always view the invoice on screen and must print it. I am willing to buy PDF...

Hi All, I am using ms access 97. I am sending invoices using the Docmd.SendObject command. I would like to include several reports in 1 e-mail. Does anyone know the syntax for this? Thanks Jamie

Hi All, I currently have an access 97 DB which send out invoices to customers. I have a loop set up where i just go through my list of customers, generate a report for each, and then automatically send out the reports via e-mail using the Docmd.send command. I would like to begin sending out...

Hi all, I would like to know if anyone can help. I need to generate a 6 digit number beginning with the first letter of the name of the account owner. For example if I am in charge of the account "Jamie" I would need to generate number J000001 for the first account and so on, but i...

No I never found the answer. I ended up having outlook 98 reinstalled on her computer, and it works great. If you find out, let me know. Jamie

Hi, I need to know if its possible, and if so how, to set up access to send faxes. I would like to send invoices to my customers via fax. I have the numbers and reports setup in access. I'm using a fax server to send the faxes. Please help me if you can Thanks Jamie

Hi, I need to know if its possible, and if so how, to set up access to send faxes. I would like to send invoices to my customers via fax. I have the numbers and reports setup in access. I'm using a fax server to send the faxes. Please help me if you can Thanks Jamie

Hi, I'm currently using the e-mail function to send out invoices to customers. I was typing the message i want in the e-mail, but i don't know how to continue my message to the next line in the code. I can type the message on one long line but when i get to the end I am stuck. Also how can you...

I have created a program which automatically send out invoices created in MS Access. The program works great when i use it with MS Outlook 98. Unfortunately it is going to be used by someone using MS outlook XP. In the XP environment the program still works as it should, but the security...