Some basic help please

[andrewwood]

Please can you guys give me some basic help, im pulling my hair out over this one!

Attached is a test database which im writing at work, what I would like to happen is that when a new machine ID is selected from the drop down box (combo box) all the relevant fields update with all the information in them.

Please could somebody download my test database have a quick look, see if they can sort it for me then upload it back and explain how they did it.

Thanks in advance

Andrew.

 

[MStef]

Hello wooda!

Here it is, Look at Combo8
Row Source Properties
Column Count Properties
Column widths properties
List Width properties

 

[Pauldohert]

Whats the form for - why don't you just bind it to the table/ or better a query, be careful you aren't trying to acheive something with would be against all normalization rules also.

However -

1) Make the row source of the combo box for the computer contain all the info yopu need - then after update of the cbo set the relevent fields = !ComputerCombo.column(1) etc etc - column(0) refers to the fisrt column (1) to the second etc.

Just make sure all the data is in the rowsource for the combo and the correct number of columns is set.

2) Use a recordset - open a recordset and then move the data from the recordset to the form. Do a search on recordsets.


Both of these answers point you in a direction for getting a solution for yourself, there may be other ways of doing this also.

 

[Pauldohert]

You just did his work for him there MStef - very generous.

see if they can sort it for me

- I don't think so!

 

[Wiz47]

You just did his work for him there MStef - very generous.

- I don't think so!

Yes, very generous MStef. One other thing I noticed when looking at his db was that his primary key was set to [text] and not auotnumbered. I think he's going to run into very big problems down the road when he tries to index those records or uses a findfirst call for the recordset. But as you said, it just sounds like he wants someone to do his work for him, so I think it's best if he does some research on that and fixes it.

 

[andrewwood]

just sounds like he wants someone to do his work for him, so I think it's best if he does some research on that and fixes it.

thats not the case at all.

I spent 4 days looking at this and purchased an access bible and couldn't find help. I won't bother asking next time.

 

[Wiz47]

thats not the case at all.

I spent 4 days looking at this and purchased an access bible and couldn't find help. I won't bother asking next time.

Funny, I didn't see anything about that in your post. All I saw was a request to download, fix, and return. The best way to get help here is to explain the problem, what you have done yourself to fix it, and then ask for assistance. If you had done that first, you wouldn't have received the cold responses that you did.

But with that said, here is a working version of your db that saves new records to the table and has the ability to search for and edit old records.