Running Code flashes to Object Window
Tue, 9 May 2006 08:10:02 -0700
This just started happening with an upgrade to 2003. How do I disable this? ...
|
Arguement not optional in vb module
Wed, 3 May 2006 03:20:02 -0700
Hi
I have an after update event on a field on my people form.
When i try to debug the code i get an "Argument not optional" error in
relation to the IIf statement.
I used the same code in an update query and it worked perfectly.
PE_Initials = (Left([PE_First_Name], 1) & IIf(InStr(1, [PE_First_Na ...
|
Database datatype
Tue, 2 May 2006 10:51:23 -0400
Access 2003:
If I wanted to create an object variable as a reference object to the
CurrentDb object property of the Application object, other than the generic
Object datatype, is there a specific datatype that will work?
It would be a shame if M$ took away the ability to set those object
properties with the ...
|
Multiple Recordsets
Tue, 2 May 2006 06:55:01 -0700
How do I open more than one table at a time in the same database using ODBC
and ADO? The following code abends when I attempt to open the second table.
Sub MultipleTables()
'
' Create the Recordset attributes
'
Dim rs1 As Recordset
Dim rs2 As Recordset
Dim rcd_cnt1 As Integer
...
|
Relinking Tables with VBA
1 May 2006 10:18:42 -0700
Hello,
Please see my problem as outlined below. Any advice/suggestions would
be appreciated! (Also not sure if I posted this in the appropriate
place, please advice if so)
Goal: When my database opens, if the developers-version of the database
front-end is open, I would like to have the database prompt th ...
|
Add a field to an existing table using vba
Sun, 30 Apr 2006 15:38:01 -0700
In a userform I have used vba to run a make table query. I now need to add
an Autonumber field to this table that restarts at '1' each time the code is
run.
If I use the userform to make the table and then manually add my autonumber
field it always starts at 1, which is why I want to use 'Make Table' eac ...
|
Compile Error: User-defined type not defined
Fri, 28 Apr 2006 07:45:02 -0700
We added a Visual Basic Module1 to an Access Database that uses both Access
Tables and SQL Server Tables. Within the first executable function in VB
Module1, we are getting the following error message...
Compile error: User-defined type not defined
The statement its attempting to execute is...
Dim MyD ...
|
|
|
Set control's visible property value on a nested subform
Thu, 27 Apr 2006 08:22:03 -0700
From a public function in a module in Access I'm trying to set the visible
property to false on a control on a nested subform. I have the main form
(frmModuleWeeklyReport) with a subform (Workstream Name, Status & Comments).
The subform (Workstream Name, Status & Comments) has a subform (Deliverable
Deta ...
|
Shell command in Access Module dos not work on Windows 64 machine
Wed, 26 Apr 2006 12:10:02 -0700
I have an application in Access 2003 that works fine on a windows 2000
server. Users access the application through terminal services. One feature
of the application is using a Castelle Box for faxing information from the
Access app. This is accomplished using Shell() in VBA fax via the Castelle
Box (it ...
|
Create a button to do â??Enterâ?(Key board Enter function) on Form.
Wed, 26 Apr 2006 08:55:03 -0700
Hi,
I am using FORM to enter ID number and Employee number. For this I am using
touch screen. We are not using key board. I just need to create Macro or VB
code with a Command button when press this button need to do “Enter” . Then
it is going to next field.
Any help would be appreciated.
Indu
Create ...
|
