|
how do you show all macro options (not trusted)
I have the database in a trusted location and I have the security set to
enable all macros and the show all actions button in the ribbon is still
unavailable.
any suggestions?
Thanks...
|
2 |
12/14/2008 10:13:00 AM |
|
|
turning off prompts??? is this possible???
I have set up a macro that deletes old data and pastes new data into a
couple of tables. the problem is the following prompts forces the user
to interact. Is there a way to turn these off or disable them during
the running of the macro???
You are about to delete 1 record
You are about to run an update query that will modify your data table
You are about to update 1 row
You are about to ...
|
2 |
12/13/2008 4:46:39 PM |
|
|
How to list macros in Access 2003
I would like to list the macro names (and their actions if possible). The
AllMacros collection just gives me the macrogroupnames. Is this possible?...
|
3 |
12/12/2008 9:36:08 AM |
|
|
A macro to create a folder when a record is saved
Hi all
I am not quite sure if I can do this, or where to start.
I am using Access 2007
I am designing a DB, which will have a products section, and what i want to
do is the following:
When I save a new record I want a macro or code that will create a new
folder for that product. ie a new product is created with a [ProductID] of 1,
when I save this record, I want a folder created ...
|
2 |
12/11/2008 7:13:21 PM |
|
|
output file name - errors
I'm trying to use this:
="c:\" & [Reports]![PINN_AntibioticCharting by PT#]![PAT_NUM] & ".snp". I'm
running report PINN_AntibioticCharting by PT# which I'm trying to output to a
snapshot with a unique file name related to the patient number that is
entered via a parameter query. When the macro runs it keeps erroring
indicating unable to find that report - not open or mispelled. I'm usi...
|
4 |
12/11/2008 1:00:03 PM |
|
|
TransferSpreadsheet Macro
I have a query that gives me sales figures for our department. I am trying
to create a macro to export these numbers to Excel. I have tried the
Transferspreadsheet Action but, I get an error saying that I must use an
updateable query. I already have an Excel spreadsheet created with two
different worksheets for two different queries (qryReps and qryDepartment)....
|
2 |
12/11/2008 10:40:49 AM |
|
|
TransferSpreadsheet user to select directory
Hi,
I am using this function to get the user to select the directory to save
some files.
But I don't want the user to type in the filename, I want to hard code the
file name + add last month's name to the file. How can I add the date as a
variable to the filename??
Function Save_FileName() As String
Dim strFilter As String
Dim lngFlags As Long
strFilter = ahtAddFilterIte...
|
1 |
12/11/2008 6:36:00 AM |
|
|
Import Text file Name into Access
Here is what I am looking for:
Sample:
I have these files in a directory
- Nov 2008 Sales.txt
- Oct 2008 Sales.txt
- etc.
I have written a vba loop to import all these files into a single
table however if I need seriatim data by month the fields in the file
do not have the dates so I was wondering if any one knew of a way to
insert a field that reflects the file name.
Thanks in A...
|
2 |
12/10/2008 3:35:08 AM |
|
|
NEWBIE Needs To Import All Records From A Folder
OK - First things first... This is literaly like the 5th time I have ever
even opened Access - so Access terms and methods are still foreign to me. I
do a lot of VBA in Excel and I am told that Access VBA is very similar, so I
am reaching out for help. Again, I would have searched this out first, but I
don't know the right terms to search on!
I am sure this is pretty simple...
Once I...
|
2 |
12/9/2008 5:55:01 PM |
|
|
SendObject - Two Email pages
I've just learned how to use the SendObject command and I've run into a
problem. I created a button that once the user clicks on it (from a PO
form), it creates an email with a report attached. The report is filtered to
only send pages of the report that match the PO number from the form. Works
great except when I set the "Edit Message" argument to Yes. After I send
the email or cl...
|
5 |
12/8/2008 6:59:02 PM |
|
|
Summing Rows Using Macros
Hi I am looking for a macro code that adds all rows with the same ID number,
creat a new row or column of sums while not adding the ID's and deletes all
previous rows so that I am only
left with the Previous ID and the sum figures in their respective
rows/columns. Please
see an example below. Thanks for any help.
Problem I have
ID Blah Blah1
2 5 2.5
2 ...
|
4 |
12/8/2008 6:27:21 PM |
|
|
SQL Server does not exist or access denied
Hi All,
I have an Access 2003 file that keeps giving the same error message to
two users on file open, but the other two users are not getting the
error. I'm responsible for figuring out why this error is occurring
so that I can resolve it, but so far I'm stumped. The error message
the user receives is "SQL Server does not exist or access is denied."
The very first form that appears on...
|
7 |
12/8/2008 5:31:06 PM |
|
|
RunApp Macro
I am trying to use the RunApp commnad. However, I am unable to get the
command up. I tried to enable all the macros in the Access option but it
doesn't help. How can I get the macro included in the list? Can anyone help?
Thanks.
--
Anthony...
|
3 |
12/8/2008 8:28:00 AM |
|
|
Data()
I have a problem when I wrote the following in a Macro:
SetTempVar CurrentDate, Date()
When I run the program on the development PC, I don't have a problem.
However, when I deploy the database using Access Runtime, on another computer
it now tells me that "it has a function name that the database can't find"
with error 2950.
Can someone please help. Thanks.
--
Anthony...
|
5 |
12/8/2008 12:45:00 AM |
|
|
Backup between two times
I have a program that performs a backup automatically. But I want it to only
back up between 12pm and 6am. Currently it will back up if the time is <12pm.
How should the condition look to only backup between 12pm and 6am?
Current Condition:
Time()<#12:00:00 PM#
...
|
7 |
12/7/2008 8:28:04 PM |
|
|
Passing OpenArgs from a macro
Hi,
I'm trying to open a form from a macro-based menu. I'd like to open the
same form for different menu items, but show/hide controls according to the
menu selection, so I need to send OpenArgs from the macro to the form. Any
idea how to do that please?
Thanks
--
dat...
|
3 |
12/7/2008 3:36:02 PM |
|
|
filtered form to export to excel and excel row format as text
Hi,
I have a form that I would like to filter first and export the report it
generated to an existing excel file. Can the macro perform this command?
I also tried exporting using vba, and one of my problem is the excel cell
format will change to general when I want it to be text format.
Thanks in advance.
Ray...
|
1 |
12/5/2008 11:01:22 PM |
|
|
Do back up between two times
...
|
1 |
12/5/2008 8:01:02 PM |
|
|
Backup OEL Object
I built a DB with an auto Backup function. I backup the table to an Excel
File. In my table I have an OLE Object, this is used to store external files
related to the record.
The table backs up fine except for the OLE Object. This item is left out
completely. Is the something special I need to do to get this to backup?
...
|
1 |
12/5/2008 4:13:01 PM |
|
|
Stopping the "Action Failed" msg when Autokeys macro interrupted
Hi,
Using Access 2003, I have an Autokeys macro which sets key F10 to shut down
the active form. However on one form I have some code in the Form_Unload
event which can cancel the unload and therefore the close of the form
(depending on certain conditions).
If I use F10 to close the form and the conditions cause the Cancel arguement
of the Unload event to be true, the Form_Unload co...
|
3 |
12/5/2008 2:44:11 PM |
|
|
Hidden macro: already tried tools>options>view
Hi:
I inherited this database (Access 2000). There is a form, which has a button.
"on-click" the button runs a macro. I have the name of the macro, because
in the design fiew of the form, once I select the button and look at the
properties, I can see an event launched "on-click."
But when I look for the macro - it's not in the macros objects tab.
I tried the following already:
1) T...
|
2 |
12/5/2008 5:10:45 AM |
|
|
OpenForm macro with 2 criteria
Greetings,
I have a form [PartLookup] which is basically a master list of all [PartNo]
with corresponding [InquiryNo] and customer. There are multiple part numbers
per inquiry, and the same partno may exist in multiple inquiries. I have
another form [NewInquiry] (inquiry overview) with a subform
[NewInquirySubform] (parts within inquiry).
I am trying to create an OpenForm macro that on...
|
3 |
12/5/2008 2:38:44 AM |
|
|
Auto-Generate File Name with Field Content...
Hello all!
I have a DB with a query that I need to get the data out to excel while autogenerating the file name with a field. Initially, I wanted a date range if possible...
IE. NewGradList_01-01-08_to_11-01-08.xls
Previously, I was using a date stamp ->
="NewGradList_" & Format(Date(),"mmddyy") ; however now I need to use a range. These ranges will vary each time the report is r...
|
2 |
12/3/2008 10:38:19 PM |
|
|
my macro just keeps running
I created a Macro on a command button (Print Report). However, I don't want
the report to open if the date field on the form is blank. SO far it's works
by checking to see if the control is null and if so i have a msg box that
tells the user to enter a valid date. (I'm using a calendar activex control
for that so I won't have any issues with formatting)
here's the problem though....if ...
|
2 |
12/3/2008 6:21:15 PM |
|
|
help with stop macro
I created a Macro on a command button (Print Report). However, I don't want
the report to open if the date field on the form is blank. SO far it's works
by checking to see if the control is null and if so i have a msg box that
tells the user to enter a valid date. (I'm using a calendar activex control
for that so I won't have any issues with formatting)
here's the problem though....if ...
|
4 |
12/2/2008 9:48:03 PM |