Recent content by lavey
-
L
OpenArgs property between project form and equipment list forms
Sorry let me clarify. See in the attached picture of the first post the equipment list. There is a list box and there is currently a row highlighted in it. I want the highlighted rows fields (in this instance "345" & "Heat Exchanger") to appear in their corresponding text boxes on the form. So... -
L
OpenArgs property between project form and equipment list forms
While I have your attention Mailman, could you help me with the following. When a user clicks/double clicks on one of the fields in the List box, how can I get all of the information associated to that item to display in the fields above it. I can't work out any code for that and cannot find... -
L
OpenArgs property between project form and equipment list forms
Haha! I re-read my post and noticed that, I edited 1 minute before your post ;) Thank you for the help a great deal. And yes, Naming Conventions! I will change all of them appropriately, I definitely am starting to get mixed up with what is what etc. Thanks again -
L
OpenArgs property between project form and equipment list forms
Yes thought so, thank you DoCmd.OpenForm "Equipment List", acNormal, , "[p_ProjectID]= " & Me.p_ProjectID I have this code for my button. Now for the invisible text box on the equipment list, what code should I write ? theres also no "open" property just onClick and before update etc, which... -
L
OpenArgs property between project form and equipment list forms
I think it just looks neater opening a new form, in my opinion. Uh this may sound sound dumb, but what do you mean by the [YourField] part in the code? -
L
OpenArgs property between project form and equipment list forms
Hey all, Fairly new to Access (2010) and VBA so bare with me I am creating a database for an equipment list relevant to specific projects. I have created all the forms etc and all I have left to do is for the user to be able to open the equipment list specific to the project that they have...