Search:

Type: Posts; User: QandAdam; Keyword(s):

Search: Search took 0.00 seconds.

  1. Thread: Query Count

    by QandAdam
    Replies
    3
    Views
    369

    Re: Query Count

    AMAZING! That is easy! Thanks for the help and advice
  2. Thread: Query Count

    by QandAdam
    Replies
    3
    Views
    369

    Query Count

    This is hopefully a simple one.

    How can I count records based on criteria? So it would be a count of 'Active' ('Status' Field) for each 'Group'.

    I'm looking to go from something like this:
    ...
  3. Replies
    3
    Views
    600

    Re: Show Duplicates Across 2 Queries

    How would this filter to only show the duplicate RegNos with different statuses?

    E.g.
    Instead of this:

    <tbody>
    RegNo
    Status
  4. Replies
    3
    Views
    600

    Show Duplicates Across 2 Queries

    I have 2 queries:

    Both Queries have the same fields and are based on the same table (tblBusinesses) but have different criteria


    <tbody>
    Query Name
    Criteria
  5. Replies
    1
    Views
    419

    VBA - Populate Word Document

    I've been looking at different code to use for this but can't find one that works.

    I'm wanting to create a button which populates a word document with the information currently displayed on the...
  6. Replies
    1
    Views
    465

    Why is my Report Printing (VBA)

    I've got the code below to save a report as a PDF at the click of a button. The button works fine, but whenever it is clicked, the report is also printed out. Does anyone know why this would be and...
  7. Replies
    1
    Views
    145

    VBA - Search Google

    I have the following code which triggers when the user double clicks on a field:


    Application.FollowHyperLink "http://www.google.co.uk/search?q=" & BusinessName

    This works fairly well and...
  8. Replies
    9
    Views
    1,060

    Re: Combo Box on Msg Box VBA

    Ok, for the Form - I'm struggling to get my head around it (sorry!)


    What would the Record Source of the Form be? I'm not able to select the current query because it's an update query.
    What...
  9. Replies
    9
    Views
    1,060

    Re: Combo Box on Msg Box VBA

    I have this button currently. Here's a breakdown of what the current set up is like:

    Form Button:

    DoCmd.SetWarnings False
    DoCmd.OpenQuery "qryAllocateBatch"
    DoCmd.SetWarnings True
    ...
  10. Re: Update Text Field Based on Combo Box Field

    Is there a way which this could only run if the value changed from "Open" to a different value? (Also the combo only has the one column - the description)
  11. Replies
    9
    Views
    1,060

    Re: Combo Box on Msg Box VBA

    How would I do this? The current query is an Update Query and I don't have the option to select it as the Form Data Source.
  12. Update Text Field Based on Combo Box Field

    On a Form, there is a Combo Box Field which lists different Statuses (e.g. Open, Pending, Closed).

    Is it possible for the following to happen?

    When 'Status' is changed from 'Open', add the...
  13. Replies
    9
    Views
    1,060

    Combo Box on Msg Box VBA

    I have a button which shows a Pop-Up Box asking the user to enter a name of a staff member. Is it possible to edit the Pop-Up so that instead of showing a free text box (where the user can enter...
  14. Replies
    11
    Views
    1,268

    Re: Excluding Records from Query

    The last column is another field in the table.

    The table fields I'll use are:
    Batch, Date Allocated, Salesperson, Currently Allocated

    E.g. The table will show this for batch ABC1

    <tbody>...
  15. Replies
    11
    Views
    1,268

    Re: Excluding Records from Query

    My next question is sort of related to this but I'm not sure if I should ask this here or not so let me know if I need to post a thread.

    If I wanted a different query to show me a list of all...
  16. Replies
    11
    Views
    1,268

    Re: Excluding Records from Query

    Amazing! Thankyou so much
  17. Replies
    11
    Views
    1,268

    Re: Excluding Records from Query

    This returns all batches where 'Alan Smith' is not the most recent Saleperson BUT if Alan is the most recent person then the query returns the record prior to Alan for that specific batch.

    What...
  18. Replies
    11
    Views
    1,268

    Excluding Records from Query

    I have an Access Database Table for Sales which lists multiple records and the Salesperson associated. Example below:


    <tbody>
    Batch
    Salesperson Name
    Date Allocated


    1234
  19. Replies
    2
    Views
    446

    VBA to Add 1 to Highest Number

    Very complicated one here so I won't explain why I need this..

    I want to create a button that when clicked a pop-up appears saying "Enter URN". When the user enters this info, the record with that...
  20. Replies
    0
    Views
    299

    MS Access - Create a Stacked Chart

    I have a bar/column chart on a report which is based on fields from a query.

    Horizontal axis is the [WeekNumber] field and the Vertical Axis is [StaffName]. This works fine!

    However, I want to...
  21. Replies
    2
    Views
    560

    Update Query Based on IF Statement

    I have a button which runs an update query. When the user clicks on the button, a pop-up appears asking the user to enter the missing info (e.g. [ENTER ID NUMBER] and [ENTER STAFF NAME] - This will...
  22. Replies
    3
    Views
    499

    Re: Showing Latest Records in Query

    Thank you the first part worked perfectly!

    Do you know how I could use VBA and recordsets for the second part? I'm new to VBA and I wouldn't know where to start with recordsets
  23. Replies
    3
    Views
    499

    Showing Latest Records in Query

    I have a query which displays records linked to companies based on the ID:


    <tbody>
    ID
    Name
    Date
    Current
Results 1 to 23 of 23