Editing records
Wed, 5 Apr 2006 21:04:19 +0100
can somebody help me with the logic of a record EDIT procedure.
I want the user to click on a botton to edit a record
I have a combo box to find the record
so the form opens with
me.dataentry = true
me.allowedits = false
but this does not allow me to change the value in the combo box
What is the ...
|
Browse control to browse through a folder
Wed, 5 Apr 2006 04:09:01 -0700
I want a control that will enable the user to browse a folder for files. Does
anyone know the name of the control? It will be used in a form.
Thanks
Suneel ...
|
VB Reference Libraries
Mon, 3 Apr 2006 06:26:02 -0700
Hi,
I need to activate certain VB reference libraries within a VB6 project using
code (e.g. Microsoft Office 11.0 Object Library).
This will ensure all users applications have reference to the correct
Reference library!!!
Can anyone help?
Cheers,
Steve.
...
|
ADO & SQL string
Sun, 2 Apr 2006 17:02:02 -0700
Hi
Just wondering how would I construct this SQL string to use inside VBA code:
F_PUPILS.PU_SEQ, tblAcadGrade.AcadYear, tblAcadGrade.FS_Set_Code,
tblAcadGrade.FS_Subject, tblAcadGrade.Autumn, tblAcadGrade.Spring,
tblAcadGrade.Summer, tblPastoralAcad.WiTutor, tblPastoralAcad.SuTutor,
tblPastoralAcad.SpTut ...
|
More troubles with ADO and SQL Server 2005
Sat, 1 Apr 2006 08:10:45 +0200
Hi all!
Up to now, I was working with a SQL Server 7 and VBSQL. It was easy to call
a stored procedure with (usually) a SELECT parameter and retrieve a cursor
from the stored procedure.
As I am in the process to migrating to a SQL 2005 Server, I can't use VBSQL
anymore.
What I try to do is as follows:
...
|
extract list of forms name from another access project
31 Mar 2006 02:38:08 -0800
I wrote an Access Project Application... All I need is to get the list
of forms existing in an external access project (adp).
Any suggestion, please?
...
|
Trouble with a rather simple function
Thu, 30 Mar 2006 10:23:25 +0200
Hi all!
I have a problem while trying to use a rather simple ADO function.
Here is the situation:
Server: SQL Server 2005. I have all permissions on this server and its
objects, databases...
Database: TEST_ADO containing one table as follows:
Table: Table_1 with 2 columns:
COL_1(primary key, integer, not ...
|
|
|
Microsoft Document Image Printer - MODI Registry Settings
Wed, 29 Mar 2006 17:05:20 -0800
Does anyone know what are all the available registry settings for MODI?
Through much searching in google (msn search finds nothing) I've found the
following the following
' Write to File Only (uses current save folder and Note####.mdi as file name)
SetKeyValue HKEY_CURRENT_USER, "Software\Microsoft\Office ...
|
Manipulating data in textbox with VBA code
Wed, 29 Mar 2006 13:47:04 -0800
I am getting ERR 3326 "This recordset is not updatable" when trying to
manipulate data in controls on a form with VBA. The code is in a form module,
examples:
Forms!frmMembership!DateJoined = Date
Forms!frmMembership!DuesAcct = -Forms!frmMembership!CurrDues
What triggers ERR 3326? ...
|
Editing or adding a record
Wed, 29 Mar 2006 10:02:05 -0600
I'm trying to edit a record.
First I connecto to an excel spreadsheet and then to a sql server table via
odbc.
I load the first row of the spreadsheet, find the record in the table, if it
exists. If it exists, then I want to edit it. If it doen's exist I want to
add it.
Here's my code so far. This i ...
|
