|
Macro Function explained
I need help writing a macro that will retrieve data from a table in one
database and update a table in another database. Can someone help me with
this?...
|
2 |
20.03.2006 01:47:08 |
|
|
Copy information from datasheet to datatsheet
I have a datasheet - named A and would like to creat a macro to automatically
copy the information in Salary Draft to another datasheet named B. I had
tried numerous actions which I can't reach the desired results. Thanks in
advance...
|
5 |
19.03.2006 07:31:16 |
|
|
Show progress of large macro
I found this, Free chapter from the Access Cookbook: How to Create a Generic
Reusable
Status Meter
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacbk02/html/ODC_CookbookChapter9.asp
However I am having a problem with it. My module looks like this:
What am I missing, or what it is I have that I shouldn't have. Rather new
to Macros, and did the upgrade Macro funtion....
|
8 |
19.03.2006 18:42:13 |
|
|
Transfer Large Access table records to Many Excel Worksheets
I have a CSV file that has 1,286,881 records on it. I need to put them in an
Excel file. Excel will only take 65553 records. So, I imported the CSV into
Access just fine, but how do I run a macro or query that will transfer a 65,
000 number of records each o Excel?
I need to tell it to send 65,000 to Excel worksheet1 , then send the next 65,
000 to Excel worksheet2, etc, etc,.. up to 1...
|
2 |
19.03.2006 01:25:26 |
|
|
Access won't close
I am running a macro that contains a RunCode command.
After the code runs, there is a quit to close the database.
This worked fine in Access 97, but when I converted the db to Access 2003,
the code will run great, but the quit doesn't happen. The DB stays open and
if the macro is scheduled to run later on, it won't because it is still open.
Help!!...
|
1 |
19.03.2006 00:07:27 |
|
|
Randomize table
I have a query that is controlled by a list box. I am looking to randomly
pick 9 names from this query and put into a report. I have some code that
will randomly pick 9 names, but i need it to be able to pick a single name
more than once. So instead of having a,b,c,d,e,f,g,h,i It would be more of
something like this: a, b, c, a, d, h, c, a, i. ...
|
3 |
18.03.2006 18:31:27 |
|
|
open file to switchboard...
I'd like to have my Access file open automatically to the switchboard. When I
go to Tools, Startup on the menu bar it allows me to set the start up to
switchboard, but the main database page opens as well. Do I have to create a
macro to open the file to the switchboard; then minimize any other windows?
And, if so, how do I do this? Any help/suggestions offered are greatly
appreciated. Th...
|
2 |
18.03.2006 01:24:30 |
|
|
SynchronizeNow
I have this idea to reduce a lot of clicking without creating a custom menu.
There is an option in a macro to RunCommand>SynchronizeNow, but this does not
work if it is attached to a button. If I create the macro and double click
on the macro, it runs. Build a button and attach it to the macro, when I
click the button nothing happens.
I have also tried the SendKeys %tps. The macr...
|
2 |
17.03.2006 22:35:18 |
|
|
is it me or is run app a pile of crap?
I have a user prompted query that id like to word merge into a letter.
Ultamately id like to have a macro that would print the merged letters ask
for another prompt and then merge yet another specific letter. I cant get run
app to work at all if any one can help please let me know id be willing to
discuss this e-mail or over the phone....
|
2 |
17.03.2006 20:38:28 |
|
|
Access App Challenges
My main form includes 3 subforms. I need information to display on certain
subforms based on objects in other forms, i.e. check box clicked in subform1 -
message displays in subform 2. I have created update queries to update the
tables based on user responses and then macros to run the update queries. I
then associated the macros to the AfterUpdate Event on all the forms. Problem
is the messa...
|
1 |
17.03.2006 02:04:55 |
|
|
How do I make a # be a text field importing from Access into Xcel
I am using a Macro in Access to "Output to" Excel using an Object type of
"Report". there is a numeric field that needs to be a Text field in Excel
but Excel is automatically making it a numeric field. It is a Text field in
Access. Is there a way to ensure it stays a Text field in Excel?...
|
2 |
17.03.2006 00:17:46 |
|
|
/x macro in Office 2003
I have set up a number of different logins to my database using /x macro.
This works perfectly in Access 2000 but my organisation is now moving to 2003
and they don't work any more. Any ideas?...
|
2 |
17.03.2006 00:13:35 |
|
|
SetValue returns Type mismatch... WHY?!?!
I'm trying to generate a simple report in Access that, for each record, will
display the value of one data field if another data field contains the text
"see below". This ought to be an easy thing to do, but I'm having a very
difficult time and the online help is no help at all. I get a "Type
mismatch" error using the following macro:
[Reports]![MyReport]![Text15]=String(80,[Reports]![...
|
3 |
16.03.2006 01:56:46 |
|
|
windows task scheduler bypass longin
I have created a macro named Marco1, which will send e-mail, also created a
scheduled task from windows XP scheduled task wizards with the following
shortcut in the "Run" field:
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "C:\Program
Files\ServiceClient\myFrontDB.mde" /wrkgrp "c:\miracledb\mo.mda" /cmd
"c:\miracledb\myBackEndDB.mdb" /x Macro1
The scheduled task is running ...
|
3 |
15.03.2006 21:47:29 |
|
|
Switchboard/macros, query not prompting for input
I have a switchboard button that calls a macro, that in turn opens a report
based on a select query. The query will prompt for a value. On one computer
the macro will not work -- the prompt from the query never gets displayed.
This happens on any of the buttons where a macro opens a report. Other
macros work, such as one that exits out of Access. I have macro security
set to low. A...
|
3 |
15.03.2006 21:28:29 |
|
|
I changed the macro security level and now the wizzards won't run
After changing the macro security level I open a database and I can't run any
winnards. Have any ideas?...
|
2 |
15.03.2006 20:36:29 |
|
|
Macro using "Output To" asks to overwrite
I have created a macro that uses the "Output To" action to export 17 reports
in rtf format. Each time a report exports, I am receiving a question of
whether or not to overwrite the existing file. I would like to override
this. I read a question from 2/14/2006 that says it can be done through
Visual Basic but I am not too familiar with writing code in VB. I sent to
the MVP requesting ...
|
2 |
15.03.2006 17:22:20 |
|
|
How do run a query and export it to a table all in the same macro
How do run a query and export it to a table all in the same macro?...
|
6 |
15.03.2006 16:52:27 |
|
|
printing (quantity)?
Is there a way to prompt the user about how many copies of a report to
print, when running a macro?
Or some other method that would work vs. putting the open report (print
view) in seven times.
TIA,
_Bigred
...
|
1 |
14.03.2006 20:40:53 |
|
|
Conditional Macro
I have a form that has three fields and the data that is entered in these
fields will cause a text string to be entered into the subForm field [field4].
[field1] is a Yes/No response
[field2] text entered is either “ENL” or “OFF” or “DUAL”
[field3] text entered is either “NO RCD” or “PULL” or “REMARKS”
The macro is set to the After Update properties for [field3] of which I
created a ...
|
3 |
14.03.2006 18:47:10 |
|
|
access
I am trying to pull the sum of some times in fields from access to excel
using a visual basic program. When it gets into excel the formula doesn't
work. What am i doing wrong. Please help if you have any idea. Thanks.
Tim...
|
2 |
14.03.2006 17:36:48 |
|
|
design the web page
please help me how would I design the wab page please send me
yours
md.rafi
...
|
1 |
13.03.2006 15:56:40 |
|
|
html
please send me about html
yours
rafi.alam
...
|
1 |
13.03.2006 15:43:53 |
|
|
Find text but excluding commented text in VBA macros
I would find it very useful to search macro code but excluding the comments.
for example, i would like to search "if lngX = lngY then" but not within
comments within the procedure/module/project.
like most developers i keep a history of corrected or enhanced code within
the macro code as commented out text. i appreciate that this increases the
size of the ADP/MDB files and could impai...
|
1 |
13.03.2006 11:36:28 |
|
|
Export to Excel using a template
Hi all,
I have a macro which exports a table to MS-Excel (trasfer spreadsheet). Is
it possible to use a pre-defined format e.g. a MS-Excel template in order to
export data from that table to Excel?
My Excel template has some headings and I want to export data starting from
row 5.
Thanking you in advance
George...
|
1 |
13.03.2006 07:38:30 |