Search:

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

Page 1 of 8 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    7
    Views
    286

    date entry form shoudl user a single table as the...

    date entry form shoudl user a single table as the record sources. related tables will be in sub forms. Lookup table use a list box or combo box control to show the related data from the lookup table....
  2. Replies
    11
    Views
    538

    Are you saying that restoring the corrupted...

    Are you saying that restoring the corrupted object from a working backup copy did not fix it?
  3. Replies
    11
    Views
    538

    Before you don anything else make a backup! ...

    Before you don anything else make a backup!

    You have a corrupted object. In most cases you will have to restore the object.


    You will need to restore the corrupted object from one of your...
  4. Replies
    6
    Views
    426

    I will second the MZ-Tools (Click Here) (MZ-Tools...

    I will second the MZ-Tools (Click Here) recommendation. Many VBA developers I know say it is a MUST HAVE for anyone working in VBA (Word Macros).

    The great thing about MZ-Tools is that is a VBE...
  5. I assume that the query qryDataAudit was an...

    I assume that the query qryDataAudit was an append query that was based on the Union Query.

    Is that is not true you need to make an append query that use the saved union query as the data...
  6. Your code is working correctly as written. You...

    Your code is working correctly as written. You are telling the query to Open (OpenQuery) not Execute or Run(RunSQL). Which is what you described.

    If you want an append query to actual Execute/Run...
  7. Replies
    7
    Views
    619

    Lou, I just sent you a private message.

    Lou, I just sent you a private message.
  8. Replies
    7
    Views
    619

    Lou, Check out the Access templates that are...

    Lou,

    Check out the Access templates that are available when you create a new database. They are great for demonstrating form design techniques. I suggest the Invoice Template. Also make use to...
  9. Replies
    5
    Views
    288

    [SOLVED] That has always been there. It is a database...

    That has always been there. It is a database locking system file create by the ACE database engine used by Access.

    The locking file is used to allow multiple users to edit at thee same time.
    ...
  10. Replies
    5
    Views
    288

    [SOLVED] Did you try the combo box search wizard (Option...

    Did you try the combo box search wizard (Option 3) ?

    Here is a Microsoft video tutorial:...
  11. Alan, You're welcome. Glad you got it sorted...

    Alan,

    You're welcome. Glad you got it sorted out.

    I also have an Access 2003 Runtime install package I used when I deployed 2003 solutions. I did no offer it since Access 2003 and older are no...
  12. I have an article on the subject of trusted...

    I have an article on the subject of trusted locations here: Trust Center in Access 2007 and 2010 Trusted Locations (Click Here)
    *** scroll down to the section: Setting the Trusted Locations when...
  13. Alan, Glad to here found a solution. To...

    Alan,

    Glad to here found a solution.

    To use the Access 2007 or later runtime you have to create a trusted location for the database or set the macro security level to low by making a windows...
  14. The database will always open. If there is not a...

    The database will always open. If there is not a s form display automatically then you the Access shell with a blank window when the form would be shown.

    If you have Access 2007 or later then give...
  15. Alan, The 64-bit version should be avoided. It...

    Alan,

    The 64-bit version should be avoided. It is much different that the 32-bit. There are lots of compatibility issues and bugs.

    I would only use the 32-bit version to open your older .mdb...
  16. That is not true. The Access Runtime can only...

    That is not true.

    The Access Runtime can only "read" database and "execute". The Runtime version is the same bits as the full version with all the designers and navigation pane disabled.

    The...
  17. Yes, it is possible to have reminders set. We...

    Yes, it is possible to have reminders set.

    We rally need more information about how this needs to work and your environamnet.

    Do you use Exchange Server?

    If using Exchange sever you could...
  18. Replies
    5
    Views
    310

    In Access 2010 and later the Calculated data type...

    In Access 2010 and later the Calculated data type is an expression not a result. The expression is calculated on the fly as needed. The do not violate the rules of data normalization.

    "do them on...
  19. Replies
    5
    Views
    310

    This may help: Referring to a Field in the...

    This may help: Referring to a Field in the Previous Record or Next Record
  20. Replies
    13
    Views
    1,363

    This may help: Program Compatibility...

    This may help: Program Compatibility Troubleshooter in Windows 10 / 8 / 7

    If you hardware supports visualization and you have the Windows XP CD and key then I would recommend setting up a Virtual...
  21. Replies
    13
    Views
    1,363

    Try stating Access directly by right-clicking and...

    Try stating Access directly by right-clicking and select run as administrator. This will set some registry key. Exit Access. Launch as normal. That may fix the error messages.
  22. Nancy, Access 2013 sis not change much in the...

    Nancy,

    Access 2013 sis not change much in the desktop database side.

    I have Access 2007 and 2010 databases that run fine with Access 2013.

    There were some features the were depreciated in...
  23. Thew link you posted was for Access 97 to...

    Thew link you posted was for Access 97 to 200/2002/2003. Not 2007 and later.


    This is the link for 2003 to 2007 and later: http://allenbrowne.com/Access2007.html
  24. The VBA editor and the VBA runtime engine are not...

    The VBA editor and the VBA runtime engine are not the same thing.


    In Office 2003, all the application that have VBA (called Macros in some products) all share the same VBA Edits. It is also...
  25. Replies
    30
    Views
    3,285

    You may also want to try the Windows AI meeting...

    You may also want to try the Windows AI meeting that I posted earlier. At least give it s test to rule it out.
Results 1 to 25 of 200
Page 1 of 8 1 2 3 4