Search results for query: *

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

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...

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...

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...

Case Corp_Cd Account Acct_Name Amount 2 260 10060 PETTY CASH 1,085 2 260 10475 BANK - OPERATING 11,166 1 MLS260 1000090 CASH ACCOUNTS -4 1 MLS260 1000090 CASH ACCOUNTS 12,251 2 260 10700 CASH-B TO B...

Say I have a database with four tables. This database is used by various people as a standalone application at various locations throughout the state. Next suppose I release an updated version that will work with the existing four tables. I would like to put a command button in my updated...

I have a form, on it are two combo boxes, one for the year and one for the division. The user selects the values in each combo box, then clicks a command button that runs a docmd.openquery (the query has criteria that come from the combo box values). This works like a charm. However...

In order to Carry the values of certain fields from the current record into the next new record I want to insert this code into an event of my FORM: fld_1.DefaultValue = "'" & fld_1.Value & "'" fld_2.DefaultValue = "'" & fld_2.Value & "'&quot...

I have an Access 2000 front end to a satellite feed taking data from a Martian Orbiter. My problem is - how do I calculate the average surface temperature during each orbit? The fields I am using are marsTemp, marsTime, marsOrbitDuration, marsNumberOfReadingsTakenDuringEachOrbit, and...

I have been given an Access 2000 database. It is 32MB in size. I know little about the database except that almost all of the tables are empty and the ones containing data have only a few records. I have run the "compact and repair" and that did not reduce the size at all. My...

I have a report that contains a text box with the data source of CORPCODE. When I preview the report, it properly displays the CORPCODE in the page header (which I have set to display on "all pages"). Problem is when I use the "analyze with Excel" tool button, the resulting...