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!

Search results for query: *

  • Users: JJman
  • Order by date
  1. JJman

    Weird Form Behavior

    Lo and behold... that's what happened. Sometimes it's the "make sure it's plugged in" kinds of issues that bring developers to their knees. :) I'll deal with that and also put some locking on the form. Thanks for your help!
  2. JJman

    Weird Form Behavior

    Actually, as far the first issue, my understanding is that one person's information would only overwrite another's if they were editing the same field, which they are not. I assumed they could all use the form at the same time without a problem so long as they stay out of each other's fields...
  3. JJman

    Dependent Combo Boxes

    We have several instances of this in our database. Simply use an expression as a field in the SQL for the second combo box that references the first one as it's criteria. Then, on the afterupdate event of the first combo box, requery the second. Como1 afterupdate event to requery combo2...
  4. JJman

    Weird Form Behavior

    We have a form which tracks information for certain tasks. Each day, different users record the information related to his or her own task in specific fields, and leave all other fields alone (there is no security in place to prevent it, they just don't). We're having an issue where each user...
  5. JJman

    Query Not Reading Memo Field??

    Just a side note to say I haven't actually had time to try it yet. I temporarily changed it back to a text field. Hopefully TheAceMan (or someone.... anyone!) will come to our rescue. :)
  6. JJman

    Can't Find Project or Library...

    Sounds like another A2k bug that throws sand in the gears... Thanks for the heads-up.
  7. JJman

    Can't Find Project or Library...

    When the code below runs, it highlights the first "Left" keyword and gives me a message saying it can't find the project or library. Any help is appreciated. Private Sub ChildID_AfterUpdate() Dim teststring As String Dim teststring2 As String Dim teststring3 As String...
  8. JJman

    Criteria To Select Only Letters

    Like "[a-z][a-z]*" worked great. Thanks to both of you!
  9. JJman

    Criteria To Select Only Letters

    I'm working in an Access Project to put criteria on an expression field to only show records where the left two characters are letters, not numbers. I've tried unsuccesfully using wildcards specific to each. Any help is appreciated!
  10. JJman

    Compound Unique Indexing

    Wonderful! Muchas Thanks! :)
  11. JJman

    Compound Unique Indexing

    Can anyone tell me how to set up compound unique indexes in A2K (as opposed to compound PK's)? I've heard there is a way but can't find information on it in Help or any books. Thanks!
  12. JJman

    Syntax for Subquery

    Ok, I'll give this a shot. I was hoping I wouldn't have to go this route if I could avoid it, only because the table has almost 10 million rows and even optimized queries take quite a while to run, especially since this is only one of two nested queries. I'll let you know how it goes. Thanks...
  13. JJman

    Mysterious Error Message

    Thanks Hap! Also very good info!
  14. JJman

    Mysterious Error Message

    Thanks! These will be very helpful!
  15. JJman

    Mysterious Error Message

    Some months ago one database here began getting an error message when users tried to open it saying "Error accessing file. Network connection may have been lost." The network connection was fine, however. Users were completely unable to use the database, though it can be opened with the...
  16. JJman

    Syntax for Subquery

    I'm using the make-table query below but I only want it to give me one record for each Student_ID (alias for dbo_corr.from_descr), where it has the maximum dbo_corr.entry_date value. I know I need a HAVING clause with a sub-select statement, but don't know the syntax to do this. Help! SELECT...
  17. JJman

    Query Not Reading Memo Field??

    Oops! Forgot to post the SQL... SELECT A.Primary_Unusable_id AS PrimaryID, B1.Unusable_description AS Primary_Desc, A.Secondary_Unusable_id AS SecondaryID, B2.Unusable_description AS Secondary_Desc, A.Unusable_date, A.Child_Key, A.Child_name, A.Additional_Comments, db_country.SPM_name FROM...
  18. JJman

    Query Not Reading Memo Field??

    I changed a text field in a table to a memo field to allow as much space as needed to store text, however, now a query that was selecting that field only displays two characters (that I can't reproduce here). I use the query to do a mail merge, and now the mail merge displays things like ?', ?X...
  19. JJman

    Formatting Field to Bold Red

    Both ways worked great, Tony. Thanks again. May I ask where you got the value of 700 for bold formatting? I'd love to have a list of things like that.
  20. JJman

    Formatting Field to Bold Red

    Hi Acdel, I was using conditional formatting before, but it wasn't working. It would apply the formatting even when the value was only 2. Very strange, I know. This is why I decided to code it instead. Anyway, I'll give Tony's ideas a shot. Thanks to you both!

Part and Inventory Search

Back
Top