Recent content by teabags

I am passing a sql statement through vb and I am getting a criteria mismatch expression. Between '" & DStart & "' And '" & DFinish & "' DStart and Finish both correspond to numeric fields in an access database

How would I pass a string like '" & strField14 & "' as a date or an integer in an sql statement. In otherwords is there such a function that can conver a string variable to a date

Hi I am using this code to email from code. I was just wondering if anyone could show me how to modify my code so I can add an attachement using a string variable to give a location of a file like "C:\text.txt" Function SendLotusEmail() On Error GoTo Ett_Trap Dim notesdb As Object Dim notesdoc...

How do you append a string value to the rowsource of a combo box

But what I want to do is slightly different. I have an access database installed on a network server. Everyweek the data in this database is refreshed with a new input from a text file. the textfile is a simple comma delimmeted file The problem is that MS access isnt installed on the...

its an integer

Hi I am tring to delete all week ids (weekid) that are greater than weekid from my table 3weekthisweek. Week id is unique number that identifies week. But I am getting a type mismatch error what am i doing wrong. Here is my query DELETE [3WeekThisWeek].[Week Number] FROM 3WeekThisWeek WHERE...

Hi I want to import a textfile in to a MS acces data base stored on a network drive. The only problem is that MS Access 97 isnt installed on the network computer so I was wondering if I could import in to the ms access data base using the jet engine?

Hi I want to import a textfile in to a MS acces data base stored on a network drive. The only problem is that MS Access 97 isnt installed on the network computer so I was wondering if I could import in to the ms access data base using the jet engine?

Hi I want to import a textfile in to a MS acces data base stored on a network drive. The only problem is that MS Access 97 isnt installed on the network computer so I was wondering if I could import in to the ms access data base using the jet engine?

Hi I want to import a textfile in to a MS acces data base stored on a network drive. The only problem is that MS Access 97 isnt installed on the network computer so I was wondering if I could import in to the ms access data base using the jet engine?

How do export an Access report to excel?

I want to use the send function in Access 97 to send email from an Access 97 form. The only problem is I do not have Outlook but I am using Lotus notes. How can I send email though Lotus notes with access 97? Thank You

Thanks for the help

How would I go about appending an access table to a sheet in Excel. My sheet in excel has a header that i want to keep. I want to import the access table under the header.