Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.08 seconds.

  1. Replies
    11
    Views
    126

    As far as I recall from Access 2007 onwards you...

    As far as I recall from Access 2007 onwards you can output a report to PDF in the DoCmd.OpenReport command, it is specified by the type of output (acFormatPDF)
  2. Replies
    10
    Views
    641

    Access provides a good solid solution in the...

    Access provides a good solid solution in the form/subform way of doing things with virtually little VBA code required.

    I won't try and talk you out of the way you have chosen, I have never gone...
  3. Replies
    10
    Views
    641

    I cannot understand why you don't use...

    I cannot understand why you don't use Form/SubForm logic instead.
  4. Replies
    7
    Views
    282

    As Boyd has said you should use a master form and...

    As Boyd has said you should use a master form and sub forms.

    The master source should be a table or query of the table applicable (eg. Table A).
    Sub form B's record source should be a table or...
  5. Replies
    2
    Views
    199

    As far as I know all you need is Me.Requery in...

    As far as I know all you need is Me.Requery in the Button VBA code, after the inserts are done.
  6. I have found a solution in Eileen's Lounge using...

    I have found a solution in Eileen's Lounge using a unbound controls and conditional formatting to fudge it.
  7. In Access 2007 change selected subform's controls back color

    Prior to adding a new record or changing an existing record I wish to change the BackColor for selected controls.

    This is to apply to a subform's records. Can this Apply to a continuous form?
    ...
  8. Replies
    5
    Views
    284

    [SOLVED] Any .laccdb file is used to lock records when you...

    Any .laccdb file is used to lock records when you are operating the FE to it, it allows for multi users.

    The file remains open while any FE is open, only when the last FE is closed will this file...
  9. Replies
    1
    Views
    396

    What is tbllocal.ID and tbllocal.local_cd. ...

    What is tbllocal.ID and tbllocal.local_cd.

    Where does the line showing only 2719 come from?

    One way would be to populate a table with the above, then calculate that column into a new field,...
  10. Replies
    11
    Views
    827

    [SOLVED] For a start I would not use Row.Source to search....

    For a start I would not use Row.Source to search.
    I would leave the Row.Source as a standard query for the table Operator.
    I would use the Me.Flter and Me.FilterOn events.

    is the Operator...
  11. Replies
    10
    Views
    1,460

    I opened one the other day using TeamViewer, I am...

    I opened one the other day using TeamViewer, I am in Philippines the remote computer in Melbourne Australia.
  12. Replies
    7
    Views
    2,680

    Why not have another field for title, say...

    Why not have another field for title, say TitleAlternate where you don't store these words, the query using the new field.
  13. Replies
    2
    Views
    1,202

    You don't have table tblTaakRapporteringDetail...

    You don't have table tblTaakRapporteringDetail defined for the 2nd subfom.
  14. Replies
    9
    Views
    2,148

    Browni has nailed it, you said that the shortcuts...

    Browni has nailed it, you said that the shortcuts were for the table, forms, etc, not the database file itself.
  15. Replies
    9
    Views
    2,148

    I don't know what you have because the Northwind...

    I don't know what you have because the Northwind database has no shortcuts (what ever that is), they may link to another database for it's tables though, it's been a long time for me there.
  16. Replies
    9
    Views
    2,148

    Look at the NorthWind database that MS has, it's...

    Look at the NorthWind database that MS has, it's free, it may have been installed with your version of Office.
    Off the top of my head the schema I think you need is:
    Customers, OrderHeader,...
  17. Replies
    7
    Views
    1,661

    A point against the 2 table approach is what...

    A point against the 2 table approach is what happens if inactivity is flagged incorrectly, it's far easier to unflag records as against transferring these records back again.
  18. Replies
    2
    Views
    530

    Thanks Satrow, what I did before I saw your...

    Thanks Satrow, what I did before I saw your message was to reset the defaults in Google Chrome and all is ok.
    I will check out that link though.
  19. Replies
    2
    Views
    530

    iStartSurf virus removal

    I have the above virus on my computer.
    I have eradicated it from IE (I hope).
    How do I do the same in Google Chrome?
  20. Replies
    7
    Views
    1,661

    Another way is to use just one table for both...

    Another way is to use just one table for both active and inactive records, you will need another field to distinguish between the two. Makes querying easier.
  21. Replies
    4
    Views
    754

    [SOLVED] Does using the Me.Filter command work?

    Does using the Me.Filter command work?
  22. Replies
    4
    Views
    1,516

    check references to see if any are missing.

    check references to see if any are missing.
  23. Replies
    1
    Views
    393

    From memory, I think the Choose command does what...

    From memory, I think the Choose command does what you want.

    The correct command is Switch.
  24. Replies
    30
    Views
    4,456

    Have you linked the excel sheets to Access, that...

    Have you linked the excel sheets to Access, that may be the problem.

    What is the switchboard meant to be doing?
  25. if the field is always like (A/1/1 or 2 digit...

    if the field is always like (A/1/1 or 2 digit number) then why not create a calculated column that converts A/1/8 to A/1/08, then sort on that.
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4