Search results for query: *

No This is what I wanted and seems to work. Me.ComboB = Me.ComboA.Column(1) Just found it in a demo database Thanks for your help chaps.

KenReay I saw that one but i didn't really get it, and I couldn,t see how it looks at column 2 in combo A to set the value for combo B.

Its a querry of a table "by" the combo box. i.e SQL

Hi I am sure this has been answered before but I can't find it. I have two combo boxes call them A & B when the user selects the value in A I want combo B to jump to the nearest match from column 2 in combo A Thanks

Thanks Bob Got it to work have been off access for a while so a bit rusty. Thanks 4 your help. ROn

Bob Yes the name of the combobox is combo16 Yes its column 3 I want to store into table A, feild name "time" in table A and B. Ta ROn

Bob yes the conbo is already coming from a querry of table B, Sorry not used much code, my combo box is number is 16 and the extra row I want is to store is 3. where do I put the code line? Ta ROn

Hi all I have two tables call them A + B, I need to store two of the fields from the selected record in table B into table A. (Both fields in table B come from the same record.) I know how to use the combo box but that only lets me save one feild I need to save two and I want to do it with just...

willir Ok I think I see what you are getting at in stage 2 but I am not sure its quite what I need. Heres more detail I have a main data entry form, various tables linked to look up data from combo boxes. The important bit, I look up a part number through a combo box from my part details...

Willir Thanks for the reply ok heres more detail I am basically calculating times not that that matters, at the moment I store a part number as a primary key, in this related table is description but critically a time value. its these values that now need to change frequently so I need to store...

Hi Now I will try and explain this as best I can. In a data base that kind of grew bigger than it was ever ment to I have a set of master tabels in a _be file. Thats fine it all works ok the problem I now have is the operators enter data using forms and basically using a combo box store the...

Help I run a tool managemnet DB is nice but the reports are naff so I ODBC link with Access, I extract the field which has the BMP file name. All the BMPs are sitting on a server in one folder I would like to print these BMPs with the report so people can have a pic of the tool. Can this be done...

HOW do i fill the page with the same grid of lines that i use to seperate records when the records that exsist only fill half the page, also want to print the lines on whole page when no records exsist for some groups of data.