Search results for query: *

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...

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.

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...

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...

Tested, and still same as before. Plan B?

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...

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...

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...

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...

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...

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...

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...