Search results

  1. U

    User Defined Combobox Defaults on Bound Combobox?

    just a friendly bump, seeing if anyone out there could help me out. Thanks, Brian
  2. U

    User Defined Combobox Defaults on Bound Combobox?

    Hey All: After a lot of searching and trial and error, I have this code: Private Sub Check782_AfterUpdate() If Me.Check782 = True Then Me.Tracking_Number.DefaultValue = """" & Me.Tracking_Number.Value & """" Else Me.Tracking_Number.DefaultValue = False...
  3. U

    User Defined Combobox Defaults on Bound Combobox?

    Galaxiomathome: This sorta makes sense to me, I'm still very new to Access 2007, is there a demo of this that I can download from somewhere? It's easier for me to learn if I see it, if not, how would I start? Thanks for your help: Brian
  4. U

    User Defined Combobox Defaults on Bound Combobox?

    Hello All: I have a question...I need to have the option of the users who are using their own front ends to be able to select their own defaults in several bound comboboxes on a single form. These defaults constantly change during the day, so programming the default value will not work for...
  5. U

    Automatically Removing Certain Numbers in Text Box

    Scooterbug: Works like a charm...you're awesome. Question for you...how would I go about using 1 combobox (has to be bound) to filter a second (has to be bound). ie Combo A = Customers Combo B = End Users I need the Customer's combo to filter the End Users combo. I have a query that...
  6. U

    Automatically Removing Certain Numbers in Text Box

    Scooterbug: This kinda makes sense, would it be to much of a bother to maybe build a DB for me to see? I'm still going to try it like described and cross my fingers. Thank you so much: Brian
  7. U

    Automatically Removing Certain Numbers in Text Box

    Scooterbug: I'm so excited! Thanks to your help I figured it out and I'm am very pleased! I thank you for taking your time to help people like me in the whole learning process. Another one for you...I have searched here but need more details. I read as much as I could here about...
  8. U

    Time Lists in a Table

    Hello All: I was wondering if any of you know where I might find a table that has all times listed. (AM/PM). I tried searching here using "time" but didn't find anything. I found the master dates.mdb but sadly that didn't have any times listed. Thank you for your time: Brian
  9. U

    Automatically Removing Certain Numbers in Text Box

    Scooterbug: Well you're right. I tried it but I didn't notice any difference. It's OK, I learned something new. Something else, I have been looking around everywhere because I don't like asking so many questions, but I can't find this solution. One thing I would like to add to my...
  10. U

    Automatically Removing Certain Numbers in Text Box

    Scooterbug: Sure, I'm sorry that I didn't explain further. Here's the link that I found when looking up "performance for access 2007" in google. http://www.fmsinc.com/MicrosoftAccess/Performance/LinkedDatabase.html It states at the bottom that there should be noticable performance gains...
  11. U

    Automatically Removing Certain Numbers in Text Box

    Scooterbug: This is awesome! Thank you so much, everything is working as planned. After searching through this forum, I couldn't quite find the answers that I was looking for. I have split my DB and the back end is on our company shared drive and the front end is being used by two people...
  12. U

    Automatically Removing Certain Numbers in Text Box

    Scooterbug: That's awesome, it's much easier to learn looking at it than reading about it (for me that is)! I implemented it into my DB and I'm thrilled with the results! I have been searching all throughout to create a time tracking "system" in my DB. I need to track how long it takes to...
  13. U

    Automatically Removing Certain Numbers in Text Box

    That would be fantastic! Thank you.
  14. U

    Automatically Removing Certain Numbers in Text Box

    Scooterbug: You are truly awesome, thank you for all your help. I did exactly what you told me to do in regards to my table level lookup fields and removed them all. I have just one more request if you will. I have two tables: Projects and Inventory Both tables have a single bound form...
  15. U

    Automatically Removing Certain Numbers in Text Box

    Scooterbug: Hey that's a cool little trick. However, the value doesn't change when I select a different project name. In case you missed it, I attached a DB to my last post. Hopefully this will help. :) Brian
  16. U

    Automatically Removing Certain Numbers in Text Box

    Scooterbug: Again, I can't thank you enough for all your help. I'm learning more and more each day, but this little problem has me stumpped. Here's what I'm trying to do. I have two tables, Devices and Projects. They both have forms with the same names. I have a combo box (Project Name) in...
  17. U

    Automatically Removing Certain Numbers in Text Box

    Scooterbug: That works perfectly. Again thank you for all your help. I have another task I'm trying to learn about, eventully I think I'll get it. Thanks... Brian
  18. U

    Automatically Removing Certain Numbers in Text Box

    Scooterbug: Again thank you for all your help. Besides the actual lengths of the tracking numbers, there is nothing that is always present between the two numbers. I have scanned the two examples here. After I changed my DB with your supplied code, the numbers in red are showing in the...
  19. U

    Automatically Removing Certain Numbers in Text Box

    Scooterbug: You are the best...thank you so much. I just have one more thing, and I promise I wont ask you anything more again. In addition to FedEx, we also use UPS, now when I scan a UPS bar code (UPS bar codes are all the same length) the last two numbers show up in the "Modified Number"...
  20. U

    Automatically Removing Certain Numbers in Text Box

    Here you go, again, thank you for all your help.
Back
Top Bottom