Search results

  1. A

    Sum of Column in Union Query

    Could someone assist me on how I should syntax this sql union query to return the sum of sales.charge and visits.charge? I have tried several methods to no avail :( SELECT SALES.DATE, [SUDDLE] & " " & [FIRSTNAME] AS FIRSTNAME, SALES.CHARGE, "SALES" AS SourceTable FROM (INNER JOIN CUSTOMER...
  2. A

    #Type! and #error when windowed

    I have a rather big report with a subreport. I copied the AccessTotalsSum of both the report and subreport to the header of the report(not page) for quick overview and made an extra very simple calculated field based on these two. Here is the weird thing. When it is full-screen everything shows...
  3. A

    VBA doesn't work and no errors popup

    I am trying to emulate the "delete" keyboard button in vba to delete a selected record from a subform, and I am trying to make this happen after running an update Query. Private Sub deletebtn_Click() CurrentDb.Execute ("qrupdateqty") Call DoCmd.RunCommand(Command:=acCmdDeleteRecord)...
  4. A

    Configuring visibility for a tab control page by setting an On Current event on a continuous form

    This is my first question post so sorry if not everything is clear, I am still getting the hunk of it. I am a very novice beginner willing to learn ^_^ I am trying to set up an order form for purchase of optionally more than one product that each have different customization options based on...
  5. A

    Hello everyone!

    I am a very beginner enthusiast of MS Access and I am looking to get all the knowledge I can get from the gurus of this community. Ty very much for sharing your insights!
Top Bottom