Search results for query: *

Try strFile1 = "S:\Exports\" & Me.NAME & ".xls" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, strQuery, strFile1, Yes Karl

Wow, I will try this out. Thank You! Karl

I need some VBA code that I can include on a form so that whenever I click on any object on the form, a mesage box will tell me the contents of the Name property of that object. Thanks. ps. I have tried Me.ActiveControl.Name, but it does not always give me the name of the object on which I am...

I am using Adobe Acrobat Professional 8 and when I choose File, Attach to email...it does it just fine. However, it automatically creates the subject line of the name of the file followed by the text "Adobe Acrobat Professional". How do I stop it from adding the text? Karl

Thank you. Star. Karl

Yes, I can put the code in a procedure (or function), but then I have to code "calling" of the procedure on each of the command button's on click event. I am looking for an easy way to specify that any buttons that are in this "group" will run this code (prodedure) as well as any code for that...

I have a form with five command buttons. I would like to be able to associate VBA code with a GROUP of those buttons, and not have to duplicate the code in each individual command button's on click event [yeah, I could just execute the procedure for each button, but...]. Just wondering if...

Just in case anybody is reading this... I actually used [fld_a]="A" on the "extresion is" conditional formatting of fld_b. Karl

I used conditional formatting and it worked fine. I used EXPRESSION IS [fld_b]="A", then set the color I wanted. Thanks for pointing me in the right direction. Karl

I have a subform where I am displaying records as a continuous form in a detail section. I'd like to make one field a different color depending on the contents of another field in the same record. If fld_a = "A" then I'd like fld_b to be red font color. If fld_a is any other value, I'd like...

No ideas? Karl

I have a table that has from 1 to 7 records for each account number. If there are all seven, they will be numbered individually 1 through 7 in field-x. If there are less than 7, field-x may contain any combination of numbers, but there are never more than one of each number (i.e., there may be...

I'd get rid of the three BHO (no name). Karl

You need the DoCmd.TransferDatabase Karl

In the instructions previously given (above), change: FullPath:"P:\Maint\MaintDBase\DWFFiles\"& FileName to FullPath:"P:\Maint\MaintDBase\DWFFiles\"& FileName & ".dwf" Karl

It (on change) is executed when a DIFFERENT tab is selected. Karl

OK, I can get it (On click event) to work when you click to the right of the tabs and above the body. I guess you can tell I am trying to learn this too. Karl

Out of curiosity, I tested this, and the event is triggered when you click on the "body" of the tab and not on the "tab" portion! I couldn't find an "OnChange" event for a tab control. Karl

Try... Dim dodo As String dodo = blah MsgBox dodo Karl

Thanks Paul. Where in my report do I put that expression? I'd like my report to look something like this" Case Corp_Cd Account Acct_Name Amount 2 260 10060 PETTY CASH 1,085 2 260 10475 BANK - OPERATING 11,166...