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 wOOdy-Soft 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 Ascentient

  1. Ascentient

    Filter Query of multiple records to single records

    Thanks PHV/Lespaul your suggestions appear to have worked as I have not heard back from the person using the program. Ascent
  2. Ascentient

    Filter Query of multiple records to single records

    I'll give this ago and report back. Thanks!
  3. Ascentient

    Filter Query of multiple records to single records

    Thanks PHV that worked. Let me ask this. Would it be possible to only list records where the customer bought from more than one place? CusterID Location SMITH1 LC1 SMITH1 LC1 SMITH1 LC3 JONES LC1 MILLER LC1 MILLER LC3 MILLER...
  4. Ascentient

    Filter Query of multiple records to single records

    I had originally posted a topic at the following thread for assistance however this won't work. http://www.tek-tips.com/viewthread.cfm?qid=1202945&page=2 To me the same concept applies however, I am only working with one table now. I have a ticket table that contains ticket information for...
  5. Ascentient

    Checking record/query locks on save in multi-user environment.

    Thank you. I will research and implement as needed. I will let you know how it turns out.
  6. Ascentient

    Checking record/query locks on save in multi-user environment.

    Does anyone think that this would work? lblSaveinProgress.Visible = True Do While rs.EditMode = dbEditInProgress DoEvents Loop lblSaveinProgress.Visible = False Ascent
  7. Ascentient

    Checking record/query locks on save in multi-user environment.

    Sorry for the length. Background I have a ticketing database that contains all of my forms, queries and a couple of non-linked tables and many linked tables. The primary tables are in a separate database. The "forms" database is compiled into MDE's and placed on two workstations, where the...
  8. Ascentient

    Disable Mouse Wheel On Sub-Form

    Well, as much as I would have liked to have done it entirely in the program, I used the following link: http://support.microsoft.com/?kbid=278379 Make sure to follow the directions to the T. Ascent
  9. Ascentient

    Disable Mouse Wheel On Sub-Form

    Do you have a link for this? Ascent
  10. Ascentient

    Using Modules to call Switchboard

    I am working with FAQ http://www.tek-tips.com/faqs.cfm?fid=5263 to override wheelmouse movement so it does not add blank records to my tables. The program I am working on is driven by Switchboards. How can I incorporate this by placing the ENUM statement in a module? Ascent
  11. Ascentient

    'Object doesn't support this property or method' error when upsizing

    Do the properties your forms/subforms allow edits?
  12. Ascentient

    Tabbing through controls appends new record

    jkl0, Thank you for the easy fix. Ascent
  13. Ascentient

    Tabbing through controls appends new record

    I tried that, but when my form loads I get a blank detail section. (bound form) Ascent
  14. Ascentient

    Tabbing through controls appends new record

    When controls are tabbed all the way through a form with bound controls it automatically adds the record to the table. Is there a way to prevent this? It is placing an invalid record in a table and I would like to prevent this from happening. Ascent
  15. Ascentient

    There's always a way...

    Andy, your post should be in a new thread, since it is a separate issue. However, your statements suggests that you might need to look at the .requery method. Ascent
See more

Part and Inventory Search

Back
Top