Code:
Sub Macro3()
'
' Macro3 Macro
'
Dim i As Integer
i = 1
For i = 1 To 10
If (Range("A" & i).Select = Range("B" &
4 results in 0.0044 seconds.
-
Comparison operator in excel macros
I am trying to compare each cell in a i.e. A1 with B1 and if it is true i will populate the cell F1 with A1 value.....But irrespective of my input values the if condition becomes true....can anybody help me in this. My code goes like this
... -
How to apply code process to all forms from single onclick
Hello All,
I have created a table (CommissionStat ements) in Access that will store all of our data that we import from Excel.
Certain fields of the CommissionState ments table are computed using data from a linked table (Clients) via a button that is programed with an onlcick. This button is on the CommissionState ments form that contains all the fields of that table. The code is as follows:
...Code:Me!Agent1 = Me!ClientName.Column(1)
-
Linking macros to checkboxes selected on an Access form
Hi,
I have the requirement to copy and paste the results of various queries into Excel workbooks. I've set up macros to "OutputTo" the results of each of the queries (nearly 100!) and I've set up a further macro to export them all rather one after the other than running each macro individually.
Where I'm coming un-stuck is that ideally I'd like to be able to create a form with checkboxes where the user can... -
Adding records to MS Access table from command line
Hi,
I have text files that are created with comma-delimited records inside them. I am trying to figure out how I can construct a command-line method of importing the records to a MSA table. The end result will be that I can right-click on the .txt file, there will be an option on the context menu that says something like "Add records to 'Modules' table", and that will bring up a command window that will execute the import command....
