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

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

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.

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

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

I am setting the value of a number of variables on a vb form to query a table. My problem is that the date I pass is not being recognised. The date is being passed in a date variable in a short date format. Here is my sql statement strDate is the date I am passing SELECT [Shipping...