Search results

  1. A

    Question Insert data from one table into a different field in another table

    I have a table tbl_TmpTrans_ByDate with the following data NQCG_Month Category Total_Amout Jan-19 Credit $220 And I have a master table tbl_SumMonth with fields NQCG_Month Credit Debit ...........etc I want to insert into the credit field in tbl_SumMonth the...
  2. A

    Sum Total data and Save to a table with VBA

    This is my test data (qry_Income_ByDate) NQCG_Month Category Amount Jan-19 Credit $70 Jan-19 Credit $20 Jan-19 Debit $245 Jan-19 Credit $60 I want to perform the following: 1. DSum the [Amount] according...
  3. A

    CREATE TABLE within VBA

    I want to create a temporary table with the SQL "CREATE TABLE" option within VBA and use the Execute command instead of DoCmd.RunSQL. I just want the Table structure without any records. The code fails on the Execute command. I can not see anything wrong with this code. Please help Dim db As...
  4. A

    Substituting a record into a DoCmd

    I have a query (qry_receipts) which contains the members email addresses. I can create an individual receipt (rpt_receipts) for each member and then I want to be able to email their receipt as a PDF to only that member. This means that the members email address created by the query (tempQry)...
  5. A

    Example of crosstab query in VBA for Access 2010

    Can anybody please helop me with the syntax with this crosstab query in Access 2010. It will not work. Private Sub cmd_SumBogger_Click() Dim strCrosstabQuery As String Dim strMakeQuery As String Dim strUpdateQuery As String DoCmd.SetWarnings False ' turns off popup warnings strCrosstabQuery = "...
  6. A

    Update a table from a query using VBA

    Can someone please help. I am using Access 2010. I need to update data in a table of 5 fields from a query but I need to do this with VBA code or even using the SQL update command within the VBA code.
  7. A

    Save an expression within a query back to a table

    I created an expression of a certain fields in a query. I would now like to save all the fields including the expressions either back to the original table or to a new table. Is this possible?
Top Bottom