Search results for query: *

Hi all, I'm trying to pull a specific value from a cross tab query for a report. Is Dlookup the proper function to use? Also, I need to key off the column name instead of the column index for the appropriate field, because the query is dynamic. Any thoughts? Thanks, Cram

Hi Skip, I'm writing a script which creates a new file (which I will be running numerous times), and the output file needs the worksheet event code. I guess I could just paste the code every time I need to, but I was just looking to avoid an extra step. thx, Cram

Hi all, I'm trying to use a macro to automatically insert code for a worksheet event (worksheet selection change). I was think along the lines of the following below. Any thoughts? Dim wks1 As Worksheet Sheets("Data").Select Set wks1 = ThisWorkbook.ActiveSheet...

Hi all, I need to have an event triggered in Excel in a specific worksheet when a cell is selected (one of several possible hyperlinked cells). Any thoughts on setting up event handlers? thx, Cram

Hi all, I'm working some code for the first time, and need a little backup here. I've got a form where I'd like to run a procedure after the user clicks a command button. The procedure checks two queries to see if the data entered meets two distinct criteria. The code craps out after opening the...

Hi all, I'm a new Access user having a difficulty with a form. I have two combo boxes in a form [Project Manager] and [Project]. [Project] adjusts based on the user input of the first combo box, and the user selection of the [Project] combo box displays the corresponding records in a subform...