Upsizing wizard
Thu, 18 May 2006 11:51:02 -0700
Hi all,
I an using the upsizing wizard to transfer my backend data to SQLServer. If
I use the wizard to write to a new database it works ok, but if I attempt to
upsize to an existing database I get the error
'[DBNETLIB][ConnectionOpen().]SpecifiedSQL Server not found.' This error
occurs when I specify t ...
|
Populate table from recordset
Thu, 18 May 2006 09:18:02 -0700
Can someone point me to a good example on how to populate a table from a
recordset.
I have a stored procedure on an MS SQL Server that links tables tables
between an Oracle DB and the SQL db. Because of the size of the Oracle
tables, it's most efficient to EXEC sp_ExecuteSQL in the MS SQL Servers
sto ...
|
If Then Else - PLEASE HELP
Wed, 17 May 2006 03:37:02 -0700
Hi all
I have a db that is used to log work received by various clients and the
progress of each "job". Each job has a deadline time, deadline date and also
a priority. Based on the priority I want to automatically populate the
deadline time and deadline date fileds on the job form.
One client requir ...
|
How to use cursor in select statement ?
Wed, 10 May 2006 19:02:39 -0700
I have following statement.
SELECT inv.PARTNO, inv.DESC from INV where inv.partno = me.partno.value
I want to save this part no and desc so I can use it while inserting to the
table.
In SQL, I use INTO CURSOR XYZ and I can retreive my part number like this:
SELECT inv.PARTNO, inv.DESC from INV wher ...
|
convert Lab colour to RGB
Tue, 16 May 2006 10:24:02 -0700
Hi, I have the colour in CIE Lab coordinates and want to represent in a
control of a form. Exists a function or module to convert Lab to RGB
coordinates? thnaks david ...
|
Linking Oracle tables with primary index and another index
Fri, 12 May 2006 14:30:02 -0700
Hi,
I have created under Oracle 9i a table RIVERS containing fields RIVER and
DESCRIPTION. RIVER is used as primary key.
In order to avoid that a user could enter in the table two rivers with the
same name but written with a different case (Oracle is case sensitive) I've
created another index based on ...
|
Multiple Attachments
Thu, 11 May 2006 07:30:01 -0700
I am trying to 'sendobject' through Access with multiple attachments (both
queries formatted as xls). I only seem to be able to attach one object
though. Does anyone know how to attach multiple objects to one e-mail?
--
Cheers.
Paul ...
|
|
|
Substitution of variable contents in a command
Thu, 11 May 2006 05:51:02 -0700
Some languages allow you to force the interpreter to evaluate the contents of
a variable in a command before the command is executed. Is there a way to
do this in VBA. Here is an example.
The objective is to develop a common routine to apply a set of
transformation rules to the contents of a field in a ...
|
Can someone please help me ?
Mon, 8 May 2006 04:12:57 -0700
I am using VB.NET.
I just created a form where user enters information. Once information is
entered, user clicks ok button.
While updating the table, I am getting an error and it does not update. I
am using 2 tables, INVSHIP and PARTSQTY. Both have comon column called
part. Once it matches, I want to ...
|
Loosing modules behind forms
Tue, 9 May 2006 14:50:01 -0700
Databases in Access 2000 (originally created in 97). The modules behind the
forms seem to be gone.
I have created new DBs in Access 2000, turned off "Track name AutoCorrect
info" and imported the objects from the old version. During import I am
getting the message "Can not start transaction; too many tr ...
|
