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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Iainkerr01

  1. Iainkerr01

    Calling One Action from another Action

    Can anyone tell me how I can call an Action ("Private Sub Command99_Click()") from the end of a seperarte Action?
  2. Iainkerr01

    Seeing a recordset

    I want to optionally display the results in "notepad" following a query so that the user can see exactly the results of the query prior to sending emails.
  3. Iainkerr01

    Seeing a recordset

    Does it matter if I'm using DAO rather that ADODB?
  4. Iainkerr01

    Seeing a recordset

    How can I display the results of a Recordset?
  5. Iainkerr01

    Managing And's & Or's in a SQL statement

    I am creating a query system for my users so that they can generate a result set for themselves. The form has 4 columns as follows. 1. the 'Join' field (ie blank, and, or) 2. the search field name 3. the condition field (ie = , <>, Like) 4. the value of the field to search on. The form will...
  6. Iainkerr01

    Managing And's &amp; Or's in a SQL statement

    I am creating a query system for my users so that they can generate a result set for themselves. The form has 4 columns as follows. 1. the 'Join' field (ie blank, and, or) 2. the search field name 3. the condition field (ie = , <>, Like) 4. the value of the field to search on. The form will...
  7. Iainkerr01

    Managing And's &amp; Or's in a SQL statement

    I am creating a query system for my users so that they can generate a result set for themselves. The form has 4 columns as follows. 1. the 'Join' field (ie blank, and, or) 2. the search field name 3. the condition field (ie = , <>, Like) 4. the value of the field to search on. The form will...
  8. Iainkerr01

    Populate a combo box with feild names from a table, using DAO

    I am trying to create a form for users to generate their own query. To do this I need to be able to populate a combo box with the available field names wither from an existing table or form an existing query. Any help on this please?
  9. Iainkerr01

    How to Insert a record into a Recordset

    Hi John You're a star!! I used the "Code" method and it works a treat. Vary many thanks for your prompt reply. Iain
  10. Iainkerr01

    How to Insert a record into a Recordset

    Hi I am using a recordset to create an emailing system. Having written the email to the first of many recipients using a loop on the first recordset, I want to insert a confirmation to a second table with the date and email title, which is set up as a second recordset. Can anyone point me in...
  11. Iainkerr01

    Browing for a file

    Thank you. That works very well. Only forther question I have is how to alter the initial directory that is opened.
  12. Iainkerr01

    Browing for a file

    I am creating an Email system from within Access 2000. I=On the form, I wnat to create a "Browse" button to look for the file to be added as an attachment. Once the file has been found, I want to return the path and filename to a field on the form. Any ideas please?
See more

Part and Inventory Search

Back
Top