ACCESS 2007: CREATE A BUTTON ON FORM TO LAUNCH MS WORD
Sat, 20 Mar 2010 13:43:01 -0700
I AM CONVERTING FROM ACCESS 2002. WE HAVE A FORM WITH COMMAND BUTTONS TO
LAUNCH WORK AND EXCELL FROM THE ACCESS FORM. IN 2007, THE BUTTONS DO NOT
WORK. THERE DOESN'T SEEM TO BE ANY PROVISIONS ON THE MACRO DESIGN OR THE
COMMAND RUNAPP AVAILABLE...HOW CAN WE RE DESIGN THE FORM TO INCLUDE THIS
COMMAND BUTTON? ...
|
Enable Echo Macro Action in Access 2007
Fri, 19 Mar 2010 11:44:01 -0700
Hi,
The Echo action does not appear in the actions drop down when creating a
macro.
The database is in a trusted folder.
How do I enable the Echo Action.
Thanks! ...
|
Using check box to clear data in a field
Fri, 19 Mar 2010 11:14:02 -0700
I would like to write a macro that will clear data in a combo box if a check
box is selected. The purpose of the check box is to designate a record as an
archive. One of the fields of the combo box is blank. When the check box is
selected, I want the combo box to select the blank field. Can this be done? ...
|
Deconstructing a table
Fri, 19 Mar 2010 10:34:01 -0700
Hello,
I am hoping to work out a method to transform a data table into a running
list.
The table has identifiers in column A, and product weights in a dynamic
number of columns to the right. i.e. Cols B-M. I would like to manipulate
the table into a running list of three columns
Col A = Value of ID @ r ...
|
Trying to populate data using a Macro
Fri, 19 Mar 2010 08:08:01 -0700
On my main form, I have two controls (ManagerSelect and TenureBox) that
populate conditionally based on the value selected for a third control
(EmpName). I've written code using the DLookup function to select the
appropriate data:
=DLookUp("[Manager]","[EMP]","ID=" &[EmpName])
=DLookUp("[AdjServiceDate]","[ ...
|
Macro in Access 2007 will not convert to 2000
Fri, 19 Mar 2010 07:33:01 -0700
Hi, I am new at this so please bare with me. I downloaded the sample Contact
Management Database using Access 2007, however the person I am writing the
program for is using Access 2000. After making all necessary changes, I
saved the document as an Access 2000 document. One of the macros will not
convert ...
|
Export a List of Reports in Microsoft Access
Thu, 18 Mar 2010 11:25:31 -0700 (PDT)
I have an Access application which contains many reports(100+). I'm
trying to get a list of the reports without having to manually look in
the application to make the list. Is there a way to export a list of
the reports with, perhaps, the fields utilized by the reports? ...
|
|
|
entiring data from af orm to a table
Wed, 17 Mar 2010 06:46:32 GMT
Hi all,
I want to use a form to enter the data from it to a table 2 which is easy,
but my problem is how to pick items (in the form) from another table 1 and
save it in table 2 :
Table 1 Table 2
items 1-Job with many items
...
|
Yes/No pop-up
Tue, 16 Mar 2010 10:13:01 -0700
Using Access 2003, I have a macro w/ a series of commands
(append/make/update queries), but prior to them running, I want the user to
answer a "Yes/No" question ("Are you sure you want to do this?"). How is
this done through the macro - the initial line-item? I'd PREFER to do this
through a windows-messag ...
|
runtime error '1004':Unable to get match property of worksheetfunc
Mon, 15 Mar 2010 08:34:01 -0700
Run-time error '1004': Unable to get the Match property of the
WorksheetFunction class
in response to
map2 = Application.WorksheetFunction.Match(map,
Worksheets("pcmap").Range("B2:B13"), 0)
in an Excel 2003 macro.
Does anyone know why? Help text seems to say it's OK. ...
|
