Recent content by skidude2000

Ok, I see what you're saying. And that is pretty much the exact setup I have going. I tried using the SQL SELECT like you suggested. I have it finding the orphaned groups in tblGroupAcct, in my case, and it seems to work well. Thanks for your help! Cheers :D

Ok, that makes sense. I am still confused about one thing though: multiple group accounts on one machine. Let's say that a computer in the database has two group accounts on it. By deleting the computer, its associated records in tblAcctLink will be deleted, and I will have to check for both...

I am having some trouble checking a table. Here is my situation: I have a database desinged to keep inventory of computers in my building. I have two tables withing this db called tblGroupAcct and tblAcctLink. tblGroupAcct contains all of the group accounts and their info; tblAcctLink contains...

Unless I am implementing this code improperly, it does not seem to work. I tried placing it in the onClick event of the listbox. Is that the correct place? Sorry, I'm not that great with VBA; code is far from my forte.

Hi Paul, Apologies for not responding on Friday; I had left work for the day. Anyway, I am not sure where to put this code or how to incorporate the method from the other link. Could you explain a bit more? Thanks.

Hi Bob, I had also tried that, but I received the same error message.

I actually have one question. After further review, I have found that as I select items from the listbox, the data populates the group fields nicely. But if I deselect all of my previous selections so that there are no rows selected in the listbox, the group fields retain the information of...

Thank you much, sir. I tried the suggestion, and it seems to be working ok. I will continue to fiddle with it, but looks good now. Cheers.

Hi all, I am new to this forum, and I think I'm posting in the right place, but I'm not sure. If I'm not, apologies. Anyway, I am coding a database that deals with software and computer inventory. My current issue stems from a form designed to take info of newly imaged computers. Here's...

Hello fellow Access users, My name is skidude2000 (well, my username anyway). Before last summer I had a working knowledge of Access, but not much else. When I began an internship last summer, I had to build a db in Access. I quickly realized that for the db to be the best it could be, I...