Recent content by jj95

I think I figured it out, but very strange. When I was deleting the relationships, what I opted to do was just delete all the tables in the relationships window (as opposed to all the individual relationships). Well, for some reason there were still there (and would show up if I clicked the...

All, I have a table in my database that I no longer need. When I tried to delete it, I got the following pop-up error message: You can't delete the table '<tablename>' until its relationship to other tables have been deleted. It then offers to delete these relationships for me. I have...

Goh - That might have been it - when I imported all my tables from various Excel tabs, I did find one that appended a lot of extra blank columns as fields. It appears to be working, but unfortunately I am now chasing down another issue that cropped up and has me stumped (and with how things...

All, I have a database that contains a lot of different technical information on various pieces of equipment that we maintain. We then assign and track these equipment items as they get assigned to jobs. These jobs require that various forms be filled out, containing information about the...

Thanks for yoru help, that makes sense. I have never messed with any VB inside Access, so not sure where this kind of logic goes. My thought is that once the intial record is completed, I then have a Macro/button that will save/close the current record, walk through this loop to create the...

Instead of listing all my equipment IDs with Yes/No fields, I ended up creating a List Box. The source of the List Box is a query that shows all the equipment IDs (KZ-45, KZ-46, KZ-92, etc). Now I can run down that box and select all the IDs that I want assigned to a job. It appears to...

It's starting to make more sense, thanks. I will tinker around with it and see what I get. Thanks for your help!

The spacing I put in there didnt work out, so this time commas: Table, Field, Type, Example Inventory, EquipID, Text, KZ-45 Jobs, KZ-45, Yes/No, Yes

Thanks for the response. I think I am pretty comfortable about how I am going to query to get the various things I need. My point of confusion is if I can utilize the Yes/No function and query against the other tables. So: Table Field Type Example Inventory...

Good point. Yes (and no)! In reality, it is only (actively) assigned to one job. But we do have long-standing jobs where KZ-45 is assigned for the next 12 months to support a certain task, but it may get seperately tasked for a week or two for other purposes. Ideally, I would like to not...

All, Sorry for the dumb question, but I have exhausted all my ideas. BTW, I am not an Access-guru, so pardon my ignorance. Not sure if my question is really table or query related, so I posted here. Here is my situation, in short. I have a database of equipment, with all the...