I am trying to run a query from a button created within "Forms." I cannot transfer the button from forms to my web page within Access for some reason. I tried creating a button within the web page and am unable to apply a query function to the button. Any idea how I can do this?
I am trying to write into vb code the following command but am unable to figure out how to phrase it in code:
"Is in Column C"
This will be inputted into an "If - Then" statement. Any suggestions will help. Thanks.[noevil]
I placed a button which contains a macro at the top of a spreadsheet. I need this butoon to always appear at the top, so the logical thing to do would to place it in a frozen pane. Once I did that, the macro would not run. Is there anyway to have a button stay located at the top of the...
I am creating a worksheet that has over 1,000 toggle switches in it. I created one main macro that contains a specific macro for every single switch. Having such a long macro, one that covers thousands of switches, has caused the spreasheet to take literally 30 minutes to open. I need to find a...
Here is the macro...
Private Sub Tog_C11_Click()
If Tog_C11.Value = True Then
Range("C7:C11").Select
With Selection.Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
Range("C11").Select
ActiveCell.FormulaR1C1 = Date
Else...
I created a macro using Excel 97 and am trying to get it to run within Excel 2000. Excel 2000 recognizes part of the macro command, but the other part it cannot load. The part of the macro not functioning properly is a date insert, which is 'Date' in 97. What is the correct command, if there is...
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.