Hello, all.  I have been doing a huge amount of research on this for the past
couple of days.  So far I have been able to query my Oracle database without
needing to dynamically provide the username/password each time by using
pass-through queries.  However, it does not seem to ...

I have a field that has data in the format of 2 alpha characters followed by
5 digits.  I want to query the field based on the first 2 digits (the 3rd and
4th characters).  I was going to use a SUBSTRING function but Access doesn't
recognize it.  What is the equivelant function ...

Hi.  I am looking to generate an spread sheet based off of a dynamic query.  
The report is for amount overrides in a small internal system connected to
SQL Server.  I have a form in Access that gives the user options to select
the information they want from a series of dates, ...

Hi, I have the below code, and I am learning how to store stuff from excel to
Access.  I build a program that stored all the info in another Excel
workbook, however it has gotten to big now, and I need something bigger...but
when I run this command, it gives me the below error.. ...

I have a macro that prints 10 to 15 different reports. The macro calls a VB
function to set the default printer, then it opens, prints, and closes each
report in turn. Is there a way to modify this macro so it sets the default
printer to Acrobat Distiller, then opens each report, ...

Hello, I would like to put the outlook calendar in a form for insert... with
him.
I use the Oulook View Calendar, but it's allways show the Incoming Box, and
I cannot modify it.

Hi. Please can someone tell me if it is possible to only search for "a piece"
e.g the first 5 letters in a record?
Basically on my After_Update action if there is a record named "christopher"
and the name "chris" is entered. I need the code to search for all records

I have the following code to add a MySQL ODBC 3.51 Driver linked table to my
database.  It works in Office 2003 but crashes Access in Office 2000 and
corrupts the linked table manager and the database.  We're running Windows XP.
Dim RT As Database

I am building an application for a performance assessment program.  I am
trying to build the functionality for it to automatically send an email to
the next person in the review chain when a function "ContinueRouting" is
called.

My function which send mail via CDR is as follows:
Public Function SendEmail(strMailContent As String, strAttachedFilePath As
String, strSentTo As String, strCC As String, strBCC As String, strSubject As
String) As Boolean

I have created a database that is a huge contact directory. Its stored on a
network drive that is shared read-only with everyone in the company.
Upon opening, it throws up the following error message:
The database 'contacts' is read-only.

I have read repeatedly on this forum about using "Application.
Followhyperlink" to launch files in their default applications. I am trying
to use this techique to open .jpg files, using a control from a form to
provide the file path. The problem is that the .jpg files open in ...

on my main form i have a continue button that i want to run a query based on
the current value of 2 combo boxes and then populate the results into the
appropriate fields in my continuous form howeever i need to run a different
query for different values of the 2 combo boxes. I ...

I have a system where the user interface is a single form.  Users have no
need to access anything else, other than through links on this form.  This
form is a "pop-up", which means it can live outside of the Access
Application window.  This is useful in that it allows access to ...

Please help. I know just enough to get myself into trouble.
I would like to increment a date field with "+" or "-"  keys, and use it as
a default on the next data entry form. The following code almost works. The
"+" & "-" keys work to increment the date, but when I go to the next ...