Search:

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

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Replies
    3
    Views
    497

    Re: PDF Created from VBA Button won't open

    Simple but effective! Thanks
  2. Replies
    3
    Views
    497

    PDF Created from VBA Button won't open

    I've got this code below which creates a PDF document. The error message appears saying I'm unable to open the document because:


    it is either not a supported file type or because the file has...
  3. Replies
    12
    Views
    2,204

    Re: VBA - Populate Word Document

    It makes sense now! I misread it at first. Thank you so much
  4. Replies
    12
    Views
    2,204

    Re: VBA - Populate Word Document

    Finally got there! Thanks for the support.
    One (Hopefully) final question...

    The "Invalid use of Null" appears when one of the fields I want to add to the word form is blank. Is there a way to...
  5. Replies
    12
    Views
    2,204

    Re: VBA - Populate Word Document

    "Run-time error '94':
    Invalid use of Null"

    When I click 'Debug', it highlights this row:

    .FormFields("txtAddressLine2").Result = Me!AddressLine2

    This can't be this bit of code which is...
  6. Replies
    12
    Views
    2,204

    Re: VBA - Populate Word Document

    I've finally got round to looking at this again and it works almost perfectly! The only problem I have now is that it only works if I have Word open before clicking on the button. Is there a way to...
  7. Replies
    12
    Views
    2,204

    Re: VBA - Populate Word Document

    I've managed to get the code below to be triggered when a button is clicked but when it opens Word, it doesn't open the document or display any page. Any ideas?


    Function GenerateAgreement()Dim...
  8. Thread: Query Count

    by QandAdam
    Replies
    3
    Views
    663

    Re: Query Count

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

    by QandAdam
    Replies
    3
    Views
    663

    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:
    ...
  10. Replies
    3
    Views
    884

    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
  11. Replies
    3
    Views
    884

    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
  12. Replies
    12
    Views
    2,204

    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...
  13. Replies
    1
    Views
    543

    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...
  14. Replies
    1
    Views
    177

    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...
  15. Replies
    9
    Views
    1,178

    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...
  16. Replies
    9
    Views
    1,178

    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
    ...
  17. 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)
  18. Replies
    9
    Views
    1,178

    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.
  19. 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...
  20. Replies
    9
    Views
    1,178

    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...
  21. Replies
    11
    Views
    1,428

    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>...
  22. Replies
    11
    Views
    1,428

    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...
  23. Replies
    11
    Views
    1,428

    Re: Excluding Records from Query

    Amazing! Thankyou so much
  24. Replies
    11
    Views
    1,428

    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...
  25. Replies
    11
    Views
    1,428

    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
Results 1 to 25 of 30
Page 1 of 2 1 2