Hello all, I am new to the forum so if I am breaching any sort of etiquette when posting here please let me know. I am also new to Microsoft Access. Everything that I have learned has been on the job learning and any code I have needed to figure out has been from searching Google and forums so please bear with me lol. And most of the time I have found my answer through my research but this time I think I am way in over my head so any help you guys could provide would be most appreciated!
I have a form created in Microsoft Access that serves the purpose of consolidating information in order to generate a description for an item. The heart of the form operates on queries (over 30 queries) that help generate combo boxes and the user selects what he/she wants in order to build the description that he/she desires. And that part works perfectly fine! But my boss now wants me to find out a way to build multiple descriptions on the same form AND ALSO have a way to GO BACK AND EDIT certain descriptions that have already been built and honestly I have no idea how to do this. The way I was conceiving this to happen is there would be a button entitled “Build Description” that would initiate the instance of building Description #1 and then a save button entitled “Save” that would save that description to the form and then of course another button entitled “Build Description” that initiate the instance of building Description #2 and so on and so forth. ALSO, (this is where it gets really tricky) right next to the “Build Description” button there should be a button entitled “Edit” that would allow the user to edit the description that was PREVIOUSLY generated. For instance if I had already built ten descriptions and I wanted to go back and edit Description #2 I would click the “Edit” button next to Description #2 and it would REGENERATE all of the form data, that is inclusive of the comboboxes it took to generate that particular description in the first place, and I would go in there and make the necessary CHANGES to the comboboxes and REBUILD the description. To describe this Edit button in the form of analogy it is almost like playing a video game and the gamer saves the game throughout but will create MULTIPLE save files throughout just in case so that the gamer can go back and access those save files at later date. And that is similar to what I want to do is create multiple save files and be able to go back and edit those save files later on. So I feel like the hard part is adding instances into a seamless form.
I feel like a macro recorder could come in handy here but unfortunately MS Access does not have one and also I don’t know if a subform could help me out here, although I’m not entirely sure what subforms do or how they could help….idk I’m just spitballing here everything that’s come into my mind. Also nothing I’ve said here is verbatim I am totally up for changes or you guys telling me that there is a way better way to do this. I am totally all ears here.
Idk it seems impossible to me I always feel like my boss is shooting for the stars when he assigns me these whimsical ideas of his but anyway any help or advice with my current predicament would be greatly appreciated. Also please check out the zip file that contains a word doc that iterates exactly what I would like in my form. Also, here is a link to download my database, not sure if it will work or not but let's give it a shot: https: //drive.google.com/file/d/0B6XoeP0obJo2SlFhaWRKWDR5Zkk/view?usp=sharing
(There's a space after the colon in "https:" that needs to be taken out, they wouldn't let me post links)
I have a form created in Microsoft Access that serves the purpose of consolidating information in order to generate a description for an item. The heart of the form operates on queries (over 30 queries) that help generate combo boxes and the user selects what he/she wants in order to build the description that he/she desires. And that part works perfectly fine! But my boss now wants me to find out a way to build multiple descriptions on the same form AND ALSO have a way to GO BACK AND EDIT certain descriptions that have already been built and honestly I have no idea how to do this. The way I was conceiving this to happen is there would be a button entitled “Build Description” that would initiate the instance of building Description #1 and then a save button entitled “Save” that would save that description to the form and then of course another button entitled “Build Description” that initiate the instance of building Description #2 and so on and so forth. ALSO, (this is where it gets really tricky) right next to the “Build Description” button there should be a button entitled “Edit” that would allow the user to edit the description that was PREVIOUSLY generated. For instance if I had already built ten descriptions and I wanted to go back and edit Description #2 I would click the “Edit” button next to Description #2 and it would REGENERATE all of the form data, that is inclusive of the comboboxes it took to generate that particular description in the first place, and I would go in there and make the necessary CHANGES to the comboboxes and REBUILD the description. To describe this Edit button in the form of analogy it is almost like playing a video game and the gamer saves the game throughout but will create MULTIPLE save files throughout just in case so that the gamer can go back and access those save files at later date. And that is similar to what I want to do is create multiple save files and be able to go back and edit those save files later on. So I feel like the hard part is adding instances into a seamless form.
I feel like a macro recorder could come in handy here but unfortunately MS Access does not have one and also I don’t know if a subform could help me out here, although I’m not entirely sure what subforms do or how they could help….idk I’m just spitballing here everything that’s come into my mind. Also nothing I’ve said here is verbatim I am totally up for changes or you guys telling me that there is a way better way to do this. I am totally all ears here.
Idk it seems impossible to me I always feel like my boss is shooting for the stars when he assigns me these whimsical ideas of his but anyway any help or advice with my current predicament would be greatly appreciated. Also please check out the zip file that contains a word doc that iterates exactly what I would like in my form. Also, here is a link to download my database, not sure if it will work or not but let's give it a shot: https: //drive.google.com/file/d/0B6XoeP0obJo2SlFhaWRKWDR5Zkk/view?usp=sharing
(There's a space after the colon in "https:" that needs to be taken out, they wouldn't let me post links)
Last edited:
