Search results

I simply wanted to send an e-mail out to certain recipients while running an automatic procedure, telling them the their info has been updated. And I didn't want the user who was running the update to have to click anything when sending the e-mail. If there is a way to use the SendObject...

I believe CDO stands for Collaborated Data Object

I'm trying to automatically send an e-mail (with MS Outlook) using MS Access without using the DoCmd.SendObject command. I want no user intervention or anything like that.

My code crashes at the following line: Set iMsg = CreateObject("CDO.Message") The error message states: ActiveX component can't create object. I'm not sure what to do. I have included all the possible libraries, so now I'm stuck between a rock and a hard place. Anyone have any ideas?? FYI...

I would like to open a data access page using VBA code. Is this possible? I would like to open it, when the user inputs the name of the page in a textbox. Thanks for your help Erik:)

I have a 2 page report that I need to send to the printer 500 times. Everytime the report is being printed, there is different info on the report (I run queries everytime I go through the loop). The problem is, I don't want to queue up 500 jobs at once. I only want to queue up about 10 jobs...

ignore last post Nevermind, I'm sorry about my ignorance, I didn't realize the "at" function was a dos command..

at function?? Where do I find this so-called "at" function?? I've searched the help in both vba and access and have found nothing. I tried searching for threads using the same function and was also unsuccessfull. Please let me know where to find info about this "AT" function, because I've...

reasoning The reason I need to run a batch file to do this is that I need to schedule a job at 3am everyday that will export a text file onto a server. Instead of doing it manually everyday, we will dedicate 1 pc to do the job and the pc will be up and running all nite long.

I would like to create a batch file to open up an Access database at a given time and then close it at a later time. Does anyone have any ideas?? Thanks in advance, Erik

Is it possible to automate the page setup to make it "Legal" as Access seems to set a report to "Letter" as the default paper size. This should be done using VBA coding, rather than having the user manually select File->Page Setup->Legal on every single report.... Any help would be greatly...

Is it possible to automate the page setup to make it "Legal" as Access seems to set a report to "Letter" as the default paper size. This should be done using VBA coding, rather than having the user manually select File->Page Setup->Legal on every single report.... Any help would be greatly...

I am trying to validate a field in a text box to allow only characters/letters and nothing else....I tried using the like operator..eg myVar LIKE "[A-z]" but this works for only one character.... and "*[A-z]*" is not valid either... Any held would be greatly appreciated Thanks in advance, Erik

How many columns are there in your combo box?? If there is more than one column, you need to set the "bound column" property to the proper column you want to see. Let me know if you need anything else

try this, the nz function allows us to put a zero where a null value would normally be nz([Field a],0) + nz([Field b],0) + nz([Field c] ,0)

Unknown variable In the for loop you refer to the variable 'NumberOfCustomers', where does this come from as it is never declared nor initialized in the sample code given

Unknown variable In the for loop you refer to the variable 'NumberOfCustomers', where does this come from as it is never declared nor initialized in the sample code given

It depends what you really want to do. If you simply want to retrieve queries, reports, forms, modules, etc. Then the simple thing is to create a blank database, and then import all the necessary objects you need. Let me know if this is what you wanted to do or not, otherwise we can try...

I have a 2500 page report, without any subreports. On each page I have a store number. Whenever the store number changes I need to reset the page numbers so that each store can get a copy of the report with the proper number of page numbers. EG: Store 250 has 3 pages, so instead of reading...

I have a 2500 page report, without any subreports. On each page I have a store number. Whenever the store number changes I need to reset the page numbers so that each store can get a copy of the report with the proper number of page numbers. EG: Store 250 has 3 pages, so instead of reading...