lavey
Last Activity: Feb 18 '15, 01:08 AM
Joined: Jan 29 '15
Location:
-
Even with your method jforbes its still .DefaultValue = as the error - this is weird.. I can't find a similar situation while searching the net also. I guess I'll continue playing around with it and maybe find something -
Same as before, when I fix this issue .DefaultValue = becomes the next error in this situation? :S
my full code for this:
I changed...Code:Private Sub Command66_Click() DoCmd.OpenForm FormName:="NavEquipmentList", _ View:=acFormAdd, _ WhereCondition:="[p_ProjectID]= " & p_ProjectID, _ OpenArgs:=Me!p_ProjectID End SubLeave a comment:
-
highlighted is .txtProjectID under the Private Sub Form_Load() event.Leave a comment:
-
yeah I sure did, not sure why its happening.. Do I need to state the method somewhere before calling it?
the txtProjectID is being highlighted as the error. I change it to p_ProjectID and then the DefaultValue gets highlighted as the error?Leave a comment:
-
Thanks for that,
I'm getting a "method or data member not found" error for this:
Do I have to state these methods somewhere first before hand?Code:Me.txtProjectID.DefaultValue = Me.OpenArgs
Leave a comment:
-
Hi Seth I ran into a small problem.
I have the following code as my button to link me to the equipment list form
Now I think I will need to write the OpenArgs expression for the OnLoad event in the equipment list form. I have the following to try fetch the projectID but it is not working, could you edit it appropriately,...Code:DoCmd.OpenForm "Equipment List", acNormal, , "[p_ProjectID]= " & p_ProjectID
Leave a comment:
-
Tips on how to utilize search options
Hey guys me again :)
MS Access 2010
Please look at the attached picture to visual what I'm trying to say. Also, this is all one question but with multiple parts as they all tie in together.
I have made a a query in a list box to show all of the information relevant to the table (Equipment List). I have also created a search function so that the user can type in what he is looking for and it will be displayed.
... -
Thanks for that guys.
One last thing. Seth, how do I go about assigning the OpenArgs property to pass the value of the ProjectID?Leave a comment:
-
Yes, same type of equipment for different projects, but not physically the same equipment. so, the tag numbers (m_EquipmentTag ) will vary for the same type of equipment for different projects. For example, two Vessels with the same dimensions can be called 100-VD-001 for one project but on another project it could be 300-VD-001. So that being said, the same 'type' of equipment can be on different projects but with different tagging philosophies....Leave a comment:
-
I've googled setting up appropriate join tables etc, but i can't quite figure out how to do one specifically for this database?
Also another problem I just randomly noticed. My equipment list form won't let me enter any values to any of the text boxes or use any of the combo boxes. I have the primary keys and all set up like above (where im about 90% sure it was working when i took that screenshot) There are no queries associated to...Leave a comment:
-
could you please have a look at the attached picture and try walking me through that process if you're capable of doing so?
I'm unsure on how to progress completely and don't want to mess it up.
Thanks...Leave a comment:
-
Yeah I would need to be capable of adding equipment to this list as the user needs. Sometimes all the information wouldn't be available immediately and calculations would change etc. How would I go about doing it if that's the case?
Thanks SethLeave a comment:
-
specific equipment list for different projects
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... -
well in that case I'll use it as VBA (may as well learn it)
Private Sub Command21_Click ()
DoCmd.OpenForm "Project Details", , , "p_ProjectNumbe r ="" & 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...Leave a comment:
-
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_P rojectNumber ="" & Me.Command20.Co lumn(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?
...Leave a comment:
-
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.
ThanksLeave a comment:
-
Help with an equipment list data base
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...
No activity results to display
Leave a comment: