By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,401 Members | 928 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,401 IT Pros & Developers. It's quick & easy.

save all information under a PROJECT

100+
P: 135
Hello

I have 3 different forms where different users enter information to the same products. i.e. (First the engineer will provide the products, weight, etc, then a costing guy will enter costs, amortization, etc, finally the pricing depatment will enter commercial information, all working on the same products.) These three forms are alredy made and working (ENGINEERING, COSTING and PRICING). I created another form (PROJECTS) where when opening the database the user will select the project and be able work with that specific data.

How do i link or create the relationships so that after selecting/creating a new project all information starts being classified as from THAT project, or do i have to specify for every product (ENGINEERING FORM) the project it belongs to???

please help,
Gilberto
Sep 4 '07 #1
Share this Question
Share on Google+
6 Replies


Rabbit
Expert Mod 10K+
P: 12,396
You will have to specify what project every product belongs to. All of it can do done invisibly using VBA code. How you do it depends on your exact circumstances.
Sep 4 '07 #2

100+
P: 135
You will have to specify what project every product belongs to. All of it can do done invisibly using VBA code. How you do it depends on your exact circumstances.
Thank you for your quick response.

How can i do this invisibly and automatically for every product ONCE i have selected on the oppening form the name of the project??? (could you give me some code please)

Also once this is done, what kind of query do i need so that once you select the project, it will take you only to those previously entered products for further modification, addition, etc.???

thank you again,
gilberto
Sep 5 '07 #3

Rabbit
Expert Mod 10K+
P: 12,396
The DoCmd.OpenForm function has a filter parameter you can use to only show records that match the criteria. And as for initializing the project name you could do it through a global variable, through the OpenArgs parameter of DoCmd.OpenForm, or even storing it in a table or form.
Sep 5 '07 #4

Rabbit
Expert Mod 10K+
P: 12,396
Resuscribing .
Sep 5 '07 #5

100+
P: 135
The DoCmd.OpenForm function has a filter parameter you can use to only show records that match the criteria. And as for initializing the project name you could do it through a global variable, through the OpenArgs parameter of DoCmd.OpenForm, or even storing it in a table or form.
Thanks again. that sounds pretty good however i have not real experience with using CODE. Actually the projects name with their information (description, client, etc.) will be stored at a table.

Could you help me with some code???
The basic idea is that every product (which are stored in the ENGINEERING table) gets classified with a project name (which are stored in the PROJECTS table) once the user select/creates the project on the initial PROJECTS form)

i hope this helps.

thanks,
gilberto
Sep 6 '07 #6

Rabbit
Expert Mod 10K+
P: 12,396
Form1
cboProject; Combobox; Text
cmdOpen; Command Button

Expand|Select|Wrap|Line Numbers
  1. Private Sub cmdOpen_Click()
  2.    DoCmd.OpenForm "Form2", , , , , , Me.cboProject
  3. End Sub
  4.  
Form2
txtProject; Textbox; Text

Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_Load()
  2.    Me.txtProject.DefaultValue = Me.OpenArgs
  3. End Sub
  4.  
Sep 6 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.