Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SYZYGY

    What can be wrong with this DNSless connection. Can't UPDATE/INSERT

    I use TableWiz for creating connections and basic table production. It has worked every time.
  2. SYZYGY

    Setting focus on controls on forms from VBA functions

    Screen.ActiveForm will allow you to reference the form that has just lost the focus - see help file for details - does not work for subforms.
  3. SYZYGY

    Combining records into one field

    Easy (NOT) ========================================================== Option Compare Database Option Explicit Function fConcatChild(strChildTable As String, _ strIDName As String, _ strFldConcat As String, _ strIDType As String, _...
  4. SYZYGY

    LastUpdated

    I didn't write this but it works; it needs a table to store the log: ========================================================== Option Compare Database 'Use database order for string comparisons Option Explicit Const ahtcLogAdd = 1 Const ahtcLogUpdate = 2 Const ahtcLogDelete = 3 Function...
  5. SYZYGY

    Generating List Box of Tables

    Use TableDefs to populate the listbox
  6. SYZYGY

    Recurring events

    Has anyone managed to handle recurring events (bills, appointments etc.) in Access WITHOUT using the Outlook object model. I am developing an application for users who do not want outlook on their PCs.<br><br>It would be useful if I could generate a table/spreadsheet of future events either en...
  7. SYZYGY

    How can I &quot;refresh&quot; a Combo Box on form without &quot;refreshing&quot;

    You could also use DoCmd.Combo2.Requery from the update event.
  8. SYZYGY

    Need more efficient code.

    If you only need to run this code for records that have changed you could implement it at the form level. It would then only need to run once for each changed record.
  9. SYZYGY

    How Do You Store Images In Access?

    Please note that, although you can embed images, you may hit the Access file size limit. I had to move to SQL Server after 300 images.

Part and Inventory Search

Back
Top