Sorry for the confusion in my webpage about combo box issues. I recently redid the entire site and changed some page names. For everything I know about combo boxes please goto:
http://www.blueclaw-db.com/access_developers_combo_box.htm
Well... you could probably use nested iif's. But the more fun approach would be to transform your table so that each of the four fields goes into one field but into a new record. You do this with a union query. Something like as follows:
select fieldx, fieldy, field1 as field_new from table1...
To the best of my knowledge you can't change the image on just one record of the continuous form on-the-fly. Access isn't smart enough or I'm not. You can however have a single instance of the picture is a separate little form the is coordinated so that you see the picture of the person on the...
The following Microsoft article and the embedded articles will give you some pointers as to why you might be having problems.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q300216
Joe.
Similar thing happened to me. It occurs on autonumber fields after a database is compacted - lovely little Access bug. This is fixed by applying the latest Office 2000 patches.. I believe it is SR-2 although it could be SR-1a.
I have dozens of Access databases out there and it happened on two...
It might help to see the query statement you are using for the insert. However, I suspect you have the ID field in the insert statement. This is a no no. Remove the ID field from the insert statement - Access will automatically populate the ID field.
Joe.
http://www.blueclaw-db.com/
Put in a dummy control and put your calculations in the control source property starting it with an equal sign. Example
= [field1] - [field2]
Joe.
http://www.blueclaw-db.com/
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.