Search results

burrina - I'm not sure what 'code' you are talking about? Also, I don't know how to change it back so I don't get asked for a password.

I was exploring using User-level permissions on databases so I, the admin, can have full permissions to edit/change etc. the database and certain users can only add/edit data. But I inadvertently have now set Access to ask me for a password for any db I open. Even if it's my own personal one...

I'll cross that bridge when I get to it :) plog thank you for all your time and effort you put into helping me with this. I really appreciate your help. And I also can't forget to thank CJ London.

So the Project_Equipment field in project form record source the EquipmentCodes query. And every time I select a piece of equipment that would be associated with a project, only the ID number would go into the Project table along with the project it’s associated with. But the code is what’s...

I think I’m starting to get it. I think. So I take Equipment_code out of Equipment table and I would put it in my Project table and have a lookup on it that has a record source of the query (that you told me to make) that concatenates the code for me. And places that resulted concatenation in...

It's in the Equipment_Spec table (Equipment table that we have been referring to). I'd like to attach a copy of the db but it's 4MB is larger then the 2MB limit. The existing data that's in the table still have the description of the field's (cate, item, type) but any new data would have the...

I'm sorry I'm just not understanding how the code will me made? If it's through the query, how does that result populate the Equipment_code field? And the query would have to be run after a user would enter the other data (cate, item, type, dim)?

ok I understand. I will implement the changes you are talking about when I get to that point. The only thing is that I'm not at that point yet. I still need to resolve my first problem of trying to create an equipment code. I'm sorry I'm just not getting what I should do for that. I put in...

I'm sorry plog I'm not following what you're are saying. I've lost track if we are talking about doing this in a form or a table (I'm hoping in a form). Where would the drop down you're talking about be? And how would a drop down display a code if the code is not made yet for that piece of...

-I'll put an autonumber on the table. -Category, Item and Type fields are lookups from tables that list the full description name and the respective code. -If I were to take the Equipment_Code out of the table how would a user be able to identify that piece of equipment when using it in...

I've attached a screen shot of what my Equipment tbl looks like presently. I hope it helps.

CJ London, I'm sorry please don't be offended, I missed your original post - thank you for your input. I appreciate both (you and plog) your time and expert opinions. I don't think I'm explaining this the right way. I don't need to display the code for queries or reports. I need to use it as...

Thank you for your quick response plog. Equipment code field is required in the table it's supposed to be unique instead of an autonumber. It would take the abbreviated values of the three other user selected fields and typed in Dimension field. The Equipment code is used in another table but...

Using Windows 7, Access 2010. Is there a way to combine four fields into one field in the same record? I’m trying to build Equipment Code field by using the abbreviated values of Category, Item, Type and Dimension fields. Example: if Category=Storage System (SS), Item=Wire Deck (WD), Type=Flared...