|
Can a macro ask for a file name ?
I have Access2002sp3 on WinXP. I have a database where I regularly want to
export a table of data to excel. The table concerned varies, and I have
always written a new macro for each table, even though the sequence (or
code) is the same as the last, just a different table name. Is there any way
I can get the macro to ask for the table name, and then export the table I
tell it ? This way ...
|
10 |
30.06.2006 06:24:52 |
|
|
Help a VBA/Macro beginner.
I do not have any background in creating VBA code and very basic knowledge of
macros in Access so please bear with me.
First let me give a brief description of my problem.
I am pulling data from my business software database, I have the tables set
up as a linked table. Then writing a make table query to join a bunch of
tables together to create a new table which I will use in Excel to...
|
4 |
30.06.2006 03:14:27 |
|
|
Unable to close Excel app with macro
I use the following code in Access to open an instance of Excel to do some
worksheet operations and close Excel at the end:
Dim appXL As Excel.Application
Set appXL = CreateObject("excel.application")
appXL.Visible = True
.... code to open excel file, do some simple operations, save file ...
appXL.Quit
Set appXL = Nothing
When the macro is done, it seems like Excel closed normally (go...
|
8 |
28.06.2006 21:29:03 |
|
|
OrderBy with multiple fields
I should be able to figure this one out, but it's late:
I'm trying to sort a report by two fields. I can do it easily if I
hard-code the fields. However, I want to get user input and store the
input in variables, which would then be used in the OrderBy method.
Right now it looks like this and is not working:
rptMember.OrderBy = strfield1, strfield2
What am I doing wrong? Any help wo...
|
2 |
28.06.2006 19:18:11 |
|
|
Need macro to reverse a name in one field
I'm sort of a novice macro developer but I really need help from someone
concerning reversing a name. I have a long list of names in one field that
are in last, first middle initial (sometimes without the middle initial and
sometimes the whole middle name) order and I need it reversed to just first
name and one space and then last name to make a mailing list. Unfortunately,
this data is...
|
6 |
27.06.2006 23:24:54 |
|
|
Macro Sequence
Do macro's run in succession or do they run concurrently?
If they run concurrently, how can I set them up so that the steps will run
one after the other.
Reason is my queries create tables which are dependent on each other....
|
4 |
27.06.2006 20:08:27 |
|
|
replicating an excel macro in access
hi
i'm a teacher and have created a reporting database. for my database
to work i have an reports table that looks like this that has the
following fields.
Admin No : unique pupil number
Subject : subject studied
Set : class name that pupil is in for that subject
Attain : attainment grade
Classwork : letter grade
Homework : letter grade
Behaviour : letter grade...
|
2 |
27.06.2006 20:04:55 |
|
|
Maximize
I have got a database which has a mian page which then can open up three
forms which have been done with command buttons. Everytime i go into the
database my main form is not big enough i always have to maximize it. Is
there anyway that i could run a macro in the back ground so everytime i open
up the main page it is the size of the screen not a small page as it is quite
annoying to do t...
|
2 |
27.06.2006 07:32:57 |
|
|
Help required for SendObject command in Access 2003
I have been running a SendObject command within MS Access XP (2002) for a
year or so now with no problems.
I have just recently updated MS Office to the 2003 version and since then
the macro has not worked correctly.
The macro completes, as you would expect, with the dialogue box from Outlook
letting me know that i am sending an email automatically.
I click yes to confirm and the macro co...
|
2 |
26.06.2006 17:06:51 |
|
|
distribute sectiions of report to different email addresses?
I have a report that is grouped by Department Heads. When printed, each
section begins on a new page that is then snail-mailed to the relevant Head.
I have a field attached to the Department Head with their email addresses. I
want to be able to email the report, using the emails in this field, so that
each relevant Department Head receives only their own data....
|
8 |
26.06.2006 16:56:52 |
|
|
RunCode Error in module
I'm using Access 2002. I converted a macro to a module because I need each
step to execute separately - and then I added a RunCode macro to execute the
module. The problem I'm having is when I execute the macro (with a command
button on a form) I get the error "The object doesn't contain the Automation
Object 'Converted'."
How can I fix this? I can't locate any information on this error...
|
3 |
25.06.2006 16:03:01 |
|
|
DLookup in Set Value
Hi!
I'm trying to set the value of a field in a form to a number I'm looking up
in a table where it's between certain dates on the form.
Here's the expression in my macro (set value action, to set the value of the
Fuel textbox on my form):
=DLookUp("[FAC_PCT]","RInjFPct","[EFF_END_DT]<=Forms!DateF!ProdEnd and
[EFF_START_]>=Forms!DateF!ProdBeg")
I have 12/1/2005 as the ProdB...
|
5 |
24.06.2006 00:58:37 |
|
|
Stop AfterUpdate macro from running
When I insert a new record in a subform and then move off the sub-form, the
AfterInsert and AfterUpdate events/macros are both running, one after the
other.
Is there anyway of preventing the Afterupdate event/macro from running as
well as the AfterInsert method (when I insert a new record). I have separate
pieces of code that run on for each event but the code that runs on the
AfterUp...
|
3 |
23.06.2006 21:54:50 |
|
|
Create a new macro or copy & change an existing one-which is bette
Here's a doozy....
I have a form (Banner Evaluation Comments) from which I need to pull and
print comments from another form (Banner Data Entry Evaluations). Both forms
have individual command buttons. There is a table, query, report and form
for both as well.
Would it be better for me to create a new maco to pull this info or copy and
change an existing macro? I have another form...
|
9 |
23.06.2006 20:14:02 |
|
|
Hyperlink or Marco for Generating an Email from a form
I have tried the insert hyperlink and get an error message: "Unable to open
"emailed address". Cannot open the specified file.
the help file says: To test the link in a form or report, right-click the
label, point to Hyperlink on the shortcut menu, and then click Open.
Microsoft Access opens your mail program and creates a new message, with the
address and subject filled in.
When I...
|
5 |
23.06.2006 20:07:01 |
|
|
Automatically adding a new record
Brief summary:
I have a main form to hold employee info and a working hours subform. Each
employee has many records.
I would like to add a new record for each of the permanent employees while,
at the same time, add on 7 days to the date field.
Can this be done with a macro (and I am not an expert macro writer)? Or can
this be done with an update query?
cheers...
|
6 |
23.06.2006 20:02:47 |
|
|
Exit Access When Exiting Switchboard
I have a small database with a switchboard. I have successfully written a
macro to close the switchboard to the query tab of the database window. What
I really want to do is exit access enitirely when I click on the exit button
of the switchboard or at the very minimum close the database window....
|
3 |
22.06.2006 23:25:02 |
|
|
create macro in access: tally votes
Hi- What I desire to do is fairly simple. I want to create a simple voting
form which will require a macro. The form will contain two objects: a
numerical field to be entered by the user and a button.
First the user enter's a number on a voting form, which selects the "Person
Number" (a field that has already been populated using another form) and the
current number of votes that...
|
2 |
22.06.2006 20:30:25 |
|
|
"Action Failed" in Access 2002
Hello,
We have a Windows 2000 server that holds an Access 2002 database on it. On
client machines with Windows XP (using Access 2003), users can link to the
database without a problem, but occasionally one user needs to log in to the
server through Terminal Services and use the database that way. She never
used to have a problem with this, but I believe it was the last time we ran
Win...
|
1 |
22.06.2006 16:30:02 |
|
|
Combine Multiple tables into One Master table
Hello All Database (Access) Guru's,
I am a novice when it comes to databases and I know enough to get
simple information for my needs. With that said, I was given an
opportunity for improvement a database.
heres the scenario or process that I am facing
1. A total of 3 text files are generated from the mainframe and save
to a secure network share. In each text file only raw...
|
2 |
22.06.2006 08:23:23 |
|
|
Macros - how to delete headings
I created a macro and placed a link on the toolbar. I then went on to delete
it but I can't get rid of the link. Can any one tell me how to clear this
from the toolbar please?...
|
1 |
21.06.2006 21:08:02 |
|
|
Save Macro
I have a main form bound to a parent table and a sub form bound to a child
table. THe child table has a combo box that the user can enter only items
already in the table. I have created a form to add items to this table. I
have created a command button to go to this 'add to' form. After the new item
is added to the table, I created a Save button. However, when the user clicks
the 'Return...
|
2 |
21.06.2006 20:42:04 |
|
|
Similar property in Access as DisplayAlert in Excel?
Access does not support the method "DisplayAlert", then how can I
disable the pop-up msg in Access?
...
|
3 |
21.06.2006 18:00:06 |
|
|
Copy/Paste
From within a VBA MsAccess application I:
- open a Visio document,
- selectAll objects,
- copy to clipboard
- open a Word Document
- Paste : "wDoc.Selection.PasteAndFormat wdPasteEnhancedMetafile"
I get a run-time error "4605 Command not available"
If I change the Paste statement as "wDoc.Selection.Paste" I have no
problems, but I don't like this, because I need to copy an Image o...
|
2 |
21.06.2006 05:06:25 |
|
|
How do I stop an AutoExec in process?
I have created a database that has an AutoExec to Hide the DB Files and run a
macro. At the end of the AutoExec, I added an Exit command. Now I can't
stop the database to work on it, put it into Design Mode. How do I open the
DB in
Design mode or break out of the AutoExec?...
|
3 |
20.06.2006 01:08:02 |