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 Chriss Miller 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 cbk10

  1. cbk10

    Inventory status change design...

    Hello world, I'm working on a database for a non-profit that loans out donated medical equipment to clients, and I need to figure out a good way to track inventory in stock, in use by a client, discarded, used for parts, etc. I have a good working donation form through which to first put data...
  2. cbk10

    Elaborate serial numbering project...

    Well sir, everything works like a charm. I appreciate your help very, very much. This is exactly what I needed, and I would never have come up with this on my own lol. Happy New Year, and thanks again.
  3. cbk10

    Elaborate serial numbering project...

    Ah, that does make a big difference doesn't it? Considering this is my first Access project, I won't forget that next time for sure. It seems to work fine now except for one problem: I can select AMW-1 for my first record, and then AMW-2 is genereated for my second record, but when I tested a...
  4. cbk10

    Elaborate serial numbering project...

    I understand. I used the site you suggested and have the file available at this link: http://www.4shared.com/file/4dEHprln/REMEDY_Inventory_Web.html I hope it isn't too convoluted to figure out...
  5. cbk10

    Elaborate serial numbering project...

    Tested, and still same as before. Plan B?
  6. cbk10

    Elaborate serial numbering project...

    Will do concerning the indexes and primary keys. The message box is working. It says You selected ___, So far I'm selecting AMW, so it's You selected AMW, so that is working. I like that function, so I'll probably keep it in the DB lol. I've also noticed if I create a record and get AMW-1...
  7. cbk10

    Elaborate serial numbering project...

    Ah, now we're making progress. I'm getting generated numbers in my Device Type Number textbox, but they aren't incrementally increasing. Present code is: Option Compare Database Private Sub Command12_Click() End Sub Private Sub Detail_Click() End Sub Private Sub...
  8. cbk10

    Elaborate serial numbering project...

    Glad to hear we are on the same page. Ok, I've tried and re-tried all that we've discussed, and I'm still not getting a number value to generate at all. I'm sure my syntax is just off, so I'm going to past the code from that form page and see what you think. We're still binding the Device Type...
  9. cbk10

    Elaborate serial numbering project...

    Ok, I need to make sure I'm on the same page as you. All of the code we are editing is at the form level yes? That's what I've been editing all along, and I should mention also that I have coded a concatenation for the prefix and assigned number at the form level, so all I need to get finalized...
  10. cbk10

    Elaborate serial numbering project...

    Yeah, this is weird. For a while, I was getting error messages, but now nothing is happening at all. The error messages were saying that the table name was incorrect/object couldn't be found. This is the code in the event builder for Device Type Number text box right now. Private Sub...
  11. cbk10

    Elaborate serial numbering project...

    I appreciate your reply. I had success with your suggestions for about 15 minutes, but after I modified the index properties, things got messed up. Any suggestions concerning that? Also, the "DTA_ID_FK='LC'" code, do I need to code it LC or leave it blank or _'d so that it will search for any...
  12. cbk10

    Elaborate serial numbering project...

    Hello world, I have a database in the works in need of an inventory serial numbering system, and I've having difficulty deciding how to best design three or four elements of it. First, I have several prefixes that I'll need to begin with (LC, APW, etc). I've called this field Device Type...
See more

Part and Inventory Search

Back
Top