Recent content by tuxalot

Bump. Anybody? I have the same problem.

No, just comparing integer data but thanks for the tip.

Thanks Michael. Seems like a more complex way to achieve the same result, no? Pardon my ignorance, I am still learning Access.

Hello all. I need some help building VBA code to loop through two recordsets. I have a local table like this: Question Response 1 2 2 2 3 1 4 1 I want to evaluate each entry in that table based on a set of rules. The rules are created by my users...

Hey Rx - thanks for the response. Not sure data macros would work per the FAQ on the page you sent: If I create a query like you mention, I cannot update records.

Hi guys, I have a local Access table (tblResponses) and a MySQL table (tblAndroid) connected to my database via ODBC. I currently use two queries to update data in these tables based on the most recent timestamp (SQL table timestamp being AnswerTIme and local Access timestamp being...

Not sure yet. Perhaps a checkbox, radio button, or I may border each image with a highlighted rectangle and control their visibility by clicking a transparent command button placed over each image. The later would be my preference but I can get that bit working. I just can't see the forest for...

Thanks for the reply vbaInet. The images are external to the db. Each selected image path would be stored as a record in a table that is related to my main table. I suppose this would be the correct way.

I have 10 images on a form only five of which can be selected at any given time. I have five image controls on a report. How can I show the five selected images from my form on the report? Would it be better to have 10 image controls on the report bound to the images and collapse the controls...

vbaInet - I used your code and it worked great. Thanks for that. I have not a clue how to re-code this as a function. I need to learn how to pass arguments and the like. Thank you so much for your assistance. Tux

Here's what I settled on. I added a number "1" at the end of the tags that I wanted changed as part of this procedure.

Now I have this, not the cleanest code but I'm still learning. However it removes the arrow symbol on the currently selected label which it should not:

Tried this: 'Reset all relevant labels to default appearance For Each ctl In Me.Controls If TypeOf ctl Is label And InStr(1, ctl.Caption, " ChrW()") - 1 Then With ctl 'do stuff End With End If Next ctl getting "Object does...

I was thinking something along the lines of (this does not work):

I have each label heading working with your code. Thanks again for that. Now I need a way to get the labels back to their default name (caption) when any of the other labels are clicked to remove the up or down arrow. I was thinking about putting the default label caption in the tag, followed by...