Recent content by PhilsAVBAGuy

  1. P

    INSERT INTO bracket error

    I see a problem with the structure of you SQL... try this: "INSERT INTO Classes_taken([Emp_ID],[Class_ID])VALUES(" & forms![Class_Catalog subform]![txtEmp_ID] & "," & forms![Class_Catalog subform]![TxtCID] & ");" I know you have to separate the call to the form value from the text passed to the...
  2. P

    Code to fill data with zeros or spaces

    I hope someone can help with this easily. I don't know how easy it was but it took me 4 hours and I have a solution: First I will say that you should limit your table information by using a MakeTable Query to select smaller recordsets to avoid using up the recordset memory while adding so many...
  3. P

    New member - PhilsAVBAGuy

    Hello everyone! Glad to be on here, I've used this forum as a reference and felt like I need to be more involved. I am a former VBA application designer and currently am helping rebuild our company's in-house Access/SQL database. Looking forward to helping and being helped by people who share my...
See more
Back
Top Bottom