Search results

that works great thanks v much

I have an access 97 database that requires userid and password to enable a user to log in. I need to be able to run either a .bat file or command line that will open the database with the correct userid and password and then run a specific macro. Anyone help.?

I'm trying to create an Outlook task and assign it to someone I've created the object etc but when I try olNewTask.assign "username" it doesn't work

that works great many thanx

How difficult can it be.....!!!! ive tried format(now(),"mmmm")-1 but it doesn't work Ive tried tempdate = format(now(),"mm")-1 fieldname = format(tempdate,"mmmm") This comes out with January for some unknown reason. Help!!

sample of the relevant code below Dim rsContacts As Recordset .. .. Set rsContacts = dbase.OpenRecordset("tblcontacts") .. .. rsContacts.FindFirst "[contactid]= " & cboJobContact ' .. .. olNewMail.To = "'rscontacts(10)'" olNewMail.Body = "body text." olNewMail.Attachments.Add ("c:\Order...

I have a recordset that holds an email address for customers. I've done the code that finds the right customer but how can I do olNewMailitem.to rsContacts(10) The above doesn't work. I think the syntax may be wrong.

Fixed it I used wordobject.quit

Tried it and I get an error "method or data member not found" at the begining i have Dim objWord As Word.Application at the end I set the objects to nothing Anything else I can try?

I've created a button which basically opens a word document and populates it with information from a from. This works ok. When I try to attach the word doc to an outlook email it says that the word doc is open elsewhere. task manager shows winword.exe open evn though at the end of the code I...

Had a look but doesn't tell me how to open an e-mail that is stored on the harddrive as a .msg file. The article in microsoft only tells you how to retreive it from within outlook.

How can I open a .msg outlook file using code within Access 97. I know that Set MyItem = spObj.CreateItem(olMailItem) MyItem.Display Opens a new mail, but I don't know what opens an existing one that is store in a directory somewhere. Anyone help?

Great, works fine with the vbdirectory bit in

have the code below checking if a directory exists: JobRef = Left(Form_frmViewJob.txtJobReference, 8) & " - " & Right(Form_frmViewJob.txtJobReference, 6) Me.dlgViewJobFolder.InitDir = "w:\dosapps\delta5\private\b2bdbase\borisdata\" & JobRef If Dir(Me.dlgViewJobFolder.InitDir) = "" Then...

yes but its the fileopen procedure that i need... If i put the code in it just says function not defined.

Code Ok next thing then What would be the code to put behind the open button on the common dialog box.

I've put a common dialog control on a form. Can make it visible by using the .showopen statement. I was under the impression that if I double clicked a file within it ie and xls spreadsheet it would open. No nothing happens at all. Surely I don't need to code all the functionality of the...

1 more. How can you disable the items on the dialog box ie filter, and the buttons on the top right.

dialog box I managed to get it to display but when I double click a word doc etc they don't open

Dialog box I've put a tick in the acvtive x 2.1 but still don't have the option for .showopen to display the form. Anything else I can try?