Search results

Could you provide me with an example?

Is it possible to get prompted to enter the report name instead of what I'm using? strDocName = "Report-BA" DoCmd.OpenReport strDocName, acViewReport, , strWhere Thanks.

I have a form with several command buttons. I would like to click a button automatically if: If [notes] Like "*Apple*" Then Call Command646_Click If seems to work fine on a command button that is vba but it does not work if the command button is an embedded macro. I get the this error...

I see... Thanks.

When I go to properties, I don't see the unblock checkbox like in some tutorials? Thanks.

Thanks for the example but keep you 2 cents to yourself next time. Sorry I'm not an expert like you!

Can you provide me an example? The field is [cust] Thanks.

I have a table that has data that looks like this... I need to create a query that gives me everything before the first space ADVA80403 Advanced AIRC23072 Air BETV16523 Tom Need it to look like this. ADVA80403 AIRC23072 BETV16523

It gets rid of the comma and the extra space but everything is on one line now.

So, using my example: =[Street Address] & (Chr(13) + Chr(10) + [Street Address Line 2]) & Chr(13) & Chr(10) & [City] & ", " & [State] & " " & [Zip Code] Where do I change it so the ", " and the " " don't show? Before the those or before the city, state, zip? Not clear. Sry.

Perfect! One last small item. How can I get rid of the comma (", ") and the extra space (" ") if both Address/s are null?

Sometimes, =[Street Address] can be null and [Street Address Line 2] have a value. So, how can I check for either null and remove that blank line?

When I try this: =[Street Address] + (Chr(13) & Chr(10) & [Street Address Line 2]) & Chr(13) & Chr(10) & [City] & ", " & [State] & " " & [Zip Code] I get the same results as before?

So, here is my code... How can I make it remove the extra line if [Street Address Line 2] is empty? =[Street Address] & Chr(13) & Chr(10) & [Street Address Line 2] & Chr(13) & Chr(10) & [City] & ", " & [State] & " " & [Zip Code]

That did it!

Yes, on a textbox on a form.

I tried that but it keeps putting square brackets around the vbCrLf? =[Street Address] & [vbCrLf] & [Street Address Line 2] & [City]

I'm combining a few fields and need to have a return (next line) after each. =[Street Address] & [Street Address Line 2] & [City] Street Address Street Address Line 2 City

Is there any way to make the the first letter of each word CAP and the rest lower case? Example: SUNSHINE STRORAGE SYSTEMS, would be Sunshine Storage Systems Thanks.