getting records from a table

[wiltshire]

Not really sure what's happening there - but if you go into the design of the 'artnum pop-up' form , double click on the combo box to get the properties up, click in the 'row source' line, then click on the box with the 3 dots on it to open up the SQL query on the ' row source' line. Run this query by clicking on the exclamation mark button, then close this down, close the form and save changes, it works.

sometimes things just work, don't try to figure it out it''l hurt your head !!!!!

take care...........

 

[113deluxe]

got it up and working now, great. but it turns out I have one more question. How can I go back and make another search/choice? would be great with a button thet closed the parts list and opened the art num pop-up again.

 

[wiltshire]

just put the following into the macro:

Macro name: Open pop-up

Action: Openform
(hit F6 and set form name to 'art num pop-up')

Then in the on-close setting of the 'parts list mainform', reference this new macro.

 

[113deluxe]

In a new macro or the excisting one??

 

[wiltshire]

up to you, I'd put it in the existing one.

 

[113deluxe]

Thanks alot...now everything works like a charm...

 

[113deluxe]

I`ve come upon another problem. I have two tables where I get the product info from, thne tblparts and another one called tblparts2, the problem is that when i choose a product that has its parts in the tblparts2 table I only get the product name and info in the window. The parts that are listet for this product are not shown. I`ve made the same relationship to this table as to the other table.

 

[wiltshire]

can you zip it and attach and ill take a look.

 

[113deluxe]

The file is too big to attach... do you have an e-mail adress??

 

[wiltshire]

steve.wiltshire@zarlink.com

 

[wiltshire]

Hi Rune,

The problem you have is that the subform is based on tblparts only so when you choose a part in the top level table whose parts are in tblparts2, no info will appear.

Looking at the tables, they are both identical in design, so I'd pull all of the data into the same table, which will make things easier anyway.

 

[113deluxe]

you got mail!!

 

[113deluxe]

I cant put everything in one tabel because I have 4 tables that ar near identical but belong to different projects, I have one table for each project.

 

[wiltshire]

just add a field to the table called 'Project Name' and this will allow you to pull all of the data together but also filter when needed.

It also makes things much easier as you can then use generic searches rather than one for each table.

 

[113deluxe]

cool...I`ll try that then...but how will I be able to choose wich project I want to work with? make a combo boc for that too?? could you give me a small xample??

 

[wiltshire]

that's exactly what you need to do - I'll sned you an updated version of your database to look at.

 

[113deluxe]

Looking good but one question... If I first choose a project(let`s say nr 1) with the combo box and the click the product combo box to view the registered products for that project and then go back to the project combo box and choose another project and clicks the product combobox then the products for the new chosen products aren`t listed, the products for the first project still is in the combo box. Is there a way to fix this bug?

 

[113deluxe]

Another thing...since all the projects contail the same products an parts how does this keep track of which part belongs to which project??

 

[wiltshire]

It's ok, the form just needed requerying - I'll add a line to your macro and send it.

As for the rest - I'l leave it up to you - have a go, I have to go and have an Access free weekend.

Take care........

 

[113deluxe]

thanks for the example.it helped me out ALOT.

I was just wondering. for each project I have a list of parts with an art no. every project have the same parts with the same no., how do I "link" the right parts to the right project if I put all the parts in the same table??Do I have to make another index in the parts list??