Weapons Database Help

[cooglerj]

So Im getting the hang of access but i cant figure out one part in this database. When navigating through the switchboard and you go to porthole>issue and recieving>IR PVS14/PEQ once your here I want to be able to select a line of information then click on the 10576 button at the top right and want it to auto populate the selected information into the 10576 form. It does it on the other issuing rosters but I cant get it to work on this one. Any help is appreciated. Password is M16a2!@#$Armory DatabaseAMT BE.zip

[burrina]

I really don't understand your db. Can you explain your Schema? It seems to me that One Main form is all you would need instead of all the many forms you have. You could then filter off that form with subforms and or tabs! I think it is more of a design issue, but I could be wrong! Step by step, Please explain the procedure. Remember, to you it makes sense, to us it may not.

[ItsMe]

I am curious if you got past the Edit issue you were previously encountering.

[June7]

What is the password for db?

[cooglerj]

I didn't get past the last design issue I had with the last data base but I found another one. The password is in the original topic.

[cooglerj]

And as far as the design issue it may be but I found this database and I am editing it to what I need. I wouldn't be able to redesign it without screwing it up

[burrina]

I did not mean to offend. Just thought it could do with a tuneup. Bottom line, if it works for you, then all is good.
Good Luck With Your Project!

[cooglerj]

I did not mean to offend. Just thought it could do with a tuneup. Bottom line, if it works for you, then all is good.
Good Luck With Your Project!

You didn't offend. If you know how to make the design easier do you mind helping me do it because Im at a lose at what to do haha.

[cooglerj]

I did not mean to offend. Just thought it could do with a tuneup. Bottom line, if it works for you, then all is good.
Good Luck With Your Project!

Actually if someone could just help me fix the issue with the information not auto populating into the form like the others is all i really need. Any help is greatly appreciated. I might be willing to pay someone if I can get it to where i need it.

[burrina]

I don't mind. I just need some explanation as to the design and structure. If you could take me through the process so I understand. As if you were explaining it to someone with NO knowledge of your database.

EDIT: I did download your db but deleted it as I saw others had downloaded it as well.

[cooglerj]

To begin I know alot of the forms and tables are not being used in the database this is because I got it from a friend and Have no need for some of them. But what I want the data base to do is when a Marine needs a rifle or other item issues I want to be able to go to the switch board and navigate to a table that already has all the serial#'s of that specific item we have. I want to be able to enter the Marines information into the form and then select the row that his information is in and click the 10576 button and it to autopopulate with his information and his the serial number that was in the selected row into a certain 10576 for that item because different weapons have different items and things issued with them. Also there is 2 parts to the database. Is this necessary can it be merged into one? If we can get this workinh i think i can figure out the rest.

[June7]

Sorry, read right past the password info.

I agree with Dave, the database is 'over built'. Don't need a form for every query just because filter criteria changes. Instead of static filter, use dynamic parameters. Or even better in my opinion is to apply filter to the form.

Options for displaying info associated with Marine's serial number:

1. multi-column combobox

2. form/report RecordSource that joins tables

3. DLookup

You might find a number of these tutorials of interest http://www.datapigtechnologies.com/AccessMain.htm
Especially the 3 about comboboxes under Forms: Control Basics
and Build a Custom Filter in Your form under Forms: Tips and Techniques.

There are two parts to this db because it is a split design. Split design is advisable for database with multiple users. The backend would be located on a central file server and each user would have a copy of the frontend on their individual work station. If there is only one user, then yes the two parts can be combined by deleting the table links and importing tables into the frontend part.

[cooglerj]

Thanks for all the help. Does anyone know where I could pay someone to do this? I dont think I have the time or patience.

[ItsMe]

I am too busy right now for an additional project. I spend a lot of time on this forum, I know, but it is a form of recreation for me. Also, I get to learn while helping others.

You might be surprised at what you can accomplish on your own and with the help of this forum. I am willing to help. I just can't be bound to timelines/deadlines.

[June7]

A professional programmer will charge from $50 to $100 an hour. Time involved could be weeks and costs could run into thousands. Someone has put a lot of effort into this db but the structure is not optimized. For one thing, should not be populating multiple tables with Marine's info (Name, Rank, Serial Number), just save unique ID primary key as foreign key. There are multiple tables with identical structure: {tbl_New_Recruit, tbl_Recruit_ACOG, tbl_recruit_weapons} and {tbl_SL3_CoachesCoursePistols, tbl_SL3_ACOG} as examples. Then there are the multiple identical forms and reports. Just getting that much understanding of this db has taken couple hours. Understanding data elements and business rules (what are Serial # and NEW Serial # as shown on rpr_WEB_INBOUND?) will take hours more before can even think about how to incorporate the requirement you describe. But what I am really seeing is a 'start over from scratch' scenario.