Recent content by Arcanant

  1. A

    Sum of Column in Union Query

    No but they are similar. The union works fine. I have found the answer to my question and now everything works as intended (for now :P ) What I ended up doing is make small seperate queries with calculations on each one till I reach the final result.
  2. A

    Sum of Column in Union Query

    That is what I thought, that I would have to make small queries at the end but I was wondering if there is a way to make it in one go. All my tried ended up bringing messed up values and the issue is that the dates are inconsistent with the criteria and it makes up non existing values. Thank you...
  3. A

    Sum of Column in Union Query

    No, it is one form with two fields "From Date" and "To Date"
  4. A

    Sum of Column in Union Query

    I tried that but they return empty cells. I started making a new query based on this union query and doubled clicked the CHARGE as the field then clicked on the SUM and chose Sum. I run the query and it doesn't show anything. EDIT: I am dump, I think I get what you mean, let me try it.
  5. 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...
  6. 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...
  7. A

    VBA doesn't work and no errors popup

    Hello and thanks for your replies. I actually went ahead and made a Delete Query with criteria and that works for me. Thank you for your attention and replies.
  8. 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)...
  9. A

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

    Hello and ty very much. I can since all the info is fake anyway for practice but I am afraid everything is in Greek ... 😕 I have split the tables and the forms in separate files. The tables are in the folder "ΠΙΝΑΚΕΣ", you can update and re-link them at the Styllas(1).accdb file. The form I am...
  10. A

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

    So I configured the code like this Option Compare Database Private Sub comboChooseProduct_AfterUpdate() End Sub Private Sub Form_Current() If Me.category.Value = "Chair" Then Me.TabCtlproductoptions.Pages("Chair").Visible = True ElseIf Not Me.category.Value = "Chair" Then...
  11. 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...
  12. 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