Recent content by deduct

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