|
Using a macro to change design view of a table
Hi
I have inherited a few databases and there are regular reports I now have to
run from them. Macros have been set up, but I would like to make the report
easier.
Is it possible to change the design view of a table by using a macro? I know
how to open the table in design view using a macro, but there are fields that
I need to change the data type each time I run the report which is a ...
|
2 |
12/31/2008 2:24:56 PM |
|
|
All the things in my macro are not running
I have a macro that is running 31 different append queries. When I run the
macro it gives me the key violation error on a couple of the append queries,
but when I go back and run them manually they work just fine.
Any ideas on why it's not working in the macro but it does when done manually.
~Kelly...
|
6 |
12/30/2008 4:56:16 PM |
|
|
Show or hide columns in form on click
I'm have a mainform that directs the user to other form to input data, but
I'm not sure how to get one action button to only show x and y columns of
from Z and the other action button to only show columns A and B of form Z.
I'm guessing I need to use VBA to do this, but have no clue what commands
would accomlish this or if this can be done with a simple macro.
Thanks...
|
2 |
12/30/2008 2:16:06 AM |
|
|
msnews.microsoft.com
msnews.microsoft.com...
|
1 |
12/29/2008 12:43:26 PM |
|
|
startup options
I want to open the database using the autoexec macro and display only the
switchboard. Right now there is a titlebar accross the top that has the name
of the database and form as well as the close and minimize buttons etc. The
only thing I want displayed is the switchboard.
I have the switchboard maximized with no border but I cannot get the very
top title bar to disappear.
I am trying ...
|
3 |
12/28/2008 7:43:00 AM |
|
|
print multiple reports
What's the easiest way to print 30 reports? Even more as time passes. I'm
assuming a macro.
First issue: I need to open the report in print preview so the caption can
build itself. Then I need to issue a print command to go to my PDF printer,
which I have set as default. The caption becomes the PDF filename. That's
why I need the report to open fully.
OK, moving on, once the print co...
|
2 |
12/27/2008 3:12:39 AM |
|
|
Filtering Current Record
I have a continuous form with a button on it. What I’m trying to do is when
the button is clicked open the record of the button that was clicked. I’ve
been playing, but the more I play the worse it gets. Would someone point me
in the right direction?
--
NotGood@All...
|
4 |
12/25/2008 1:33:24 AM |
|
|
Run a query on my DB, to list all issues for a particular fiscal y
I have a table that has a tracking number, date originated, issue, and a crop
year. I have a query that generates a report by crop year, which the user
puts in the crop year (for example: 2007) and it generates the report.
However, now they want another report based on fiscal year. There is no
where that I capture the fiscal year, but I do have the dt_originated field
that on my query...
|
4 |
12/22/2008 3:05:04 PM |
|
|
ODBC - call failed during runing of macro
Hi,
I am running a nightly macro in Access to rebuild tables using an ODBC link
with Microsoft Task Scheduler. This macro runs multiple macros. Once every
week or so the macro is stopped & I receive Access error #2950. It always
stops when the second sub-macro is run. I also get the ODBC--call failed
error. It's very confusing because the first sub-macro uses the same ODBC
link.
...
|
2 |
12/19/2008 7:43:04 PM |
|
|
Problem command buttons not working
database was created in Access 2003 and our computer was upgraded to Access
2007, it open database in Access 2007 and all working fine, then suddenly
command buttons stop working. Any idea how to solve this?...
|
2 |
12/19/2008 7:22:01 PM |
|
|
Help with a macro please...
We are working with a massive database that I have to run daily reports from.
I have created a macro in Access to output those reports to a directory on my
virtual hard drive. I have created a macro in Excel to transfer those reports
to an Excel workbook so they are all in place, format each sheet and close
the originating sheet. Is it possible to have a macro that will do all of
this? S...
|
3 |
12/19/2008 7:14:03 PM |
|
|
warnings help
I have a macro that runs an update query in access 2007
when I execute the macro I get a warning that I am about to run an update
query that will modify the data in my table
I used to be able in 2003 to set warnings off I believe was what I did to
prevent these from showing. Is there a way to stop this from showing in
2007? I just want the macro to run
Thanks
Tom...
|
3 |
12/18/2008 4:44:06 PM |
|
|
Warnings help
I have a macro that runs an update query in access 2007
when I execute the macro I get a warning that I am about to run an update
query that will modify the data in my table
I used to be able in 2003 to set warnings off I believe was what I did to
prevent these from showing. Is there a way to stop this from showing in
2007? I just want the macro to run
Thanks
Tom...
|
1 |
12/18/2008 9:56:02 AM |
|
|
How data can be consolidated in tree form?
In the following example, each level has its own data (stand alone). And I
want to know, how can I get aggregate (shown under Aggregate) at each level
which is equal to its own date plus the aggregated date of its immediate
children:
Levels:
Grand Parent 1000
|
Parent 1100
|
Children 1110
Data Available in Data base:
Company Name ITEM Amount
---...
|
2 |
12/18/2008 8:30:01 AM |
|
|
SendObject Fails on one PC and not another
I've heard the SendObject is a bit buggy, but I was hoping someone would help
me.
The Macro has some usual steps (openform, closeform) to pull data into the
To field and Message Text field, it's pretty standard. Works perfectly on my
PC, but when the person I'm designing this for tries it they receive the
(Action Failed; Condition:True; Action Name:SendObject; Arguements:-1, , ,)
e...
|
2 |
12/18/2008 12:22:04 AM |
|
|
Using a macro to run an update querey
I am having trouble getting a macro to run a query if there is any other
action in the macro.
I am trying to run an update query with out seeing the warnings. If I use
setwarings/on to ‘no’ the query doesn't run. If I eliminate the warning
action the query runs.
I first wanted to run two queries at the same time, and when they didn't
work I started eliminating actions until...
|
2 |
12/18/2008 12:04:00 AM |
|
|
DLookup Two Fields
I've given up. My condition for the macro is below but when I run the macro
there is no message displayed and the balance of the macro does not run. What
I need is that if the OffLedgerDate entered on the form (in text format
yyyymmdd) is found in the DistDate field on the dbo_uTempLabor_All table AND
if DayDots is found in the Corp field on the dbo_uTempLabor_all table, a
message is to ...
|
6 |
12/17/2008 6:09:30 PM |
|
|
Access Saved Import details
Is there a way, maybe using vba code, to pull in the saved imports from a
table creation? I create a table and save the import steps and then need to
reimport this file later in a macro. I need to do this with about 90 tables,
so I want to automate it. Any suggestions on how? We don't run Outlook at
this point, so I can't schedule it to run. I want the macro to kick it off....
|
1 |
12/17/2008 3:57:13 PM |
|
|
correcting data fields
I have in the past (longtime ago) corrected data in a field using a macro or
query. For example; I got to the 5th position in the field, then copied
the next four positions, then placed them in a new field. A good example
is; getting the house number only from an address that had house number and
street name.
5555 Washington St cut the 5555 and put it into a new field set up for str...
|
8 |
12/17/2008 2:24:23 AM |
|
|
Export to CSV no text qualifiers in the header
I need to export a file to a CSV, the required headers have " "'s and I
cannot have them, can anyone help?...
|
2 |
12/16/2008 9:16:06 PM |
|
|
I need to Export a chart not data
How can i export a pibot chart from Access 2007 to word 2007 as a gif, or jpg
but not the data?...
|
2 |
12/16/2008 8:22:01 PM |
|
|
Set Warning won't turn back on
User has Access 2002 SP3
She uses Set Warning in various places in her macro. She has turned off Set
Warning during database design and now wants it back on. She has set it to
yes, but the function to create a new table just runs and does not give the
warning.
For now we are restoring the file from a backup but are curious as to why
the Set Warning does not come back on. I do not ...
|
3 |
12/16/2008 1:45:02 PM |
|
|
Backup Macro
Hi, I'm trying to create a macro for my database that will back up the data
tables (or the entire database) as the database is being shut down.
When I put RunCommand into a macro, though, and select "Backup", I get the
error message:
"The command or action "Backup isn't available now.
* You may be in a read-only database or an unconverted database from and
earlier version of Microsof...
|
1 |
12/15/2008 6:27:01 PM |
|
|
Pulling in .txt file via macro - NEED HELP
Fairly new to Access Macros; trying to do the following:
- create a macro that pulls in a .txt file (needs to be pipe delimited) -
entered Transfer Type "Link Delimited", but stumped as to what to put in for
Specification Name
- Then need to create a query that removes certain data (trading positions
from several books)
- Then need to export that query (with data removed) as .txt file ...
|
4 |
12/14/2008 7:10:53 PM |
|
|
Registry values to disable all macro security warnings in Access2007
Hi,
Am unable to run all macros even after doing registy editing as shown below.
Please advise. Some macros are appearing with an information symbol in design
mode(means won't be executed) Please advise.
Regards,
Charley
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security]
"VBAWarnings"=dword:00000001
[HKEY_LOCAL_MACHINE\S...
|
6 |
12/14/2008 10:26:04 AM |