Combo Boxs & Hard Drive Browsing

[icupat]

I'm using Access 2000. Is there a way to hid mutiple columns without entering "0" for each column?

For instance, right now if i have 100 columns brought in the combo box (because i need to multiply the 100 numbers by something on the form) and to hide all but the first one I have to type in the column width:

5cm;0;0;0;0;0;0;0;0;0;0;

You get the point, a lot of zero's (I only did about 10 there to demonstrate the dilemma)..I'm wondering if there's some what I can say every column after the first one should be zero (0) width or do I have to do it manually?

........
SECOND Question:

I have components that I want to assign jpegs to.. for instance I have a computer which I want to have info about then a small preview of the compenent... I want people to be able to add the picture by simply clicking on a command button, then browsing their hard drive for it's location... I'm having trouble with the code that allows you to add an image by browing... help would be great! I think it's probalby just a "DoCmd" function, but not sure.

 

[nberryman]

Can help with the second question.

I have an example database that stores photos and browses to find the filename, all done with a great deal of help from Tek-Tips

If you want a copy e mail me with Photo Database in the subject

neil_berryman@btopenwporld.com Neil Berryman
IT Trainer
neil_berryman@btopenworld.com