Search results

Hello All, I am attempting to insert a record with selected data into a temp table and I am getting "Run-time error '3075': Syntax error in (comma)...". Here is the code: Private Sub XferDataToTempTable() Dim db As Database Dim strSQL As String Set db = CurrentDb strSQL = "INSERT INTO...

I have a form that outputs data to an excel templete. I built and tested it on my machine, and it works just fine. When I attempt to change the syntex to a network drive I get the run time error. Public Sub CreateSpreadsheet() Dim RecSet As Recordset Dim MyExcel As Excel.Application Dim...

I have an inventory form where I have To and From fields (moving a device From somewhere To somewhere else). I have an unbound search field that sets up the form, and in the AfterUpdate I some house cleaning by moving the current To values to the From values, then clearing the To values with...

My intent with the code below is to copy the Me.Serial value into the hostname, than check the Me.Serial value and if it begins with PDS, strip that off and write the new number as Me.Serial. What happens is I get two record sets in my table - one that has no Me.Serial and the hostname, the...

I'm having difficulty with an Insert Into - I have the following code: Private Sub Serial_AfterUpdate() Dim MyDB As Database Dim hostname As String Set MyDB = CurrentDb hostname = Me.Serial DoCmd.RunSQL "INSERT INTO tblTemp (tmptoHostname) VALUES (" & hostname & ")" If Me.Serial...

Hello All, I am having the worst time trying to figure out something that is so simple - but I just cant seem to get it. I have a function that grabs the user name; I am trying to use that value as data for some fields. I just cant figure out how to write that data into a record. This is what...