How to automatically stop a macro
Mon, 8 Sep 2008 08:37:01 -0700
I have a macro that I designed with Access 2003 to open a table, copy one
cell and paste the value to the appropriate blank cell in the next record.
The problem is, the data is derived from a .xls file that is always of
different lengths. One day it will be 140 records, the next 35. As such, I
want to com ...
|
My form won't open since I created a macro
Sat, 6 Sep 2008 10:08:44 -0700
Hi:
I created a macro (based on one that worked perfectly in Word) and set it to
run in Access when a particular field was filled in....or so I thought.
I can no longer open the form.
Is there a way to stop all macros/modules from operating in a form so I can
open it.
This is the first time I have attemp ...
|
Send Object Macro
Fri, 5 Sep 2008 13:26:53 -0700
Hi,
I wrote a VB code to send emails, the button is working fine in the computer
I made it but it doesn't work for no one else. What am I doing wrong? ...
|
Macro to create new column, rename it, and change data type.
Fri, 05 Sep 2008 18:32:46 GMT
Hi - I've been trying to figure out how to do the following - create a macro
(or code) so users can enter a new column in a table, rename it, and change
the data type. It's a birdwatching DB, and this function is to allow the
user to create a new bespoke tick list in a table of lists (life list, county
list etc ...
|
excel 2007, VB find a word withn words save in another column/shee
Fri, 5 Sep 2008 11:05:04 -0700
the word can be embeded within other words and I would like to have the whole
word save into another column preferably a new sheet.
Example: AA
AAH, BAAL, CRAAL, BAASKAAP
Can you email me back? thank you ...
|
Hided query become unhide after run the macro
Thu, 4 Sep 2008 19:39:01 -0700
Hi,
i have a list of query and i've hided some of them for certain reason.
When everytime i re-run the macro, some of the query will unhide again.
Could anyone tell me what happen is it ???
Thanks in Advance.
LT ...
|
How do i edit macros in Access
Thu, 4 Sep 2008 12:26:01 -0700
I am used to the Office 2003 format. I have upgraded to Vista and Office
2007. I am working in 2007 with a database created in 2003. Suddenly I cannot
find a way to enter a macro and change its paramters. Please advise ...
|
|
|
Exporting a report to excel through a macro
Wed, 3 Sep 2008 12:52:01 -0700
Is there a way to export a report made in access to excel through a macro. ...
|
Moving info from one sheet to another
Wed, 3 Sep 2008 09:39:01 -0700
I need to move info from spreadsheet to another seperate sheet - I would like
to know if you can can just make a check mark in a specific cell and when you
hit enter the line item moves to another sheet - Say like on a accounts
receivable ageing report when an invoice is paid you can check it and it will
aut ...
|
How can I write a test to see if a database is Read-Only?
Wed, 3 Sep 2008 03:32:52 -0700 (PDT)
Hi All
I have a simple Access database that sometimes will be used by
external users off a DVD. In this case (of course) the database is
Read-Only.
How can I write a test to see if the database is Read-Only? and
therefore on a DVD?
If I can find a test then I can collect statistics when the database
is ...
|
