Search results

  1. M

    Newbie trying to create a macro that will import from Excel

    Hi all I am a newbie ( well sort of been a long time since i did any macros or programming ) i have a problem that i need some help with. I am trying to create a macro that will import worksheets and place them into a table. I have been trying for a while so i thought that i will ask. The...
  2. M

    adding data from form to another table with check box yes/no

    Ok..... So i would have to change the structure of the Issues table for it to work properly. The whole idea is to do a QA Compliance for Electrical Projects ( Cable QA ) hence the structure is all the same across all the tables. So the the tables look like this: (if it will allow me to post a...
  3. M

    adding data from form to another table with check box yes/no

    Oh Ok So with the Issues table being the exact as the table that it is coming from with the same field names etc is there any easy way of adding the data (there is 22 Fields in each table that are all called the same name) Also just as an after thought i was also wanting to add the table name...
  4. M

    adding data from form to another table with check box yes/no

    Yes JHB that is the string i have been trying to use straight out of the database. Please tell me if i am doing it wrong. TIA
  5. M

    adding data from form to another table with check box yes/no

    Hi all I am trying to add information from a form created on table A to a table called Issues if a check box is ticked. I have tried the following code: Private Sub Issues_Click() Dim strSQL As String strSQL = "INSERT INTO Issues [(field1[, field2[, …]])] VALUES...
  6. M

    New User from Australia

    Hi all, Just trying to get myself back into Access programming, been out of it for a long time and needing some refreshing lol I run an IT Support firm in Queensland Australia. Looking forward to garnering as much info as my brains can handle lol MITSupport
Back
Top Bottom