Help with an equipment list data base

[lavey]

Hi there,
I'm creating an equipment database and have ran into some problems creating it. This is an Engineering oriented Database
MS Access 2010
Here is the basic idea of how I want it to pan out.
Design:

- Users enter a main menu where they have the option of creating a new project, or selecting an existing project and viewing/printing/editing information in that project - I've created the button that leads to a form where I can create a new, all is left (I believe) is just making this work perfectly

- Once the user has selected the project (combo box to select project and press button to go next) A page shall appear that will display ALL Project information for ONLY the specific project that was chosen. On this page I want there to be another button that will lead to an "equipment list" which is specific for this project only. Eventually the user should be able to add/edit/delete data, search for data etc (all the normal functions that a database should have)

Questions: How do I make the next form/report portray the specific data for only that ONE project, and have other buttons on it? At the moment I've only been able to make it bring up another form that allows the user to input data into fields, but not actually display data and then have other buttons/options on there.

Please ask any questions that you wish to grasp a more appropriate understanding of what I'm trying to do, if I haven't explained myself well enough.

Many thanks

[Seth Schrock]

You can only ask one question per thread. Please read the forum's FAQ for posting guidelines and then post each question in a separate thread.

[jforbes]

Hello Lavely,

As Seth has mentioned, there is a one question per thread. So to answer your first question, you might want to use the function provided at Locking Bound Controls One thing to note on using this code (which works great) is that if you switch to Form editing and then save a Form, after the code has locked down some controls, the controls will be saved as locked. It's not a big deal, you will just need to address this on any Form that uses this code by ensuring the Lock Down code (or unlock) is executed on Form Load.

[lavey]

Hey guys,

Sorry but I've read the FAQ's twice now and can't see anywhere that it specifically says only one question per thread, but my bad.
I have edited the original post to include only one question that is of priority at the moment.

Thanks

[Seth Schrock]

I think that the easiest way to do this would be to specify the WhereCondition property of the DoCmd.OpenForm & DoCmd.OpenReport commands.

[lavey]

Hi Seth,

So I tried writing this expression into a macro's expression builder under the where condition but its saying that it has an invalid value.

DoCmd.OpenForm "Project Details",,,"p_ProjectNumber ="" & Me.Command20.Column(1) &""

Pretty sketchy on this type of stuff so still getting my head around it. Any chance you would know how I could fix this problem?

Thanks

[Seth Schrock]

That is VBA code, not a macro. I don't use macros so I'm not sure the syntax for them.

[lavey]

well in that case I'll use it as VBA (may as well learn it)

Private Sub Command21_Click()

DoCmd.OpenForm "Project Details", , , "p_ProjectNumber ="" & Me.CmbProject".Column(0)&"""

End Sub

Syntax error occurs whilst compiling. I had the Command21 in place of the CmbProject, however that just brought up the Project Details form with blank entries (no data from the selected option in combo box)

Edit: I got it working to display the corresponding project, thanks.

Now for a next question: (am I allowed in this same thread?)

- When the user has selected his project and is now linked to this next form, I want there to be a "Equipment list" button which leads to an equipment list. I have imported an equipment list from excel and created a form etc. How will I be able to make it for that equipment list to be populated specifically for just that one project?
example: I select project number S111 and then click on an equipment list which will lead to a split form where I can populate the equipment list. But then I want to go back to main menu and select project number S888 and then go on to populate the equipment list for that project. However the data in this equipment list is isolated just to this project number. Will I need to create separate tables per project or is there some simple method?.. sorry hard to explain this one

Thanks

[Seth Schrock]

The next question needs to be in the new thread. The reason being that it makes it easier for the next person with a similar problem to be able to search and find the answer.