Search results

Thank you for the useful link. I still couldn't quite figure out, but I broke it in two different lines to below and it worked.

Thanks, jdraw for the link. It does provide basic syntax for various functions with regards to different datatype, but I don't see syntax that deal with variables, which is I am really after.

I have such hard time with the syntax. I'll be grateful if someone can provide a link where I can learn about various syntax when referencing variables in various functions. I'm trying to delete a record from a table that is trigger by a button in a continuous form based on an ID found via...

Thank you so much. I looked everywhere on the web. Your syntax, at least for the text works great. I've not tried the other data types yet.

I've tried all kinds of combination but I just can't figure out the syntax. I know it works fine when I take out the SomeVariable and replaces with actual value, but since I need to make this statement dynamic, I need to insert a variable. What is the exact syntax to make this work?

Strange. When I first saw your response, it didn't show the codes you provided. I just thought you want me to reference "me" in my code. I just tested your code. It works great for my needs. Thank you so much.

Hi Michael, Thanks for the quick response. I'm getting "Method or data member not found". Perhaps ActiveForm is not a good method? Sorry, my coding abilities are limited.

So, I think I have a good routine to make all controls of a form invisible except a few, but I'm getting "You entered an expression that requires a form to be the active window." I've put the below code in On Open, On Load, On Activate, and still get the error with this line being highlighted...

I tried earlier but I failed, so I started to research only to see a bunch of comments that you cannot. Apparently my code was no good before. I just tried it again, and I do see it's possible. Thanks.

Hi Sean, The thing is that I want to create a bunch of these button made out of labels. I want to use a generic code in their click event. Recall you helping me out on extracting the caption of the button before? The code below worked beautifully for command buttons, but with a label, I...

Since you cannot change the the color or other attributes of command buttons, I've decided to make labels to look like buttons, as some have suggested. When you press a button, you can reference it by Me.ActiveControl... It does not seem to work for labels. What is the similar code to...

Oh my gosh. How did I not remember that? I just posted that same question for a different application and I actually did use it too. It worked quite well. I feel so embarrassed. :o Thank you so much for pointing the way. My face is getting redder as I type...

I was somehow able to modify some codes, which I don't quite understand how I did it, but basically I used the recordset and looping methods to auto populate captions of a bunch of buttons in a form. Now I need to set an event to extract the first line of the button caption. Seems easy right...

JR, What would the code be if you were to concatenate two fields from the same table together?

After further research, I have decided to go with this route. I'm sure it's not the most efficient way, but it's a way...I guess. I basically will create a template with a bunch of command buttons with each name Command0, Command1...Command2...I will then loop through a table to obtain the...

Everywhere I've searched, I am informed that you cannot make a continuous form to go from left to right. As my users are using touchscreen monitors to select from a long list (just long enough to go to two to three screen sizes) of items from a table/query, scrolling is not desirable. I could...

You are absolutely correct, Paul. I had the space in there originally when I was trying to add the extra line. So, for those who have found this thread wanting to do the same thing, the actual syntax is =[Field1] & Chr(13) & Chr(10) & [Field2]

Thank you. That's exactly what I needed. For those needing the same thing. The exact syntax is =[Field1] & " " & Chr(13) & Chr(10) & [Field2]

I want to concatenate two fields together and display it in the text field, but I want the second text to be on the second line. What is the exact syntax to accomplish this in the Control Source. The concatenation part is easy, but what is the code to basically simulate <control><enter>? I...

I downloaded a touchscreen keypad form somewhere online. When I backspace the characters in the text field one too many times, meaning when there are no more characters to backspace, I get an error message (Run-time error '5') or "Invalid procedure call or argument" and the below line is...