Email with Lotus Notes
Tue, 9 Dec 2008 10:54:01 -0800
I am trying to use the following code but I keep getting an error message
"the expression on click you entered as the event property setting produced
the following error: User defined type not defined". I am new to VBA code.
I found this online and was trying to use it for my purposes.
Dim Maildb As Ob ...
|
Code not linking to a BE table
Tue, 9 Dec 2008 10:51:01 -0800
All -
I have a BE database, in it, there is a table which contains a record for
every table that is the BE database, except it self. In the front end
database, I have the code to look up any table in this look up table that the
front end does not have a link to. All the front end tables are linked to
th ...
|
MS Access "VALUE" Function
Tue, 9 Dec 2008 09:11:11 -0800 (PST)
Hello,
I am a little stuck with this query. I am trying to create a query in
MS access that looks at the values in a created form an pulls like
matches out of a table. Now when all of the boxes in the form are
filled in this works great I would like to have the user leave the
field blank and have it just pu ...
|
ODBC Error 3146
Tue, 9 Dec 2008 08:43:00 -0800
I have a SQL pass through query with its ODBC Timeout set to 0. The problem
I am running into is that I open the query as a recordset and it loops
through just fine until I get the ODBC Error 3146. My procedure works just
fine up to that point, but it drops after about 10 minutes. Does anyone have
any idea ...
|
Compile Error
Tue, 9 Dec 2008 07:23:15 -0800
Can anyone tell me why I get a "Compile Error - User Defined type not
defined" on my record set.
How do I define my record set?
Mike
Sub Show_Status_Chart_Click()
On Error GoTo Show_Status_Chart_Err
' Dimension arrays for recordset & excel etc
Dim inStat As ADODB.Recordset
Dim objExcel As ...
|
ODBC setup
Tue, 9 Dec 2008 06:57:16 -0800 (PST)
I'm trying to setup linked tables through ODBC connection to an Oracle
database.
I'm having some difficulty connecting as it simply hangs, and I have
to shut down access.
I figure it must be a problem with DNS because I was able to make it
work when I had Access 2003 and now with 2007 it fails.
I checked ...
|
Function Parameters
Tue, 9 Dec 2008 06:54:01 -0800
This is probably very simple.
I copied the code from
http://www.mvps.org/access/api/api0008.htm
and pasted it into a module called modGetRacfID (here is the code)
Option Compare Database
'******************** Code Start **************************
' This code was originally written by Dev Ashish.
' It is ...
|
|
|
not counts correctly
Tue, 9 Dec 2008 05:56:25 -0800
My code is supose to pop a message every tenth record. I found this code and
modifed it to make it work.
Private Sub Form_Load()
Me.txtCount = Me.Recordset.RecordCount
End Sub
Private Sub Form_AfterUpdate()
Dim lngCount As Long, lngStart As Long
lngCount = Me.Recordset.RecordCount
lngStart = M ...
|
Setting a object to ctlBoundObjectFrame.Object crashes access
Mon, 08 Dec 2008 23:54:19 GMT
I have an Access report with a BoundObjectFrame that contains an MS word doc
from a table that has a column type of OLE Object.
It works fine until I try to get a Word.Application or Word.Document variable
assigned to it so I can do some simple manipulation (just some token
substitution).
The code looks lik ...
|
Indirect file or field references
Mon, 8 Dec 2008 14:43:02 -0800
Instead of using Control Source = tablename, how do I refer to a table whose
name is contained in a variable?
Similarly, rather than Object Source = objname, how do I refer to a field
whose name is contained in a variable? ...
|
