|
I need to automatically send an email for turnaorund time breach
I can create a macro that will send an email to a usergroup but I have to
manually activate it. I really need to get the macro to automatically email
the usergroup once a turnaround time is due to breach i.e. 5 days. Any help
would be appreciated....
|
1 |
01.09.2006 15:03:02 |
|
|
Way To Surpress Warnings?
Is there a way when running a macro (or just a query) where you can stop all
the stupid warnings.
I link via ODBC to our oracle database at work.
I use queries to pull a small subset of data down to my local machine using
a make table query.
All those stupid warning are just a pain and totally unnecessary. Warnings
about going to make a table, delete a table...blah...blah..blah.
Yes I wo...
|
2 |
01.09.2006 03:23:48 |
|
|
Macro conditions stop macro
I am trying to prevent my append query from executing if the number of
records returned by a query (which is the first macro step) returns more than
one record.
DCount("[Tno]","TrucknoQuery")>1
This works if the criteria for the TrucknoQuery is typed in the query
design. If I promt the user to enter criteria when the query runs, the macro
just stops regardless if the condition is true...
|
2 |
31.08.2006 18:58:16 |
|
|
Run macro based on empty field in form
Hi,
I have a form where I require a prompt to appear if the chosen foeld is
empty upon lost focus. I have created a macro to run a simple message box but
I do not want it to run if the field is not empty.
I would appreciate your comments.
Thanks
...
|
2 |
31.08.2006 18:52:40 |
|
|
Message for Steve Schapel
Hi Steve,
Your help was much appreciated, but your solution lead to a new
question.
I can add new projects to my clients. I can also add new contact
persons to clients. But sometimes, the details of a contact
person change. Is it possible to select a record in the subform
and then program a button that opens an edit contact form where
the selected contactperson is already selected...
|
2 |
31.08.2006 18:48:38 |
|
|
Archive same table with date/time stamp as file name
I upload a .txt table from a scanner that is always has the same name. I
bring it into my datebase and process it. I would like save that upload table
before processing as a archive table using time stamp (system date and time).
Can this be done with a macro and how?
I am a accountant and do not know visual basic. ...
|
1 |
31.08.2006 14:03:02 |
|
|
How do I run a macro based on changes in records?
I'm a novice when it comes to using Access and have designed an inventory
database, but have run across an issue I can't figure. I have several queries
based on the same 2 tables that all track different records based on the
"Customer Job". I have written different macros to output each as an excel
sheet. What I need to figure out is how to run the macros automatically based
on changes i...
|
1 |
30.08.2006 21:17:02 |
|
|
pop -up
I am doing a Printer inventory and have two columns, type of cartridge and
the quantity. What I would like to do is when the quantity of each cartridge
goes below 3 when exiting, every time, a pop up warning “Inc is low for
cartridge X. Order more “shows up. So far I have it giving a pop up that
tells when the quantity is low, but want I really want it to do is tell the
type of cartr...
|
2 |
30.08.2006 21:14:32 |
|
|
How to Change Default Printer Using Macro Statement
Does anyone know if and how I can change my printer using an Access Macro
statement? Not using a Macro, I presently have to manually do this each time
I generate a report and then select the printer I want when I Print the
report. I'm actually outputting to a PDF file and I have full Acrobat on my
computer. So I am able to manually do this. However, I'd like to automate
this process ...
|
2 |
30.08.2006 21:02:18 |
|
|
delete record and save it to another table
I am trying to create a macro for a command button on my form. I think a
macro is the best way to go. I want to be able to find any record in my form
and delete it. But at the same time, I want to save it to a "deleted records"
table. Please help me put this together....
|
5 |
29.08.2006 23:03:51 |
|
|
REQ Help: Adding record to a table that is related to a selected record
Hi,
I have a table that contains the address data of my clients. I
have another table that contains project data. It is related to
my clients table. 1 client can have multiple projects.
Now I made a form that shows 1 client at the time and I can
search for clients, add new clients, delete clients (who wants
to do that though) and so on. The form also show a sub-form for
all the pr...
|
2 |
29.08.2006 18:57:48 |
|
|
How do I combine two SendObjects to send out in one email?
I am trying to combine two SendObjects in a Macro to email out only one
output rather than two outputs (One file is an excel file the other is a
report file)....
|
3 |
29.08.2006 09:15:01 |
|
|
ms access
how do you append info from one table to another upon recognition of a
certain word...
|
2 |
28.08.2006 06:16:11 |
|
|
Any ideas why Macro will not run...
I inhereted a user database with a form and a button. Click the button and a
variety of queries run, tables are made etc etc. The end result is to be an
Excel file that opens where the user refreshes a pivot linked to the Access
data base.
The process works fine when I run it. Essentially a bunch of vba code is run
to open queries and such. The last vba statement though calls a macro:
...
|
5 |
27.08.2006 20:18:55 |
|
|
if / then
Hi - hope someone can help me.
I have a form with 4 combo boxes. Each combo box stores a piece of info
into the table. But I need to be able to restrict what the users are
selecting. For example if the field Service is selected, then I need the
field NonService to be null. Also if my field Service is selected, I need
field Product and field ConcernDetail to NOT be null. Then likewise...
|
2 |
26.08.2006 17:45:02 |
|
|
disable bypass key
how can disable the bypass key by writing a macro ?
...
|
2 |
26.08.2006 07:27:07 |
|
|
How do I create a macro to boldface text in Access?
Help only seems to describe how to name and save macros, but not
specifically how and where to describe the act of boldfacing....
|
7 |
26.08.2006 07:16:25 |
|
|
TransferText Method
I've used the TransferText method many times before, and have at times run
into a length limitation for the "FileName" parameter. What I'm finding is
that the length is limited to 153 (Magical isn't it?), including the server
name, path, file name, and file extention. For example:
"\\servername\path\filename.ext"
Does anyone know of a limitation on this parameter? I haven't seen any...
|
2 |
25.08.2006 20:20:28 |
|
|
efficiency charts for machining
I need help designing a database to track efficiency then be able to run a
macro report.
Thanks...
|
1 |
25.08.2006 15:54:02 |
|
|
Output to Excel - EM: Microsoft Office Access Can't Start OLE Ser
I have a macro that contains the Output To command. The command is supposed
to start the Excel application after the Output To action runs. The
parameters for this command include:
1. Object Type - Query
2. Object Name - < query name >
3. Object Format -Microsoft Excel 97-2003 (*.xls)
4. Object File - C:\Report
5. Autostart - Yes
When I ran this macro, I received an error ...
|
3 |
25.08.2006 15:28:02 |
|
|
Copy record to new record
Using Acess 2003. I have a database to create tranmittals. Very often we
send the same things, or similar to the same person. I want to create a new
record based on an exsiting record number (using an entry "form") and then be
able to edit the new record. Any help would be appreciated.
...
|
3 |
25.08.2006 14:04:03 |
|
|
Access macro to export to excel
I have a query with a field that has 118 different values. I need to
filter by each of the 118 different values and export the results into
separate excel workbooks.
I would love a macro that does this...but I only have written macros
for excel.
Any ideas?
Thanks!
-Kim
...
|
4 |
25.08.2006 07:55:02 |
|
|
Macro problem locating last line
(Sorry to cross post, didn't see the macro group until now)
I am using the following macro (it is one of three that are all the
same but point to different Month Sheets) to do two jobs at once, and
the second part is acting oddly when copying from the Suggestions sheet
and moving it into the Suggested Changes sheet. The first part copies
to its month sheet just fine, but I want the suggest...
|
1 |
25.08.2006 04:20:45 |
|
|
del comma in excel output, in a split cell, access macro
I have a cell of product numbers some delimited by carriage returns but it
also has stray commas. I need to get rid of where in the access macro it is
putting the comma in the product number cells. I want the program/product
numbers to be delimited by just a carriage return. Here is a snippet of the
output commands.
The rsData is the dataset it is sorted by division name . The sPr...
|
6 |
24.08.2006 23:26:01 |
|
|
Using a batch file with a security warning
I have a batch file which runs a macro.
Due to security issies, the macro can not be run until I confirm a security
notice on opening the access file: "Secutiry Warning: This file may not be
safe if it contains code that was intended to harm your computer. Do you want
to open this file or cancel the operation?" Cancel, Open and More Info
buttons in the messagebox.
How can I avaiod this...
|
2 |
24.08.2006 21:30:33 |