|
Access and Outlook Help
hi I would like to know how to achive two things.....
I have a client/sales based database i would like to:-
a. Email the client from access to outlook with the To field
automatically filling in from the email address field on the database
form.
b. Automatically set up a task on outlook from a check box in access.
I know it is possible to do both but don't know how???
Claire
--...
|
2 |
24.01.2006 07:18:58 |
|
|
Dim dbs As Database - type unrecognised
I want to declare dbs as Database but get runtime error 13, type mismatch.
What am I doing wrong?
I can see that 'Database' is a type used in the help files. I remember
using it myself many times a few years ago but it is now not recognised.
I have MS Access 2000 and am a bit rusty having not used it properly for a
few years. I am writing the code in a Sub() in a module.
The proj...
|
3 |
22.01.2006 23:30:13 |
|
|
You gotit
Hi
...
|
1 |
22.01.2006 23:29:12 |
|
|
Execute MSSQL-batchjob through ADO
I wish to save a DTS-package that imports a text file to a table. This
saved DTS-package should be executed through ADO. Is this possible -
and if yes: how?
Thanks in advance for your effort and input. :-)
Regards /Snedker
x-post:
microsoft.public.access.modulesdaovba.ado,microsoft.public.access.modulesdaovba
fut: microsoft.public.access.modulesdaovba.ado...
|
4 |
22.01.2006 03:14:13 |
|
|
Free Hot Phone Sex
+8613352960090
100% Free multi-lingual
AnimalSperm Production
elmar@digi-art.de
...
|
1 |
21.01.2006 16:13:32 |
|
|
Free Hot Phone Sex
+8613352960090
100% Free multi-lingual
AnimalSperm Production
elmar@digi-art.de
...
|
1 |
21.01.2006 16:13:27 |
|
|
Free Hot Phone Sex
+8613352960090
100% Free multi-lingual
AnimalSperm Production
elmar@digi-art.de
...
|
1 |
21.01.2006 15:35:20 |
|
|
Free Hot Phone Sex
+8613352960090
100% Free multi-lingual
AnimalSperm Production
elmar@digi-art.de
...
|
1 |
21.01.2006 15:35:12 |
|
|
Help! Too Few parameters. Expected 3.
Trying to Export items from a Query "CalenderExport Q" (See Query Below) that
uses imputs from a combo box in a form. Using a function to export the
records to Outlook - However, When it gets to Set rst =
oDataBase.OpenRecordset("CalendarExport Q"), it gives me an error "Too Few
parameters. Expected 3." How can I have it call the records that show when I
open the query?
Function Exp...
|
3 |
19.01.2006 14:45:29 |
|
|
Moving info between Excel and Access
I'm looking for some feedback with regard to taking some data from an Excel
Workbook we use to track info on and loading it into Access AS QUICKLY AS
possible. Once it's in Access I can do the rest, but I am sort of new at the
best method to automate the movement from Excel to Access. I kind of know
DAO and haven't used ADO - is ADO any faster with what I'm doing below.
I'm wanting ...
|
2 |
19.01.2006 08:09:04 |
|
|
References Errors and generally other weird behavior
I'm having a problem with access 2000 on my system. I have uninstalled and
reinstalled it several times and occasionally the problem is fixed for a
short time and then reoccurs. I have code that runs at my clients and on my
laptop and was running perfectly on my desktop but now doesn't. I am using
the following line of code on doing a resize of forms based on the screen
size.
s...
|
4 |
19.01.2006 05:45:00 |
|
|
Free mp3's
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft DHTML Editing Control">
<TITLE></TITLE>
</HEAD>
<BODY>
<P>And much more that that!</P>
<P><A href="http://forum.saait.net/">http://forum.saait.net/</A></P>
<P>This site offers free and legal mp3's, software, movies, games.<BR>They also
have a l...
|
1 |
18.01.2006 05:03:32 |
|
|
Free access to several paysites! Free movies - games - software - mp3 - and more!
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft DHTML Editing Control">
<TITLE></TITLE>
</HEAD>
<BODY>
<P>I found this great site that offers loads of content for
free! I got a bunch of mp3's from it, but they offer movies, games and software
too!</P>
<P>Go check it out! Quickly!</P>
<P><A href="http://w...
|
1 |
17.01.2006 22:41:13 |
|
|
multiselect list to create new records
I'd like to use a multi-select list box to select from a pool of records,
and append the selections as new records in another table. Advice on how to
write this procedure? Examples?
...
|
2 |
15.01.2006 14:38:39 |
|
|
"Access 2000 VBA Handbook" problems
Struggling my way through this text (Author Susann Novalis; published by
Sybex). But I'm a moron, and the exercises aren't coming out on my computer
the way they do in the book.
For example, the very first order of business is to create an Expenses db
using the Access Wizard. Somehow, the author's result comes populated with
Northwind Data, on which many of the subsequent lessons are base...
|
1 |
15.01.2006 10:09:13 |
|
|
Excel.Application process does not clear
Re Office XP (no SP's)
I am using Access VBA (DAO) to generate a spreadsheet from some relevant
Access data like this:-
Set objExcel = CreateObject("Excel.Application")
...assign recordset values to relevant cells...
Then clear up with…
objExcel.ActiveWorkbook.SaveAs ("c:\Windows\Temp\Invoice - " &
Forms!frmPrintInvoices.txtInvoiceNo & ".xls")
If (Not objExcel I...
|
4 |
12.01.2006 20:40:02 |
|
|
PivotChart
How could I prevent that users change the style and formatting of a Pivot
Chart. I want to use VBA. Also I would like to know any good references
about pivot chart and pivot tables with Access 2003.
Thanks
Jose Carrasco
solexpertas@yahoo.com
...
|
1 |
12.01.2006 16:07:21 |
|
|
Move command using Shell in Access VBA
I am trying to execute a move command in VBA for Access using the Shell
function. The code I'm using is as follows:
x = Shell("""MOVE ""P:\Field Audits\FAT\CompletedAudits\*.xls"" ""P:\Field
Audits\FAT\UploadedAudits\""")
The move command works fine when included in a .bat file and called from the
VBA module with the Shell function. However, I would like to be able to move
files one...
|
8 |
10.01.2006 21:02:23 |
|
|
getting run time error 2465, help me!!!
I have the following code that was created before I started on this project:
Option Compare Database 'Use database order for string comparisons
Function CalcKm()
Dim db As Database
Dim FormName As String, SubFormName
Dim eol As Single, bol As Single
Dim statint As Single, kmcount As Single
Dim getval As Variant
Dim fm As String
Dim yearstr As String
Dim Yearval As Integer
Se...
|
3 |
05.01.2006 22:55:38 |
|
|
ADP in Source control and Null Fields now returning EMPTY
Hi,
We have a large corporate project that is an ADP hooked up to SQL. Many
Programmers work on it so it is under sourcesafe control through the IDE.
This has been working fine for many years. We have just come across a new
problem we cannot resolve.
If we Create a new ADP on someone's machine using the option to create a
database from the sourcesafe project. We started getting weird e...
|
3 |
05.01.2006 09:57:46 |
|
|
References to a Database in Access 2002
Hi,
I'm trying to migrate a Access aplication from V97 to 2002 .
In 97 when I wanted to reference the Database I used:
dim db as Database
set db= dbengine.workspaces(0).Databases(0)
In the manual I've it does more or less the same way . I've done it in
2002 and it doesn't recognise the Database type. How should I do it?
...
|
2 |
04.01.2006 23:58:31 |
|
|
Need help with Array...
I am trying to fill an Array with values from a Query. The info is showing
in the locals window, but I get an error saying "Subscript out of range" and
the line loading the array...??? Help?
Option Compare Database
Option Explicit
Public Sub Set_DNet()
Dim db As DAO.database
Dim rs As DAO.Recordset
Dim varDNet() As Variant
Dim i As Long
Set db = CurrentDb()
Set rs = db.Ope...
|
10 |
30.12.2005 00:43:35 |
|
|
Earn money Online - without risk!
Earn money Online - without risk!
For all people, who can utilize money.
Are you on the search for a lucrative source of income? Would you like to
work of at home out of, without
yourself you someone makes directions? Would you yourself like to
determine, when, how much and like often you
salary?
Then you should take yourself a couple minutes time. You happily will be
that you ...
|
1 |
25.12.2005 01:36:13 |
|
|
THE > SUPER-MONEY-SOURCE <
THE > SUPER-MONEY-SOURCE <
This special program is acquire copyrighting-protected, only with the
participation you the copyrighting at this program. Prohibited utilization
leads to the notice!
THE > SUPER-MONEY-SOURCE <
In this program, there is really money.
1200.- Euro / dollar and MORE are in only 3 weeks possible with only 5
participants!! Example, you get Euro o...
|
1 |
22.12.2005 17:14:14 |
|
|
Unexplained DLL Error
Hey. I have an Access database which works perfectly on most of the PC's I
have tested it on - except one. I get the error 'cannot load dll' when it
runs the following line of code:
Dim rst As New ADODB.Recordset
rst.Open "Select FisheryName, FisheryID FROM tblFishery WHERE FisheryId="
& Me.FisheryID, CurrentProject.Connection, adOpenStatic, adLockReadOnly
The Me.FisheryID part of ...
|
2 |
21.12.2005 12:37:47 |