Search results

  1. J

    duplicate main record + sub and sub -related records

    Hi, I moved with my tables to linked tables and everything is working pretty awesome but only one thing. The duplicate function. I hope someone can help me. Set up: Set new_tbl_main = db.OpenRecordset("factuur") -> main form Set new_tbl_sub_B = db.OpenRecordset("factuur_1e_regel") -> linked...
  2. J

    CDO .from -> using variables

    Hi There, I have a form where i can send email from. I want the user to fill in the senders name and the senders emailaddress. The name is fixed but the emailaddress not, i need some help! Here is the code With mail .To = Me.emailadres .From = "" & Me.afzenderNaam & "...
  3. J

    VBA OpenRecordset

    Hi There, I want to retrieve a value from a table. The value have to go to an other field on the same form. However, its not working because of error ''syntax error, operator is missing". The value in the table (FactuurFactuurnummerFN) is text and contains letters and numbers. Here is the...
  4. J

    Error code 3075

    Hi There, I got an error on this code: Public Sub logging(Activity As String, filterQ As String) CurrentDb.Execute "INSERT INTO activiteitenlog (gebruikersnaam,activiteit,stringq,windowsGebruikersnaam,windowsComputernaam) Values('" & TempVars("gebruikersnaam").Value & "', '" & Activity &...
Top Bottom