|
Send Object Macro
I have a database that had a macro established to automatically attached a
report to an email in snapshot view with the email addresses already filled
in the To: and CC: fields. I used the SendObject function to do this.
We recently migrated from Lotus Notes email to Microsoft Outlook and the
macro does not work now.
I am guessing that it is still possible since Outlook is a Microsoft...
|
5 |
6/4/2007 4:21:01 PM |
|
|
Copy & Paste Macro
Hi All,
I know to most this is probably a really simple task! Here goes anyway.
I have a personal information form that contains fields to complete for a
residential address, (Address 1, Address 2, Suburb, State, Post Code) and I
also have a postal address section containing Postal Address 1, Postal
Address 2, Postal Suburb, Postal State, Postal Post Code and a tick box for
Same as R...
|
11 |
6/4/2007 8:11:03 AM |
|
|
Run Queries with Macro 2
I have a form with several reports set to run by a single macro. The form
[View Grievance Reports] and macro [View Grievance Reports Macros]. The form
[View Grievance Reports] is unbounded. It has an unbounded list box that uses
a table [Grievance Reports Table] as the row source type. The Report based
macro works perfectly. I’m now trying to adapt this form and macro to open a
specifi...
|
1 |
6/4/2007 12:19:02 AM |
|
|
change some fields in an access table
I'd like to change some fields in an access table from number to text or,
alternatively, create new fields, transfer data to them and delete the prior
fields.
All these in Visual Basic for Access.
Where can I find some examples?
Thanks
Antonio Paiva
...
|
2 |
6/3/2007 11:19:20 AM |
|
|
Import Web Data
I use Excel to link to data from a web site (using the 'Import External
Data>New Web Query), each time I open the Excel file the data is refreshed
and I see the latest update without having to go and get it manually. I want
to do the same in Access but haven't seen a way of doing it yet.
Is it possible, if so, How ?
Thanks
Keith
...
|
2 |
6/2/2007 11:50:17 PM |
|
|
Macros, Tabs and other files
Hi. I created a Macro to take a excell file (lets same its named Doggy),
sort and break up per my specs and place results on 7 different tabs. Works
good. However everytime I get a new file to convert through this Macro I
have to rename the file to Doggy before the macroo will work because that is
the name on the tab when I origionally created the macro. Here is the line
that is caus...
|
2 |
6/1/2007 7:56:27 PM |
|
|
Spell Check Macro
Hi,
I have a macro that runs the spell Check command after the update of a text
field. This field is on a page of a tab control. When the field is updated,
the spell check is running though all fields of the form and other records,
not just the text field or the current record. Not sure what I have done
wrong....
|
1 |
6/1/2007 4:29:01 PM |
|
|
Exporting to excel.xls
Hello,
I want to export from a button on a form the filtered database to an Excel
sheet. Im trying to use the DataTransfer set Macro - but I cannot seem to
make it work. I want to pretty much replicate the "Export" funtion on the
File - Export function.
Cheers,
RickJ...
|
3 |
6/1/2007 3:35:28 PM |
|
|
Digital Signature Issue
I got tired of having to click an enable macros everytime I opened a databse
where I placed code on a form. As the Owner of the databse, I assigned
myself a "Digital Signature" and applied it to the database.
Unfortunately, the next day when I went to open the database, I got an error
message saying something to the effect of " The code or macros in this file
do not match the digital s...
|
1 |
6/1/2007 2:27:00 PM |
|
|
Running an Access 2003 macro from VB Script
I'm trying to schedule a VB script to run via task manager. The script
should kick off an access macro and then close down when done. However I am
getting the two following error messages when I try to run the script:
-------------------------
(i) You can't exit Microsoft Office Access now.
If you're running a Visual Basic module that is using OLE or DDE, you may
need to interupt the mo...
|
4 |
6/1/2007 7:39:29 AM |
|
|
Outlook.Application works with outlook 2003
Attempting to send file created and saved from access 2003
it errors out at
Dim objOutlook As Outlook.Application
'Arvin Meyer 03/12/1999
'Updated 7/21/2001
On Error GoTo Error_Handler
Dim objOutlook As Outlook.Application
Dim objEmail As Outlook.MailItem
Set objOutlook = CreateObject("Outlook.application")
Set objEmail = objOutlook.CreateItem(olMailItem)
With objEmail
.To...
|
2 |
6/1/2007 4:55:45 AM |
|
|
Command buttons with macros
Hi,
Can I create a macro with a command button to duplicate a record but remove
one or more fields in the process. can not duplicate a record because it
would create of a primary field dulpication. I want to be able to click the
button, remove the primary key field than duplicate the record with the
primary field emply, I'll re-enter the field with a new number before saving.
Current...
|
3 |
5/31/2007 9:56:21 PM |
|
|
Macro Error
I am working with delete macro in a subform. It works well in deleteing the
information but if I decide not to follow through and hit cancel a window
show us stating action failed and in order to close window I have to hit the
halt button. What must i change in the macro for it to close with out taking
any action and not showing the halt window.
Private Sub Qtdel_Click()
On Error GoTo ...
|
2 |
5/31/2007 9:50:48 PM |
|
|
Email Spreadsheet from Access with multiple tabs
Hello.
I've been using sendobject to send excel reports out automatically. Some of
these reports can be consolodated into one report on multiple tabs. I used
transferspreadsheet to get the queries to post onto seperate tabs on a
spreadsheet but now cannot figure out how to get Access to get the
spreadsheet and email it out. Has anyone done this? Thanks in advance.
...
|
2 |
5/31/2007 7:03:02 PM |
|
|
Macro to create export delimited file and print total report.
I'm new at designing access databases. I created a command button to execute
a macro to create an export file and print a report. The first time I
clicked the button, the report printed but I couldn't find the export file.
Now when I click the button, it gives me the following message: Can't
update. Database or object is read-only. I haven't set anything to be
read-only at this poi...
|
5 |
5/31/2007 6:04:00 PM |
|
|
È«²¿²úÆ·¿÷±¾´¦Àí£ºµõ´øÉÀ3Ôª£»ÐÝÏпã/TÐô/¶à¿îÍâÌ×5Ôª£»ÃÞ°À8Ôª£»ÑòÈÞÍâÌ×10Ôª£»Íâóѥ8Ôª¡¡
È«²¿²úÆ·¿÷±¾´¦Àí£ºµõ´øÉÀ3Ôª£»ÐÝÏпã/TÐô/¶à¿îÍâÌ×5Ôª£»ÃÞ°À8Ôª£»ÑòÈÞÍâÌ×10Ôª£»Íâóѥ8Ôª¡¡
ÒôÀÖºÐ4.8Ôª£»ÒôÏ첨1.8Ôª£»²»µ¹ÎÌ3.8Ôª£»ÔÓÎïͲ5.8Ôª¡¡
¸ü¶àÐÅÏ¢Çë¼ûÍøÕ¾:www.jl-sm.com
...
|
1 |
5/31/2007 3:28:28 AM |
|
|
Do Macros Run Sequentially?
This is the silly question for the day! But, do Macros in Access (2003 if it
makes a difference) run sequentially? By that I mean if I have a Macro that
runs a number of select Queries, does the Macros wait for one to inish before
starting another?
I am using a Quad Core processor. Some of the Query results are leading me
to belive that possibly the Macro can run more than one Quer...
|
1 |
5/31/2007 1:57:01 AM |
|
|
Copy Data From an ACCESS form to a WORD Template
I have a Front-End ACCESS db (linked to (3) Tables on a Back-End SQL
Server). I have a series of Queries that manipulate the data and populate
an ACCESS Form. This Form has the following features:
1. A Main Form, with several pages (Tabs) which display data from one
(OverallData) Table
a. One of these pages (Tabs) contains a Sub-Form which displays data
from another (SpecificDat...
|
14 |
5/30/2007 6:58:12 PM |
|
|
Copy a record via a macro
Hello there,
Please be gentle as I am new to all this!
I have written a macro in Access 2007 that finds a record in a query (AVG of a number of figures) and I need to be able to somehow COPY this figure and then paste it into a record in a table. I have built all the elements of the macro and am just missing the COPY and PASTE elements.
To a novice such as myself it is causing headaches ...
|
3 |
5/30/2007 3:23:05 PM |
|
|
Append Query Macros
I am trying to creat an append query from a table [Prospective Gains] to
table [DIVO Form] I have set up an append query from the Gains table to the
Divo table with a delete query and set the close procedure to the following:
Private Sub Form_Close()
DoCmd.RunMacro "gains"
End Sub
The end result should be that when I click on the checkbox the appropriate
data should add to the DI...
|
3 |
5/29/2007 9:51:03 PM |
|
|
Check Boxes
I'm trying to send an report automatically through a macro and there's a
message box that says "this program is trying to automatically send an
e-mail. . . Do you wish to send . . . " and there's a yes or no option. Does
anyone know the program to download so that I have a check box option that I
can set to always say yes?...
|
2 |
5/29/2007 9:34:59 PM |
|
|
Merging two switchboards
Hello Everyone,
I'm needing alittle help on my project. I am creating a retail shop
database with ACCESS where I have 12 tables, 11 forms, 14 queries and
6 Reports. Currently, I am having a problem with putting more than 8
items on the switchboard manager and pages becuase the max it is
giving me is just 8 slots including the exit application item.
Therefore, I have now created them on two...
|
4 |
5/29/2007 3:13:02 PM |
|
|
Need Help
Hello there,
Please be gentle as I am new to all this!
I have a little experience with Excel VBA, but this is my first time with
Access 2003.
I have this code written within a form to perform a series of tasks just
before closing the form
When I run it, it works for the table (Inventory Transactions) but does not
copy the data into a new record in the second table (Order Details)
I...
|
1 |
5/29/2007 9:28:10 AM |
|
|
Serial number of hardware in Excel Basic
Please. I ask for an adwice. I need the macro in Excel Visual Basic, which
will find me serial number of hardware ( any ) in computer.
Thank you very mutch.
Prosim o radu. Potrebujem macro v Basicu pre Excel v ktore
mi zisti seriove cislo hardwaru ktore je v pocitaci.
Dakujem velmi pekne.
...
|
1 |
5/29/2007 6:56:01 AM |
|
|
Order Processing App
Hello,
I am just learning to develop apps with Access. I have a bit of experience
developing Excel apps, using VBA.
I need to design a Produce purchasing and distribution application. It will
need to handle incoming and outgoing product, invoice tracking, pricing,
etc.
I'm sure there's a million ways to do it, but my main question at this point
is how to set up the app to handle...
|
3 |
5/29/2007 2:51:54 AM |