Search results for query: *

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

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

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

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

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

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

Is there any way to give the user different options of how they want to see a report being sorted, or do you need to have separate reports for every sort required? Thanks Jamie

I am trying to generate invoices in a snapshot format to send to clients. When i am writing to sendobject code i need to enter a format. What is the code for snapshot. I know for rich text format it is AcFormatRTF. Thanks Jamie

I have a list of customers, of which I need to send invoices. I have all the contact names and reports done in an access database. I know how to use the send object function, but that works for one account at a time. Is there a way to send out the invoices to each customer and only press one...

Last night I tried to turn my computer on, and nothing happened, except that the green light (power supply indicator) began flashing. I coudn't get it to boot up. Any idea what could be wrong with it? I thought it might be the power supply but i have no idea Thanks Jamie

I just installed a creative labs 6x speed dvd rom into my computer. I'm using an asus a7v mb, 800mhz duron processor, 256 megs of ram and a 32 meg nvidia tnt2 videocard. When i tried to play a dvd the picture was choppy and slow. does any one have any ideas why this is happening, or how i can...

Does anyone know how i can create a hyperlink to another file using vbcode? Thanks Jamie

Does anyone know how I could remove a form filter using VB Code? Thanks Jamie

I'm trying to create reports which I can send Via e-mail. I've already created the snapshot image of my report, but when i convert it to snapshot, you can only see the report header information. All the details remain balnk. When i print the report from the snapshot, all the information appears...