|
Quit command doesn't work in Access2007
I'm unable to run the Quit command from a macro in Access2007. I also
tried DoCmd.Quit and Application.Quit in VBA and those don't work
either. It's not a trusted site issue...I'm successfully executing
other commands that require the DB to reside in a trusted site. I need
to automate the macro, so it's essential I be able to quit. Help!!!...
|
1 |
5/26/2007 5:20:25 AM |
|
|
Email Address fro Macro
I have a macro which opens up an Email. BUT I have to input the eMail address
before sending the email. Is there any way I can 'grabe' the email address
from the database itself?. All users in the DB have their email address
(Access 97)
Tnahs...
|
7 |
5/26/2007 3:57:20 AM |
|
|
enter command
I have a macro designed with macro wizard that ends up printing to a pdf. A
window open that requires me to respond with save (enter key will work too).
I can't find the right way to get past this point....
|
1 |
5/25/2007 9:26:01 PM |
|
|
Macro to print reports
Hello everyone
I have like 30 reports to print every month. I will build a macro for it.
Quite simple i guess. Most of those reports have a query. Most of them, query
and reports have a filter and a criteria, but the real question is : I'd like
to "ask" from wich date to wich date to them all and of course that input
data appears on each report. I think i have to add a filter on my report...
|
6 |
5/25/2007 3:45:01 PM |
|
|
View record values in recordset during debug
Is there a way (what is best way) to view the field values of each record as
you process through a recordset while in debug mode? The results I am
expecting are not happening, and before I post up my code for help, I will
try to debug myself. I need to see which record I am processing and the
values being compared between 2 tables (recordsets).
Thanks in advance
Kenny A....
|
3 |
5/25/2007 3:30:03 PM |
|
|
Making a filter on a form from a Combo Box on a Crosstab query
I have managed to do this on a form based on a normal query or table but not
on a Cross tab.
The way I did it was using an After Update linked to an Apply Filter Macro
on a combobox to select the criteria.
On the Macro Conditions I use the argument eg ([Forms]![SKU/Sales]![Select])
Is Not Null.
On the "Where Condition" I put [Main]![SKU
type]=[Forms]![SKU/Sales]![Select]
As men...
|
1 |
5/25/2007 10:58:00 AM |
|
|
How to access global variable EXPLICITLY
Hi,
i have declared one global varibale named VAR1 in form module and
another defined in sub proecdure with the same name (VAR1) in the same
form module . if i use VAR1 then local variable will be
accessed .......but if i wanna use the global variable explicitely in
the same procedure then how can i do that.
Vikram
...
|
4 |
5/25/2007 10:45:27 AM |
|
|
To Outlook Calendar from Access
I would like to create a button on a from which when clicked goes directly to
the Outlook calendar. Is there a way to do this?
Kind Regards,
Ruud...
|
1 |
5/25/2007 9:49:00 AM |
|
|
Create a Macro to check ID
i wish to create a macro to check the integrity of database, like that
if max(TableA.ID) <> max(TableB.ID) then
msgbox("ID not matched")
How can i make it in macro look?
Thanks a lot.
Tony
...
|
3 |
5/24/2007 2:02:19 PM |
|
|
Import CSV question
Hi. I am fairly new to macros and visual basic. I hope someone can
steer me in the right direction.
Every week a new .csv file needs to be imported into one table of
information. (One table contains weeks of data) The .csv files are all
in the same file location.
Are any or both of these options available:
1.) A command button that when pressed will bring up an open dialog
box, starti...
|
6 |
5/24/2007 12:55:33 AM |
|
|
DBEngine in Form's macro
I have several sub functions in my form's macro page, some of the sub
function has the following codes:
Dim myDB As Database
myDB = DBEngine.Workspaces(0).Databases(0)
Can I have these codes in more than one sub function?
...
|
3 |
5/24/2007 12:55:19 AM |
|
|
Using a macro to perform two tasks
Please can anyone help me with the following problem:-
I have created a Transactions form, where users can enter data when they
sell a shoe.
At the bottom of this form, I have two buttons, one to add the record to the
transactions table and one to run an update query, which updates the quantity
of stock in the stock table.
I have tried combining these two actions in a macro, but when I ...
|
4 |
5/23/2007 9:10:01 PM |
|
|
Automatically enter E-mail address in To: diesl of SendObject Mac
I would like the SendObject Macro to automatically enter the value of a field
in a form that call the SendObject Macro into the To: field of the macro.
The data for the To: field will be pulled from the Forms]![Work
RequisitionsBackup]![Therapist] field of the open form (which has a button
that activates the SendObject macro). I have tried and failed with these;
"'" &Forms]![Work Requisi...
|
3 |
5/23/2007 8:14:01 PM |
|
|
Calling a Sub from a Macro
In Access 2003, is it possible to call a Sub from a macro? I know you can
call a Function, but I am not passing any information. In my macro, I run 4
queries. Query 1 clears a table that will receive the final data.Qquery 2
updates a date field for all records in a second table. Query 3 inserts all
records from table 2 into final table. Query 4 selects records from a 3rd
table meeting a ...
|
3 |
5/23/2007 7:46:02 PM |
|
|
Macro has been disabled because of your security setting...
Hello,
I wrote a macro in Word 2000 template and add it to the menu bar for users.
It works fine if I set the security setting to "Low". But I don't want to
set the Security to "Low", then I got message "Macro cannot be found or Macro
has been disabled because of your security setting" when run the macro. Is
there a way to get rid of this message or enable the macro in code? Please
help...
|
1 |
5/23/2007 1:32:01 PM |
|
|
checking for file in CONDITION
I used to use the following as a condition in a macro -- if the filename
wasn't found, the macro ended. Is this method of looking for a file no
longer supported? I pulled up this old code to use in a new situation, and
the program keeps giving me an error:
Condition:
Dir("c:\sd_data\sdc" & Format$(Date(),"yyyymmdd") & ".txt")=""
Error:
The expression you entered has a functio...
|
1 |
5/23/2007 1:11:19 AM |
|
|
Can I create a macro to record who last made changes to a table?
Can I create a macro to record who last made changes to a table?
Or maybe at least just to a database?...
|
2 |
5/22/2007 11:30:01 PM |
|
|
Send Password
Is there anyway I can send a password for an ODBC connection (SQL) database.
I have information I am taking from a SQL program and want to share with
others. I don't want to give out the password but want the Access
information to update when the database is opened. I need to send the
password, can I automate with a macro? Thanks...
|
1 |
5/22/2007 4:49:01 PM |
|
|
AutoExec then Quit gives errors in command line
here's what i have set up:
..bat file - copies a database to a second file
..bat file - opens the copy "db2"
db2 - autoexec macro
macro - runs query
macro - exports data to csv file
macro - exits access program
this all works well if I run the access file from windows, but when I open
the mdb file from a command line, it will run the macro and everything fine,
BUT it gives an error "c...
|
2 |
5/22/2007 10:40:00 AM |
|
|
Macro to open a form with specific record
I have always (with Access 2000) used the wizard to go from a button in a
list of records to a form with the selected record - it generates VBA. All
fine.
Now I have 2007 and it creates a macro. It opens the form but does not go to
the record. The main settings are:
Form Name: frmPage
View: Form
Where Condition: "[PageId]=" & [PageId]
I have macros enabled everywhere, a trusted cert...
|
4 |
5/21/2007 4:39:58 PM |
|
|
DAP's, Macros, and Automatic E-mails
I have a DAP which I'm using at work to track IT Issues that users on a LAN
are having. I'm using Access 2000 and what I would ideally like is help with
the following:
When someone goes onto the DAP, I want to make a Save button on the page
which Saves the current record, triggering Access to send an e-mail to me to
let me know the database has been updated with a Report as an attachmen...
|
3 |
5/19/2007 6:22:00 PM |
|
|
I need some macro help
I have 2 tables
1 has all customer data
1 has ranking system I created that rates them 1-5
I import new customers everyday and cant keep up with typing in the rating
I need to create a macro that will take the rankings and put them into the
customer data field...
|
12 |
5/19/2007 1:17:28 AM |
|
|
How OutPut to a dxf format?
I need to output data on a table to a dxf format.
Is there a plugin or third pary program or active control that can help me
do that?
Thanks for your help.
--
IT1957...
|
1 |
5/18/2007 10:14:02 PM |
|
|
Automate log-in/passwords with ODBC connections
I have my database linked to some tables ODBC, I have queries that run off of
these tables that puts only the information I need into some other
(non-linked tables). I want to have this get updated automatically, my on
issue is the linked tables have to have a log in and password, is there any
way I can automate this part?...
|
2 |
5/18/2007 10:11:00 PM |
|
|
Question concerning macros
Hi. I'm new to all this, but I have a question that hopefully someone can
help me with. I e-mailed a data analysis page to my home computer, along
with the spreadsheet containing the macros to upload the data onto. My
question in...since my version of excel is 2007, and the version I e-mailed
to myself is 97, why can't I get the macros commands to work and upload the
data onto the spr...
|
3 |
5/18/2007 10:03:01 PM |