|
How to correct tele number based on "Dialing Rules" in "Phone and Modem Options"
I am using a simple "I/O Active X Communication Module" to utilize the
computer's modem as an auto dialer.
When the following code runs the number in the [TeleNumber] field is dialed
and the user is prompted to "Pick up Handset" after which the modem
disconnects and conversation takes place.
I need to have the [TeleNumber] changed based upon the "Dialing Rules" in
the "Phone and ...
|
13 |
1/10/2007 9:59:16 PM |
|
|
OpenRecordset
Thanks for taking the time to read my question.
I'm trying to open a table as a recordset. It's not working. I haven't
done this in a while but I think I'm doing it correctly. I'm using
Access2000.
Dim db As Database
Dim rstEmployee As Recordset
Set db = CurrentDb
Set rstEmployee = db.OpenRecordset("tblPersonnel")
My code gets stuck on Set rstEmployee and I don't know why.
...
|
3 |
1/10/2007 5:32:43 PM |
|
|
Auto fill error trapping code into a procedure
Is it possible to make access automatically put in the following code when I
select the code builder option for an event?
Example:
Private Sub MyControl_Click()
'---Code that I want Access to automatically insert:
On Error GoTo ErrHandler
ExitHandler:
Exit Sub
ErrHandler:
MsgBox Err.Description
Resume ExitHandler
'----
End Sub
...
|
3 |
1/10/2007 3:27:37 PM |
|
|
Insert Into Syntax Error
I am getting a syntax error in my from clause below. I am trying to run a
query to add data to a local table by referring to two external tables in
other access files.
If I link to the two external tables the query runs ok. As soon as I include
the 'IN' elements I receive a syntax error.
Where have I gone wrong.
sqlstr = "INSERT INTO STATS ( ModelRangeDescription, Comment, [Count] )" ...
|
3 |
1/9/2007 8:50:57 PM |
|
|
Weird Error Message
I keep getting this error:
ORDER BY clause ([ServiceYear]) conflicts with DISTINCT.
when this line tries to execute:
cboYear.RowSource = "SELECT DISTINCT [Service Year] FROM
ServiceDetails WHERE [ServiceCode] = 'ABC' ORDER BY [ServiceYear] DESC "
What am I doing wrong?
...
|
7 |
1/8/2007 3:07:31 PM |
|
|
Programatically create Get/Let properties
I would like to automate the coding process of creating Get and Let
properties from a Type structure that I design in classes. For instance, I
define the following Type:
Private Type udtState
strName As String
intAge As Integer
dtBirthDate As Date
strAddress As String
End Type
I would like to create a procedure that I could reuse in my development
efforts to loop ...
|
2 |
1/5/2007 10:01:16 AM |
|
|
Save the source code virtually and secured
Dear all,
I want to save my source code virtually. Is there any free online storage ?
Please recommend several links if you know.
Thanks.
Vensia
...
|
2 |
1/5/2007 2:55:59 AM |
|
|
Dlookup
Has anyone ever had trouble with DLookUp *not* returning the correct value,
or returning a NULL value, when in fact there is for certain data in the
field you are quering with DLookUp?
...
|
3 |
1/4/2007 11:58:21 PM |
|
|
Eval() Question
I am trying to use a function to instantiate an instance of a class and
return the value from the method specified as a parameter of the function.
I have tried a couple of ways and used debug.print to get the values of the
different expressions at execution and have indicated the return values in
comments in the code.
I am using the function as the criteria in a query in the following ...
|
4 |
9/30/2006 6:36:21 AM |
|
|
how can i disable the Design button
how can i disable the Design button in the application?
thanks
...
|
5 |
9/30/2006 6:06:06 AM |
|
|
Convert Hex to Decimal
Does anyone know of an easy way to convert a Hex number to a Decimal? These
numbers would be large, with a typical length of 13-15 characters.
Thanks!...
|
8 |
9/29/2006 7:57:42 PM |
|
|
Error6 - overflow - further post
This is a multi-part message in MIME format.
------=_NextPart_000_0081_01C6E2E8.7CF419A0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Hello All
Further to my post dated 11 Nov, to which I received a number of useful =
responses from Doug Steele, John W. Vinson and Robert Morley, (many =
thanks to you all), I think I now know the cause ...
|
2 |
9/28/2006 10:27:53 AM |
|
|
DoCmd.OutputTo
I'm using ms access 2003 (ADP) vs SQL Server.
I created a module using the method DoCmd.OutputTo to export a view to Ms
Word.
It works fine, but it needs improvement. I have two questions.
1. The columns width is not properly. I would like increase the column with.
How can I do programmatically?
2. I would like create a Template with the logo and landscape format and
then export t...
|
10 |
9/27/2006 1:13:42 AM |
|
|
Snapshot Viewer PrintDevice
I have a series of .snp files, each containing the Sales Statement for a
particular customer. Some customers object to receiving a snapshot report,
so I am attempting to convert their files to PDF using pdfCreator. So far,
I have been unable to change the Print Device for the Snapshot Viewer - the
alternative would be to have a marker on the index file and create the
original print as ...
|
2 |
9/26/2006 11:49:03 AM |
|
|
Info: download mdb module for creating internal documentation
Hi,
i've created a selfcontained module (tested with Access2003) for download
which allows you to document your systems (done via two tables) here a short
description:
'#######################################################################################
' mdlCreateObjectListingInTables
'#######################################################################################
'
' Att...
|
1 |
9/24/2006 11:38:26 PM |
|
|
Insert photos
Hello
How could I insert a photo on the database and show it in a form?
I have created an OLE object and try to insert a photo but I don´t success
showing the picture in the form, I can only open it clicking twice and see
the image but not surfing form one record to another.
Thanks for all
...
|
3 |
9/24/2006 8:15:42 PM |
|
|
Re - order Level
I am trying to incorporate a re-order level function within a database I am
designing and need some suggestion / advice....
I have a function "Onhand" which gives me my current stock total.
I have added a new field in to tblproducts called reorderlevel which is
where the user can enter a number at which reordering should take place.
e.g. StockTotal= 10 reoderinglevel =10 item ??????? ...
|
3 |
9/24/2006 5:12:01 PM |
|
|
ByVal and ByRef
Can anyone explain when to use these two terms in English?
I like to think I am a pretty smart guy but I just dont get it when it comes
to these two................
Thanks!Mark...
|
16 |
9/24/2006 1:00:50 AM |
|
|
Format a Control in Continuous Form
Hi,
I have an issue in a continuous form in MS Access 2003; I will
appreciate your assistance in it.
I have a control in a continuous form where I want to currency format it, in
each row, different than another. In other words, I want the first row to
display the amount in US Dollar format, the second in sterling pounds format
and so on.
Is there a way to implement ...
|
3 |
9/22/2006 7:32:29 PM |
|
|
Database Properties / Contents
Once in the past five years, I have been successful in updating an AS/400
file using an Access database. Unfortunately I cannot remember which PC it
was on or who the client was. I therefore need to develop a program to
search all the modules and class modules in each of the databases on each
computer - which would be VERY tedious.
As a (more interesting) alternative, does anyone know ...
|
4 |
9/22/2006 3:13:54 PM |
|
|
'Database' not a valid data type??
Very simple data file in Access 03. Single table, one form to manipulate
some data and export to text file via a Print #1 routine. Here's the issue:
Dim MyDB as Database
is not a valid data type. After typing the AS, my options go from
DataAccessPages to DataTypeEnum. Now in another database, I have used this
Dim statement repeatedly and successfully. Why would I not have this opt...
|
3 |
9/20/2006 5:31:01 PM |
|
|
Stock Value Calculation
I have the following code which gives me my stock quantity ....
Function Onhand(itemCode As Variant, Optional vAsOfDate As Variant) As Long
'Purpose: Return the quantity-on-hand for a product.
'Arguments: vProductID = the product to report on.
' vAsOfDate = the date at which quantity is to be calculated.
' If missing, all transactions a...
|
1 |
9/20/2006 10:13:43 AM |
|
|
how can i detemine by code the ODBCConnectStr of a specific passthrough query
how can i detemine by code the ODBCConnectStr of a specific passthrough
query?
thanks
...
|
2 |
9/20/2006 6:54:46 AM |
|
|
String HELP!!!!
Help! My string continues to return a value of Zero. I loop through a list
of specialties. Say I select Cardiology. Then when I select Option10 that
report should open with just the Cardiology detail. Why am I getting Zero
rather than the value I selected? Here is my code:
*****'Loop through List to see what Specialties were selected*****
For Each varItem In Me!SpecialtyList.Item...
|
6 |
9/19/2006 8:29:24 PM |
|
|
Do Until... Help Please!
Hey Guys (and Gals),
Having fun with Do Until statements, can't get this one to work...
What I want is if you double-click on one field then clear the contents.
What it's doing is asking you the question 9 times instead of just the one
you double click on. Hope that makes sense. Can someone help me?
Thanks in advance,
Gina Whipp
Public Function ClearViolation()
Dim LabelNum...
|
12 |
9/19/2006 6:55:31 PM |