|
Determine if a table has changed/updated
Hello all,
I need to be determine programatically in a macro or a module if a
table has changed, I.E a new record has been added. When that
happens, an email needs to be sent. I found code on the internet to
send the email but I can't seem ti find anything on how to determine
if a new record has been added.
Any help or direction would be greatly appreciated.
Regards
Dale Jon...
|
4 |
2/24/2007 8:11:36 PM |
|
|
Macros on Keyboards
It is nice how one can use the keyboard to run macros. ...
|
1 |
2/24/2007 12:46:17 PM |
|
|
Data dump Access to Excel
If I have a large amount of data (~300000 items) in access that I
would like to dump from Access into Excel. Is it possible to create
a
macro that will copy/paste the first 65536 items from access to
excel,
then run it in another excel sheet to copy/paste the next 65535 items
from access to excel, and so on?
Thanks for any ideas!
...
|
3 |
2/23/2007 11:48:10 PM |
|
|
State and Country filter
Hi. I have a macro that I'm using in a "rolodex" form- a form that you can
select a button for each state and the form will display all of the member's
that live in that state. All is well.
However, we have members that live outside of the US and I wanted a button
for "foreign", to show all members outside of the US.
So, I'm tyring to incorporate a macro that works for state and now co...
|
3 |
2/23/2007 7:19:00 PM |
|
|
run macro on all records automatically
can any1 help me on how to set a macro to run on all records just like a in
refresh command...
|
2 |
2/22/2007 10:42:19 PM |
|
|
Update Table Data
I have a macro in one database that updates a table in another database. Is
there a way to have the macro automatically run every 30 minutes or so? Any
help is greatly appreciated. Thanks....
|
2 |
2/22/2007 2:09:02 PM |
|
|
Can you just open an e-mail box from a Form?
I got my macro to work as far as sending an e-mail but does the e-mail have
to be sent automatically when you push the command button? Is there any way
to just open an e-mail message with the address in the To: field and write a
new message each time? Please Help!!!!!!...
|
3 |
2/22/2007 1:59:13 PM |
|
|
Odd behavior
Hi...
Not sure if this question belongs in an Excel group, or here. Since the code
is all executed from Access, I'll try here first.
In a nutshell, Access 2000 module exports form data in xls format using
OutputTo, then creates Excel object, opens created xls file, formats data
and graphs it.
Last code line executed sets excel object equal to nothing. The form is left
open to be sav...
|
1 |
2/22/2007 12:28:41 AM |
|
|
Neste IIf Statement in Expression builder
Hello,
I am using a nested IIF in Expression builder. The purpose of the expression
was to take the value in WKS and if it matched it would return a field from a
table called Forecast. It started to work but it eventually gave me an error
because my expressin was too complex. i wanted to put 52 conditions and it
errored before I got 20. Here is what I have so far
Expr2: IIf([WKS]=1...
|
2 |
2/21/2007 10:07:34 PM |
|
|
Issue Macro
I am using
http://office.microsoft.com/en-us/templates/TC012186931033.aspx?pid=CT101426031033
and am having a issue with the macro. When you go to Form-Issues I took the
opened by off and when I try to create the issue I get error"Issues form
marcos.createnewissue: On Click".
Does anyone know how I can fix this macro everything I have tried does not
work. Please help
Thanks Chad
...
|
1 |
2/21/2007 7:36:11 PM |
|
|
Add field from the report to the subject line in e-mail (Send obje
I have successfully created a send object macro but I would like to add the
store field in the subject line which will automatically update....
|
1 |
2/21/2007 5:23:33 PM |
|
|
what macro action has replace the setvalue macro in Access 2007
what macro action has replace the setvalue macro in Access 2007...
|
3 |
2/21/2007 5:00:50 PM |
|
|
Send an e-mail from the e-mail address in a Form
I have a Form for "Contacts" Within that Form there is a field for e-mail
address. I want to send an e-mail using that address from the form by
creating a macro. I used the SendObject Action my question is how do I enter
it into the To: field of the argument? The Form reads in Design View " Email
Address EmailName" whichis entered into the To argument? ...
|
2 |
2/21/2007 4:18:20 PM |
|
|
Action Failed
Hello, I built a database at home for work in access 2002 and it worked great
on my PC. When I took it to work it worked fine on my PC but some other PC's
got an error on open. The error box said:
Action Failed
Macro Name: mcr_NewRecord
Condition: True
Action name: GoToRecord
Arguments: -1,,New,
What this macro does is open a Form to the next record that is a Login Form.
I have t...
|
3 |
2/21/2007 2:35:44 PM |
|
|
Macro to produce a report from a query
I have an intermediate knowledge of Access97 and wondered if someone would
help me with a macro.
I have a database that keeps track of the contents of a hundred of my home
video tapes. It has fields like "Tape #", "People", "Event", "Time counter",
"Date", "Setting", etc.
I created both a query and a report that produces the contents of the tape #
I manually enter into the query. It ...
|
4 |
2/21/2007 2:19:24 PM |
|
|
Hiding error dialog box in Access
How can I hide the Action failed box that appears when a user enters a
duplicate record. I have a message box set to appear on error and I tried to
use the Stop Macro action as well as the SetWarnings action but it still
seems to show up.
I want the user to see the custom message box I created but have it cancel
the new record on error. Appreciate any help....
|
8 |
2/21/2007 6:19:37 AM |
|
|
replace function show stopper
Hi everyone,
I am having a very strange problem with the replace() function. I am
trying to run the following select statement from within a vba module
and am getting a 'data type mismatch error in criteria expression'
SELECT ThreeGProcessChangeRequest.[Issue ID],
ThreeGProcessChangeRequest.[Title] " & _
"FROM ThreeGProcessChangeRequest WHERE ThreeGProcessChangeRequest.
[Status]<...
|
2 |
2/19/2007 9:48:44 PM |
|
|
Data dump
If I have a large amount of data (~300000 items) in access that I
would like to dump from Access into Excel. Is it possible to create a
macro that will copy/paste the first 65536 items from access to excel,
then run it in another excel sheet to copy/paste the next 65535 items
from access to excel, and so on?
Thanks for any ideas!
...
|
3 |
2/19/2007 8:04:12 PM |
|
|
Troubleshooting Spreadsheet
I have a table that I am doing a query on and then sending information from
it through outlook as a excel spreadsheet. There are a few columns that are
listed in design view as text but are mostly numbers and there is one that is
a price that is listed as a number with the format standard. When I send a
test to myself and I open the spreadsheet, there is a message that pops up
first th...
|
1 |
2/19/2007 5:31:16 PM |
|
|
Setting a value cause record selection to change
I'm using an OnExit in the last field in a subform to run a macro to update
fields in the main form, based on entries in the current record in the
subform. There's a series of Setvalue that work, but before executing a
specific one, it jumps to the first record in the subform (continuous list)
and executes the setvalue from the field in that record.
I've moved the setvalue statement ar...
|
2 |
2/19/2007 11:48:09 AM |
|
|
automatically update date
I need to automatically update field from a set date (hire date) to a date
that will be the 1st day of the month, three months in advance : example
Hire date - 1/14/2007 new date - 4/1/2007. Any suggestions? Thanks!
--
Cari...
|
4 |
2/18/2007 9:44:01 PM |
|
|
Sequential numbering macro not working
I have a form called AddTransaction based on a table called tbl_Transaction.
The table has three fields TransactionID(PK/autonumber), TransactionNo(#),
ProjectID(#), among others. I want the TransactionNo field to record new
transactions, starting from number 1, based on the ProjectID. So when I add a
transaction it assigns the next sequential number, for it’s ProjectID. If a
new ProjectID ...
|
5 |
2/18/2007 5:55:34 PM |
|
|
macros
My objective is to use a command button in ms-access 2000 to run a macro in
Exel 2000 then import the worksheet into ms-access. I have this working fine
but it takes 2 operations. ie. open exel run macro to transpose data to suite
ms-access, then open ms-access and import using a command button
(transferspreadsheet)
I would appreciate your input
Thanks in Advance...
|
5 |
2/17/2007 7:22:00 AM |
|
|
Conditioning a checkbox
I have a checkbox column in my table which I would like to be checked off
automatically when a particular 'date' field in the same table / form is no
longer blank. Can this be done?...
|
5 |
2/16/2007 7:41:00 PM |
|
|
Need to refresh the table
This is really silly. I used to know how to do this! And, perhaps a macro
is not the best place to accomplish this, but actual code.
I have a macro behind a button on a form that simply takes the current
record, appends that record to a 2nd table (macro runs an append query), then
deletes the current record from the table that is the source for the form
(macro runs a delete query).
...
|
2 |
2/16/2007 7:04:49 PM |