|
ms access VB and MS Outlook contacts
hello,
i need to find out which components to use to be able import and export
ms outlook contact item into an ms access database using them ms access VB.
i'm using the ms access 2003.
thanks for any help.
happy coddin'
(buddy*)__lukas__
...
|
2 |
2/15/2006 10:14:24 AM |
|
|
Help with module code
At the bottom of this code is "Function Removable" I am only able to call
up the A:\ drive, but I need it to also call up the C:\ drive or another
removable drive such as a flash stick. I believe it has something to do
with "Case Removable Media": Can anyone revise this so I can call up at
least the C:\ drive...Thank you, Randy
Option Compare Database
'************ Code Start *...
|
6 |
2/15/2006 1:38:35 AM |
|
|
Search Via combo box
On my main switchboard forms I have a few combo boxes where the user can
select a coordinator name to view all the contracts that coordinator is
handling
I created another combo box to do the same thing but search for a single
contract that they select from the drop down list. I just copied the code
from the coordinator combo box and changed the field names. For some reason
it doesn't...
|
5 |
2/14/2006 9:38:32 PM |
|
|
Access report to Word then to Publisher
This is a multi-part message in MIME format.
------=_NextPart_000_002E_01C630B1.8B0FC910
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I need help getting started.
I have an access report that needs to be printed in booklet format. =
Publisher does this real nice.
Today I create the report in Access, publish it to Word, format it in =
...
|
2 |
2/14/2006 7:11:17 AM |
|
|
Find & Replace (behind the scenes)
I was once faced with finding and replacing through over 40,000 large
records and because the database was so large (over 500MB) i kept having
problems on my machine, until I was given some nice code to do this through
a module.
First, my current problem, then the code: Now I am trying to find/replace "
" (tab) with "" (nothing) and also, """ (quotation mark) with "'"
(apostrophe). I ...
|
4 |
2/13/2006 3:01:47 PM |
|
|
Find all calls to a user defined function.
Can anyone tell me how to find all the places where a particular
subroutine/function is used in a MDB?
...
|
9 |
2/10/2006 9:07:16 PM |
|
|
Linked tables path
Can I change the path of the linked tables by code ?
I would like the link to be the same as the front end (fe with forms and be
with tables are in the same directory).
In VB6 you can use something as application.path....
--
Filip
http://users.skynet.be/101airborne
Official Site of the 101st Airborne - 463rd PFA
----------------------------------------------------------------------
...
|
3 |
2/10/2006 7:38:07 AM |
|
|
Setting the margin width of a report by code
Hi,
we have set the margin width of a report to the minimum possible on PC "A"
(in the page properties)
and then we sometimes copy the mdb to a different computer "B", to change
that report design,
then after copying the mdb back to "A" the margin settings are gone (we get
a lot of white labels again).
In the page properties we have to apply the 'minimum' settings again.
Can I avoid t...
|
3 |
2/8/2006 2:06:34 PM |
|
|
Sending Email in MS Access
I would like to send an email from MS Access - but instead of sending it
directly, I would like to store the email in the "DRAFT" folder, so the
automated email can be reviewed and or edited first, and so it can handle
bulk saving (20-50 emails) before the user is prompted.
Is this doable ?
If so, can you tell me how this can be achieved ?
Many thanks,
John...
|
5 |
2/8/2006 9:47:59 AM |
|
|
what's happened to MSDN?
Did something happen to MSDN?
I went there, and there's no content, just the table of contents, a
hyperlink that doesn't go anywhere, and a request to rate the page, but no
content.
Is this material not available to the general public any more?
...
|
2 |
2/7/2006 10:44:38 PM |
|
|
Importing data from a Legacy Database
Hi There,
I'm trying to import data from a legacy database in to the database of the
new application that I am creating. I want to accomplish this by building a
INTO query and will apply the query to convert the data over at launch time,
ensuring that the new database is converted using the most current data.
The new database uses a couple of different types to store data. Also,
th...
|
2 |
2/7/2006 3:25:30 AM |
|
|
I need help
every time I send and receive this error message comes up. It says incorrect
password or account nameCheck the username/password or security settings.
And it doesn't let me get my mail. can somebody help? my address is
eli.barr@providenceday.org
...
|
1 |
2/7/2006 2:06:14 AM |
|
|
Can't find dll entry point
Hi all,
I'm new to API calls and have used some code I got on a training course,
which is giving me an error message. I haven't got a clue what the problem
is (have searched google but to no avail). Can anyone help me please? The
code is:
Public strUserName As String
'API Declaration - uses WNGetUser as alias
Private Declare Function WNGetUser Lib "mpr.dll" _
Alias "WNetGetUser" (...
|
3 |
2/6/2006 4:49:22 PM |
|
|
Using Clipboard in VBA Office 2002
I am trying to use the clipboard from code in Office 2002. In earlier
versions Microsoft Forms 2.0 had a DataObject object that allowed this but
Office 2002/2003 does not seem to have loaded such a reference. How can I do
this in Office 2002?
Maurice
...
|
2 |
2/5/2006 4:33:06 AM |
|
|
Not Responding - Access hangs
Hi,
My application hangs in the below code, I am getting data from a recordeset
and the displaying the data in a PowerPoint that is generated from the
application...
Dim pptApp As PowerPoint.Application
Dim pptPres As PowerPoint.Presentation
Dim pptSld As PowerPoint.Slide
Set pptApp = New PowerPoint.Application
Set pptPres = pptApp.Presentations.Add
Set pptSld = pptPres.Slides.A...
|
2 |
2/4/2006 4:40:04 AM |
|
|
Control Anchors and resizing
I have an app that runs mainly from a single form with loads of controls.
I want to be able to resize the main window but whereas with VB and Delphi
there are properties to link controls and to manage resizing there is
nothing in Access that does the same thing.
Is it possible to have components resize on a form or should I just give up
and use VB ....
I would appreciate any thought...
|
10 |
2/3/2006 9:49:47 PM |
|
|
How to open the browser from an Access form?
I want the end of my command-button processing to open an external webpage
for the user. I seem to recall a browser object.
Any pointers, documentation, etc. would be greatly appreciated.
...
|
5 |
2/3/2006 8:05:24 PM |
|
|
EOF or BOF Error message help
Hi,
I am getting the following error messages from the code below....
Dim rstAccomp As ADODB.Recordset
Set rstAccomp = New ADODB.Recordset
Dim strSQL As String
Dim StartDate As Date
Dim EndDate As Date
strSQL ="SELECT DISTINCT Accomplishment, DDate FROM tblAccomplishment WHERE
ProgramIpt = '" & SelectedIpt & "' AND DDate > " & Format(StartDate,
"\#mm\/dd\/yyyy\#") & " AND DDa...
|
2 |
2/2/2006 7:10:14 AM |
|
|
Detect CD drive?
Hi,
Anyone know if it's possible to detect if a drive letter is a CD or DVD?
I'd love to be able to do that!
Thanks
--
Remove numeral in e-mail address to send e-mails.
www.marshallarts.com.au
...
|
4 |
2/1/2006 11:12:11 PM |
|
|
Looping through controls in Tab Order
After searching a through the newsgroup and not finding anything that did
exactly what I want, I've created the following functions to return a
collection of controls in tab order. As I'm fairly new to Access VBA, are
there any gotcha's here that I might be missing? If not, then hopefully
others will find this code helpful.
-----------------------------------------------------------------...
|
1 |
1/31/2006 9:56:14 PM |
|
|
Transaction Boundaries...
Hi;
In a module, I'm updating two Dao RecordSets. So I issue a "StartTrans" at
the beginning, then open the RecordSets, make the necessary changes to the
the RecordSets, close the RecordSets, and finally issue a "CommitTrans".
The records get updated properly.
Question: Does it make a difference where I **close** the RecordSets? Am I
defeating the purpose of the Transaction if I close...
|
4 |
1/31/2006 2:43:14 PM |
|
|
How to reliably hide menu bar
Hi all,
I want to have my application appear with no menu bar at all. I found some
code somewhere that looks like this:
DoCmd.ShowToolbar "Menu Bar", acToolbarNo
I have put this in some code which is run from the Autoexec macro.
The problem is, sometimes it works and sometimes it doesn't. If I start
Access and load my app with the Shift key held down, then manually run
Auto...
|
2 |
1/31/2006 1:11:37 AM |
|
|
Data changes not refreshing immediately
I have a multi-user application with front-end / back-end (database on a
server).
I need to set the value of a field in a control table in the database. The
control table is "OpenBatchOwner Table". The field is "OpenBatchOwner".
There is only one record in the table, and there is only one field in the
record. This is a "control record" that coordinates a certain function
within the appl...
|
5 |
1/30/2006 4:45:13 PM |
|
|
Type Mismatch help
Hi,
I am getting and MS Access Error on the below query...
"SELECT DISTINCT Accomplishment FROM tblAccomplishment WHERE ProgramIpt = '"
& SelectedIpt & "'" & " AND DDate > " & Format(StartDate,
"\#mm\/dd\/yyyy\#") AND DDate < Format(EndDate, "\#mm\/dd\/yyyy\#")"
Thanks
...
|
2 |
1/28/2006 5:23:59 AM |
|
|
Disabling Restore Window button
I've succesfully used http://support.microsoft.com/?id=245746 to selectively
disable / enable the "X" (Close Window) button.
I tried to use this as a model for a similar capability to selectively
disable / enable the Restore Window button (the two little boxes) with no
success. While I get no error returned, the code produces no visible
result.
For the button's constant, I used &HF120& ...
|
1 |
1/26/2006 3:14:34 AM |