Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.04 seconds; generated 30 minute(s) ago.

  1. Replies
    8
    Views
    481

    Re: Date Difference

    DaysPassed: INT(Date() - [DateField])
  2. Replies
    8
    Views
    481

    Re: Date Difference

    PMFJI,

    You probably have a time element in your date field.?

    Use the Int() function to jusy get the integer of the value.?

    HTH
  3. Re: Access: VBA to identify User and rights

    xenou
    Me.Name is the name of the form?
    gheyman
    You would need to store the name of the user with their login name and retrieve that for that particular user in someway, possibly another DLookup
    ...
  4. Re: Delete only unused related records in another table

    A InvoiceProgress table would link Invoices and Progress, but would have one record for each link.?
    So if two invoices were 'Ready for Dispatch", there would be two records in the table, one for...
  5. Replies
    3
    Views
    92

    Re: Save as Workbook

    You could use this method?

    https://www.thespreadsheetguru.com/blog/2015/1/13/how-to-use-vba-code-to-copy-text-to-the-clipboard

    Then
    ...
  6. Replies
    3
    Views
    92

    Re: Save as Workbook

    Care to say what the prompt is?

    Plus you say you want to save ddmmyyhhmmss in the title but are formatting the date only as yyyymmdd ? :confused:
  7. Replies
    1
    Views
    83

    Re: VBA Hyperlink

    I would have thought you would make the cell a hyperlink?

    https://stackoverflow.com/questions/36796608/create-hyperlink-from-cell-contents-in-excel-vba
  8. Re: Add a file to the "Recent Items" listing in Outlook Attachment

    Cross posted at https://www.access-programmers.co.uk/forums/showthread.php?t=307565

    It is common courtesy to advise that the question has been posted elsewhere, though you did have the courtesy to...
  9. Replies
    1
    Views
    566

    Re: Copy Command in Access 2013 VB Issues

    I would have thought you would need


    "C:\users\abc\desktop\split files\"


    or did the site remove the trailing slash?, as it did when I posted without the code tags?

    I would have thought...
  10. Replies
    8
    Views
    1,343

    Re: Access: Keep Navigation pane closed

    Don't forget to disable special keys or a F11 will undo all your hard work.:)
  11. Replies
    4
    Views
    977

    Re: Access: Change Query Sql with VBA

    Yes I admit, I use that method rather than continuation characters.
  12. Replies
    8
    Views
    1,152

    Re: Access: If Statement to Run Macro

    Hmm, strange.:confused:

    I did test in 2007 before I posted, as I was keen to know.
    Good to know though. Thank you.
  13. Replies
    2
    Views
    864

    Re: Access: Form w/table as Source Filter

    Why can't you use the filter



    Me.Filter = "Client Like ""*" & Me.txtFilter & "*"""
    Me.FilterOn = True


    Do you do any research before you post here. Google even?
  14. Replies
    8
    Views
    1,152

    Re: Access: If Statement to Run Macro

    No you can do it, do not even need the Application.Run, just use ModuleName.SuborFunctionName if the code is marked Private.

    HTH
  15. Replies
    15
    Views
    1,407

    Re: VBA write data from Excel to Access

    Use a recordset?

    https://www.exceltip.com/import-and-export-in-vba/export-data-from-excel-to-access-ado-using-vba-in-microsoft-excel.html

    Or with a query
    ...
  16. Replies
    4
    Views
    977

    Re: Access: Change Query Sql with VBA

    I always put my spaces at the beginning of the line. That way you do not have to scroll all the time to check your string.?

    Also I'd start using meaningful names for controls, Combo227 is not...
  17. Replies
    6
    Views
    1,397

    Re: how to update records through Forms

    Just bind the controls to the source data and it will do it for you.

    Use the form wizard to create a form when on the table or query that will be the recordsource for the form.
  18. Re: What guidelines I should follow while editing ‘Globe with blue arrow’ table

    It is as it states, edit any linked table desin wise in the back end, or delete the link and import the table into your front end.
    The latter is not something I would do.
    You can edit the table...
  19. Replies
    15
    Views
    2,196

    Re: What is early binding and late binding

    This explains it better than I could.
    From what you have mentioned so far, late binding woul dbe your choice and lose the vba intellisense.
    Alternatively develop in the same version.
    ...
  20. Replies
    3
    Views
    600

    Re: Access Split form Refresh Problem

    Not sure what else to suggest.
    I would have thought that you would execute a MakeTable query and not just open it.?, but that does appear to be one of the options?...
  21. Replies
    3
    Views
    600

    Re: Access Split form Refresh Problem

    Ever heard of the Refresh event for a form?

    https://docs.microsoft.com/en-us/office/vba/api/access.form.refresh

    However I think you would need the requery method, not the refresh?
  22. Re: "subform datasheet view will only allow me to edit when first opened"

    Well I'd start by seeing it it worlks when not filtered.?

    A lot of work went into the ESF on this link

    https://www.access-programmers.co.uk/forums/showthread.php?t=294421&highlight=emulated
    ...
  23. Re: "subform datasheet view will only allow me to edit when first opened"

    You just need a combo in the main form and a subform for that.

    I use the emaulated split form, but only as a replacement for a split form and make sure the datasheet/continous is read only. I use...
  24. Re: "subform datasheet view will only allow me to edit when first opened"

    removed
  25. Re: Tighten up vb code for Access Database

    Use the form's recordsetclone?

    https://accessexperts.com/blog/2011/05/23/when-to-use-a-forms-recordset-and-when-to-use-recordsetclone/
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4