Search results

I see. Now simple question...how do I say "where UserID = Form Textbox 13" or whatever? In other words on the form I want the button to delete the records based on the current UserID (textbox) on the form.

Hello, Newbie here I am trying to use VBA to delete rows from multiple tables based on a textbox on a form. I have a simple form like this: UserID FirstName LastName I want a delete button on the form which will delete the row for UserID in both the Users table and the Numbers table. The...

Crap, yeah I did. I think I just had the wrong version going....My bad. I added a form to add/edit users into the tblUsers table. Just something very simple. And then I realized that deleting the user from the Users table doesn't delete their associated records in the other tables. This must...

Hi, I hope you're still following this thread. Thank you, that is absolutely splendid! I have used this and built around it to make it work for me. Thank you! I have one question...and I think it is related to the code in the frmUserMaster form. If I try to assign only a TN and DID number...

Thank you! That did it just fine.

Hi, I have a simple form and want to search by last name. I created an unbound text (Text9) in the header, with 2 buttons (Filter and UnFilter). The form details simply has three fields, UserID, FirstName, LastName. I added the following code to the Filter button, but when I click on the...

O.k. I have not yet found an example of a LEFT JOIN to do what I am doing, joining multiple tables in this query. Is there anyone that can help me with the syntax on this? I'm not sure how it should be written (or if I indeed want a LEFT JOIN). Tables are like so: TblDN DNid (PK) DN TblDID...

O.k i did some reading but I'm not sure I can equate the examples to what I am doing. This is what I tried...but it doesn't work. SELECT tblDID.DID, tblDN.DN, tblPhoneLog.PhoneLogID, tblTN.TN, TblUsers.FirstName, TblUsers.LastName, tblPhantom.Phantom FROM TblUsers Left OUTER JOIN...

Hi, I am very new to Access still, and have a query to return values from multiple tables. In this case I want to return all users which have ANY of the following data in any of the following fields (DN, TN, Phantom, DID). This only works when the users has ALL the above fields. If any are...

Wow! That is too awesome. That works just PERFECTLY for that part of the process. It seems so easy when I look at what you did. I'm still just not looking at things the right way I guess. You're right about your second point...that's also important functionality. I was going one step at a...

That is helpful and I think I can use that. But i did try a different direction though. I got a combobox on a main form (TblUsers Form) with text boxes on the sub form (TblUsersSub Form). This filters the combobox to show only users with no numbers assigned. Now what I want, is on the...

Yeah, I was trying to play around with yours to see if I could do it....nope. Each user will be assigned 1 of each of those numbers (though in some cases they will have just 1 DID, and I TN, but no DN) or vice versa.

The user can only have 1 of each of the numbers (so they can have 1 TN, 1 DN, and 1 DID).

Yes, i see there are 2 limitations to the way the form is now. The username drop-down will still include users with numbers already assigned, but it doesn't show the assigned numbers for those users. So it's hard to know who still needs numbers assigned. Potentially this one form could allow...

Hi, Wow, you've been a great help! I didn't realize that the extra table would be needed for this. That's the junction table I believe? Now I understand that part. I'm not sure I understand what that code is doing on the afterupdate event. But I do see that the boxes work, so that each...

So, I have the combobox with the available options for the first user, but the same items are still available in the combobox for the next user. I need to filter the choices so that only the unused items can be selected. The DN, TN, DID can't be duplicates. I'm stuck.

Hello, I have gotten this far with help. I have a very small (and what I thought was simple) database with 4 tables as below. I want to assign a DID, DN, TN to each user, but each DID, DN, TN value can only be used once. I built a form with 3 subforms as below. I want a combobox to allow us...

I "think" that helped, but I guess I'm now at the next step. I want my main form (frmUsersMaster) to allow me to enter "available" TN, DN, DID for each user using a combo or list box. That's where I'm stuck now but I guess it belongs in another forum group! It seems to show the records...

Thanks folks! I'm going to look at this this weekend and see if I can get anywhere. I tried looking at this from multiple angles but never seem to get far. I just keep thinking...this is SO simple, (unless you don't know what you're doing).

Hello, I have a situation where I had data in Excel which is hard to manage and I THINK is the perfect situation to move to a database but I'm stuck. I have a list of People, Assets1, Assets2, Assets3. Each person can have only 1 of each type of Asset, and each of the Assets can only be...