Search results for query: *

Hallo, Is there a way to force ADO to use primary key while updating recordset? I use the Microsoft OLE DB Provider for ODBC and the server side cursor. In case of the client side cursor the case is simple: rs.Properties("Update Criteria") = adCriteriaKey and there is no problem...

Hello I have a problem with updating a recordset which is based on two tables joined with a double inner join. These tables have also double indexes (based on two fields). I receive an error message: "insufficient key column information for update or insert a row". I've set the...

is it possible to open drawings without opening the xrefs that have been attached to that drawing? Maybe there is some option in Autocad wich I'havent noticed or (even better) some way to do it programmaticaly (VB) I need only the layout to print it and I can do it whithout xrefs. Sometimes my...

Hallo, I want to call AutoCad from my VB program. Set acadApp = CreateObject("AutoCAD.Application") Everything works fine when I call it from an NT user account, but when I start my program from an admin account then AutoCad is opened as visible which I can't accept. Any ideas? Where...

Halo, can anyone tell me what to do if there is open more than one instance of an OLE Server application eg two instances of AutoCad and I want to get a reference to one of them, but not just anyone. I want to choose one of the instances. Using the Getobject function I will get a hook just to a...

Hallo, I'm a bit new AutoCAD. Maybe some of you can help me. I'm looking for way to save a dwg file as tiff using Autocad's API from an external application. Thanks for any help Jaco

Hello, I'm trying to print a TIFF image in the A3, landscape format. I've tried to use the ImgEdit control but it seems not to provide such a fuctionality. Any ideas? Thanks in advance. Jaco

I write an VB application using Pg as database server. When I add a new record to an empty ADO recordset an error occurs: "row value out of range". I use Keyset, ServerSide Cursor. It helps when I change cursor location to ClientSide but in that case it's impossible determine ID of...

Hello, I have a SQL statement which is based on two grouping subqueries which are defined and saved in an Access database. e.g. Select subquery1.SumOfSomefield, subquery2.SumOfSomefield, ..., form subquery1 inner join subquery2 on... My problem is that I need to pass criteria parameters to...

Hello, I have a SQL statement which is based on two grouping subqueries which are defined and saved in an Access database. e.g. Select subquery1.SumOfSomefield, subquery2.SumOfSomefield, ..., form subquery1 inner join subquery2 on... My problem is that I need to pass criteria parameters to...

Hello, I use CR with VB and Access database. I use VB's Dataenvironment and when I generate a raport based on a command returning about 30000 rows, with a RecordSelectionFormula filtering 1 row, it takes long time (like 8 - 10 seconds) to see it. I'm new to CR and I wonder if it's normal. Maybe...

Hello, does anyone have any idea how to apply filter by month. I have a combobox containing months and after selecting for example 'january' I would like to filter records and see only the records from January. In MS Access something like this works...

Hello, I have a recordset (based on Access database) which is a part of DataEnivironement. The LockType property is set to Optimistic but after requering it chnges to Read Only and I can't neiter update nor delete records!! I'm a bit new VB developer and I totaly don't understand why is it so...

Hello, I have to sum some fileds in a child recordset (I use DataEnvironment). Does anyone have any idea how to do it? The only idea I have is to create a separate command which wouldn't be a child command and to apply a filter (and of course to use aggregates option). Jaco

I have a datagrid sourced to a child recordset in the dataenvironment. How do I refer to data and add a new record to this child recordset? The child looks like an extra field in the parent recordset but I cant work out how to add a new record and fill it from code Regards, Jaco

I have a datagrid sourced to a child recordset in the dataenvironment. How do I refer to data and add a new record to this child recordset? The child looks like an extra field in the parent recordset but I cant work out how to add a new record and fill it from code Regards Jaco

Hello, I'm a beginner in VB, earlier I used to programm in Access. I have such a problem. I have two ADO recordsets based on the same query (so they contain the same data). When I make changes in one of the recordset and reqeury the second rs I don't se the changes I've made in the first rs...

Hello, I've recently changed Accescc to ver. 2000 and I have a strange problem. When I export text fields to Excel, strings in excel always begin with "'" character (ascii 39) e.g. string in Access table: "beer", the same string in excel (after export): "'beer&quot...

Hello, I've created a database that now has 13,000 records but I estimate that it may soon have even 30,000 or 40,000 records. Has enyone any experience with such a large Access databases? How will Access deal with such an amount of records? Best wishes Jaco

Hello, I'have to save an Outlook Express attachment form Access. Is there a way to do it? I know there is when it comes to "full" Microsoft Outlook. Thanks for any help Jacek, Poland