I don't understand VBA coding or complicated event procedures. If anyone is willing to take me by the hand and walk me through this so I can get it done I would appreciate it.
I am having to set up, from scratch, a filing system for the boss. The problem is he doesn't think in names and companies so I could set up a alphabetical system. He thinks in subject/topics. So I have to categorize everything by topic. I've created the attached database so you can actually find a file once it is file, but I want some special effects on it to make it user friendly since most of the people I work with have never used access and some are computer illiterate. Here are listed some things I want to do.
1. when you click on FileCabinetLocation in the form I want it to bring up only the FileTopics that apply to that cabinet.
2. when you click on FileTopic I want it to bring up only the FileSubTopic that apply to that FileTopic.
3. I want to make a mail merge label that will give a short code combining FileCabinetLocation, FileTopic and FileSubTopic to where the file should be filed so if it is removed it would be easier to file it back. Example Rod's 1, Active Jobs, Woodland Park Saddle Club could be R1AJWPSC. But it need to be logical enough that it doesn't cause confusion and there's no chance any codes could be duplicated. And that the coding would be consistent. Our accounting system has codes for Vendor but sometimes they use the first 4 letters of the company name and the first 4 letters of the second name but sometimes they forget or get confused and it the first 5 letters or the whole first name. I want the codes to be automated if possible so there is no confusion.
4. I want to be able to have the lookup table automatically updated if a new topic is added that is not on the table list.
Regarding 1&2 I researched cascading combos on the access forum and looked at some sample databases but just can't seem to understand the coding and the logic of how to make it work. I did get it to cascade once but it was backwards from what I wanted and it showed the coding rather than the names. I do understant that the 3 file placement look up tables will have to be combined but I seperated them for now so I could get some data in.
I didn't save my work to show what I did previously with the cascade combos and I don't even know that I could duplicate it but I thought if you could help it would save me a lot of time in trying to learn the coding. I've already spent 45 hours on it and the boss needs to start seeing some results. He doesn't understand that setting up a system takes time. He thinks I should be able to just make labels, stick them in a drawer and call it good.
As For 4 I know you have to use the "not on list" event property but I don't know the syntax to make it update the table.
Feel free to manipulate the data, table, form whatever. I will use your changes as a guideline to change the actual database.
I am having to set up, from scratch, a filing system for the boss. The problem is he doesn't think in names and companies so I could set up a alphabetical system. He thinks in subject/topics. So I have to categorize everything by topic. I've created the attached database so you can actually find a file once it is file, but I want some special effects on it to make it user friendly since most of the people I work with have never used access and some are computer illiterate. Here are listed some things I want to do.
1. when you click on FileCabinetLocation in the form I want it to bring up only the FileTopics that apply to that cabinet.
2. when you click on FileTopic I want it to bring up only the FileSubTopic that apply to that FileTopic.
3. I want to make a mail merge label that will give a short code combining FileCabinetLocation, FileTopic and FileSubTopic to where the file should be filed so if it is removed it would be easier to file it back. Example Rod's 1, Active Jobs, Woodland Park Saddle Club could be R1AJWPSC. But it need to be logical enough that it doesn't cause confusion and there's no chance any codes could be duplicated. And that the coding would be consistent. Our accounting system has codes for Vendor but sometimes they use the first 4 letters of the company name and the first 4 letters of the second name but sometimes they forget or get confused and it the first 5 letters or the whole first name. I want the codes to be automated if possible so there is no confusion.
4. I want to be able to have the lookup table automatically updated if a new topic is added that is not on the table list.
Regarding 1&2 I researched cascading combos on the access forum and looked at some sample databases but just can't seem to understand the coding and the logic of how to make it work. I did get it to cascade once but it was backwards from what I wanted and it showed the coding rather than the names. I do understant that the 3 file placement look up tables will have to be combined but I seperated them for now so I could get some data in.
I didn't save my work to show what I did previously with the cascade combos and I don't even know that I could duplicate it but I thought if you could help it would save me a lot of time in trying to learn the coding. I've already spent 45 hours on it and the boss needs to start seeing some results. He doesn't understand that setting up a system takes time. He thinks I should be able to just make labels, stick them in a drawer and call it good.
As For 4 I know you have to use the "not on list" event property but I don't know the syntax to make it update the table.
Feel free to manipulate the data, table, form whatever. I will use your changes as a guideline to change the actual database.
