Data Environment Designer -
I have the following : Access database with a number of tables, Data Environment Designer, with 1 Connection, and a command (for the first table), as well as a child command object (for the second table - has a foreign key to the first).
I also have 2 datagrids, for displaying the contents of the recordset.
The first datagrid displays the names of people in the first table, while the second grid, displays contact info for whatever record is selected in the first grid.
The user must be able to update both tables via the grid controls.
I can add new records to both grids, but my problem is the actual Requerying / Refreshing / Rebinding:
FOr a related (new) record in the first grid, a Contact Details record cannot be added to the second grid, until the recordset has been requeried, and the first grid rebinded. This I can understand, but what is inexplicable, is that the moment I rebind, after requering the recordset, my 2 grid controls do not allow adding of new records anymore!!!
I have tested the AllowAddNew property to be true, and all other properties seem as before. (when I could still add new records)
I have found that the only "proper" way to therefore update a new record is to actually end the application, and restart!!!!!. Can somebody please help me here - I must be missing something obvious.
environment designer -
I've got a general question for those who use ADO -
I know VB 5 pretty thoroughly and, like everyone else I avoid the data control like the plague and do all d/b work in code. Now I'm learning VB 6 I would like to know if people use the data environment designer to manage connection
Changing the SQL statement in the Data Environment Designer Dynamically -
Hullo...
I'm trying to, well no, sorry, I *have* connected my database to my VB program via the data environment designer, and also a secondary link via the ADO...
Using the ADO I can dynamically change the data shown using:
frmMain.dbaccess_controls.RecordSource = ("SELE
Data Environment Designer and .Net -
Can anyone tell me if the Data Environment Designer is in Visual Basic .Net.
Parameterised querry -
I am ecountering probelm with database connectivity.
1. I am using Access database and want to extract data from database using filtered command in the sql. I am getting error message that provider is encountered with some error. When I remove the filter condition I am getting the res
Runtime data source attachment in Data environment designer -
When using the Data environment designer, the Data Source and the Initial catalog properties on the connection have to be set each time and the ActiveX has to be built and this should be done for each computer if they have to be used as different servers.
Is there a way to avoid t
How to create groups in Data report without Data Environment -
Hi everybody,
I am trying to use the Data Report Designer to print reports, without using a data environment using :
SET Me.Datasource = ADODBRecordset
I have succeeded in printing a simple report that just lists out the rows in a table. But I couldn't create a grouping. Is that
Using the Microsoft data Report -
Does anyone know if it's possible to use the Microsoft Data Report without using the Data Environment Designer? What's the code for assigning the database and recordset to the data report, and where is the documentation? All my documentation for the data report i
Using the Microsoft Data Report... -
Does anyone know if it's possible to use the Microsoft Data Report without using the Data Environment Designer?
What's the code for assigning the database and recordset to the data report, and where is the documentation? All my documentation for the data report involves a data environm
Data Environment Relationships -
HI - I'm using a Data Environment Command to retrieve data from an Acc97 db. My problem is that the query designer in the Data Environment can't recognize my Acc97 table relationships? I cannot use the database diagram tools supplied in Vb because they only work on SQL db's? I use t
Where did my Date Environment Designer go -
I have used the Date Environment Designer in the past and I just went to add it to a project and I can find it. The 2 ways I have added in the past are Right Clicking on the project in the Project Explorer and then choosing it from the Add popup menu and by clicking View and choosing A
HELP - problem with data reports -
Hello All
I am using vb6 and have created data report using data environment designer.
But report is being generated only for the first record in the table.
I want to know HOW TO RUN A QUERY IN THE DATA ENVIRONMENT AT RUN TIME - SO THAT THE VALUE DISPLAYED ARE THE ONLY ONE TO
Connection path in data report designer -
Hi,
I'm designing reports in VB using data report designer.
For connection in data environment designer, I'm specifying the path via "Data Link properties window" (By specifying provider and database location). However, this becomes a fixed path. I mean, after gene
'find record' code for Data Environment Designer -
How do I write a 'find record' code for Data Environment Designer that can detect whether the user has find the specific record. If the user entered an invalid record, the system will prompt him.
Querying Dates in the Data Environment -
This seems strange to me but I am sure there is something I am missing. When I enter an sql date crteria, like > 8/1/02, in the designer, it converts it to { d '2002-08-01' }. The tables are Access and they dont like this format. The designer wont accept > #8/1/02#. What am I doi
DataReport ---Using ADO objects -
Do i need to have Data Environment Designer in order to create a Data Report?
I have a stored procedure and would like to incorporate into Data Report using ADO objects(and not Data Environment).
Could someone please help me in this regards.
Thanks
Access Parameter Views -
I am using an Access 97 db for a backend and accessing it through vb using an OLE Db for ODBC with the Data Environment designer. If I add a command that is a view from my backend it works fine unless the Access view has parameters? How do I create a command with the Data Environment
Data environment and ADO -
I have used the data environment designer to create connections to two Access databases Connection1 and Connection2.
How do I reference or join tables from both connections in a query?
In Access this is very simply done by creating a link.
Data Environment Designer Naming parameters -
I am reasonably new to using the data environment designer. I would like to know about some of the differences depending on the data source. I have noticed if I connect to a ms access database I can name my parameters in the sql satement like @AcademicYear or @inDate. This is especiall
Data Environment Books/Tutorials -
Does anyone know of any good books/teaching materials on effective use of the data environment with a focus on effectively using the Data Reports Designer. Most of the people I have spoke to have said the Reports are only any good for tabular lists. Have any of you been able to get any
Database Programming... -
What do you guys think about using the 'Data Environment Designer'? Usually I do my database programming in code but I'm starting a new project and was wondering what you guys thought of the 'Data Environment' before I waste a bunch of time learning to use it.
Printing Vb Data reports! -
Hi all,
I am trying to create a printing faciclity for an application that I have written that links, though ADO to a DB. The only practical way of priniting a report seems to be through the data report designer, however this only links to a data environment.
I can retrieve the d
Server side cursors & Data Environment -
Does anyone know why when using the Data Environment
Designer with server side cursors, it returns a blank
recordset? The ADO data control works fine with it's
cursors set to the server.
Am I missing a reference?
Data Environment Gone -
I encountered problem using my VB6... before the data environment is running including the data report.... but when i re-installed my vb6... it doesnt allow me to use the data environment, the msg. shows....
"License information for this component not found."
How can th
Data Environment - HELP! -
Howdy!
Is it possible to create a Data Environment through code and then connect a data report to it? If so, How?
Because,I have a Data environment with a report connected to it.
But, I need to change the SQL statement in the Data environment during run-time! - That is my goal!
Problem in page footer -
i am new to report design in vb6.i am working in report designer & data environment.i want my report to show sum of some data on each page.i looked for ways in page footer section of the report designer but failed.Any help is appreciated!!
Error in Data Environment -
When I try to open a Data Environment in my VB6.0,it gives an error which is
“Class not registered
Looking for object with CLSID:{3D5C6BF2-69A3-11D0-B393-00A0C9055D8E}”
And does not seem to allow me to create or view or run a data environment
But the strange thing is that th
Data Environment 1.0 -
Ok, I dounloaded SP5 and SP6 and found the Data Environment 1.0 (SP4), checked the box for the Data Environment 1.0 in References, but I still do not get the Add Data Environment choice from the Menu! What gives?
Dat Environment Vs ADO -
I am currently writing an application using ADO. I have wriiten most of the functions required now and just about to begin validation procedures but before I proceed any further with app, I was told by one of my lecturers at college about an alternative method of connecting to database
Speed up Data Environment Connection -
So I'm using a Data Environment to populate controls on my forms, and I've noticed that it can take quite a while to load the form on each machine. It's much faster if I use an ADODC, but it's not nearly as convenient when I have multiple tables and joins on a single form.
My quest
DED w/ dBase IV and concurent Legacy Users -
I am trying to write and application that will access Dbase IV files at the same time dBase IV users are using the databases.
Using a DAO control I can accomplish this but then I can't use the report Designer.
If I go Into the Data Environment Designer I can connect to the Databa
Need to limit a report by date -
Hi.
I’m using the Data Report Designer connected to a JET 4.0 MS database via the Data Environment designer. I need the report to show only the records for a specific date range that the user picks. I have a date’s field in the Table named InDate. Do I limit this in the SQL qu
Data environment question -
I have a data report attatched to a data environment to display the contents of an access table. I have established the connection to the database in the data environment using its properties option. My problem is that the datareport does not dynamically display the report. ie.. If i h
VB6.0 Report Designer - Updating -
I am using VB6.0 Report Designer to display reports. When I run up the report first time, it displays the correct information, but if the information is modified in the table and then the report is viewed again, it only displays the original information and not the current information.
Data Designer: VB6 Pro -
The MSDN does not tell me which features belong to which versions. I am using VB6 Pro. I want to modify a table in my database.
The data designer icon is always greyed out. I can not find the Data Diagram Folder which the MSDN tells me to right click.
Are the designer &
multiple data report title in data report designer.... -
hello there, I'm working on a project that is using the Data Environment and the Data Report Designer to create reports. I've stumbled my way through setting up some reports but I'm having trouble with report title.
How can I make 2 report title in the insert control in vb? Is ther
add data environment -
In visual basic 6.0 when i press project, then components then click on the designers tab, the option of adding a data environment is not there.
Does any body know how i can add a data environment?
SQL in Data Environment -
Can anyone help me with this sql syntax. I am using the Data Environment query designer. I can execute it in Access with the following syntax.
SELECT IIf([wo1] Is Null,"O",[wo1]) AS Descr, Count(IIf([wo1] Is Null,"O",[wo1])) AS [counter]
FROM dbo_v_workorder
Data Report W/O Data Environment -
I was newly introduced with Data Report creation through the use of Data Environment.
How can I do this without using Data Environment? You know, just plain coding... Links for tutorials would be fine.
I am using an MS Access DB. Thanks guys!
ActiveX Designer -
Has anyone ever created an ActiveX Designer that could be used from the VB environment?
I can't seem to find any documentation on the web. MSDN talks about the interfaces that need to be implemented, but that is pretty much the scope of their documentation.
If you have any info
advice about use of data environment for hierarchical felxgrid / recordset -
I was just wondering if i could have the advice of some developers on the use of the data environment to create hierarchical flexgrids from recordsets.
I was told to stay well clear of the data environment, but while i was toying with it i found i could get the Shape sql string, th