Search results

  1. J

    VBA To Create Query

    I have the following info from my SQL view in access, I want to automate a button to create the query, can someone please help with the vba code. SELECT CustomerT.CustomerID, CustomerT.FirstName, CustomerT.LastName, CustomerT.State FROM CustomerT INNER JOIN ContactT ON CustomerT.CustomerID =...
  2. J

    Create Table Yes/No Field

    Ok, so I used the following script to first set the field to text and then change it to yes/no. Set Db = Application.CurrentDb Set tdf = Db.TableDefs("1Testing") ' 1Testing is your table name ' First create a field with data type = Text Set fld1 =...
  3. J

    Create Table Yes/No Field

    I have the following vba script and I can not get the yes/no field to work, also can you please help with adding field properties of required = yes and the text field to be 50, just examples are fine and I will update what I want. Thanks Sub test() Set Db = Application.CurrentDb...
  4. J

    VBA To Update Query

    Thanks for your help, much appreciated
  5. J

    VBA To Update Query

    Hi All, I am new to Access. I am after a vba script to run an update query. I have a table named MYOB_Invent. I have a Query Named MYOB_Update. The query is showing records where my field named Test1 is null. I want to update records with null in the field to today's date (the date of the day...
Back
Top Bottom