Search results

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.

Go in to the advanced section of the import data screen and set up the import specification to import all fields as text

I am using the following sql statement to populate a listbox with rows from an Orders query. SELECT [Shipping Details].[Line No], [Shipping Details].[Item No], [Shipping Details].[Customer PO No], [Shipping Details].Qty, [Shipping Details].[Serial No], [Shipping Details].Packslip, [Shipping...

The row source is a sql query I am passing to it.

Is there any vba command that removes the text that appears in a combo box?

What I did when I had this problem was I set the value of all fields being imported in my import specification to text. Then when I had all the values in access i seperated them with queries and made a new table with a union query followed by a make table query