Search results for query: *

Thank you all for these. ON closer look is there anyway to turn off the Active X message that 'dwarfthrower' mentioned above?

Fantastic... Thabks for your help!

Hi Everyone, I have an unusual request. We run a Employee Satisfaction group in our company and we don't have any budget to create websites both on the Internet and our Intranet. So, we decided to create our own Web page (basically a HTML document) residing on the LAN common drive. We want to...

Hi Everyone, I have a Datagrid bound to an Access databse. This database consists of tabels whereby I could enter freeform text much like a memo function. I would like to simulate the DataGrid cell much like Excel where by you could perform a line break. When this is done, I would like the...

Hi, Is there an alternative to DataGrid control? Another control that allows me to display list much like a spreadsheet and allow for updates of certain cell. Preferrably, an alternative which is more reliable and easier to use than DataGrid. If you know of one, please let me know where I may...

Hi, I have a Datagrid bound to an ado control. The datagrid displays list a to do list whereby, the aim is for the user be able to update any columns and add new rows. Whilst I am able to update the column, when I move the cursor elsewhere on the same row, its is OK, but trying to exit from...

Sam63, Do you have the problem still? I have exactly the same message, although this time I am updating the table via a DataGrid connected to an ADO. As to Wilmead's reply above, which event would I put the Update query? Thanks and regards...

Hi, I have a DataGrid bound to an ADO. I want to be able to update the DataGrid and have it automatically update the DB and reflected on the screen. The ADO is set to CommandType = adCmdText, because I only want to display certain information from the DB. The Database also have a primary key...

Thanks for that. I knew it was something as simple as that, but just couldn't figure it out how? Thanks and regards...

Hi, I am interested in adding more columns to a DataGrid control at design time. Initially, when you add the datagrid control onto the form, only two cloumns appears, how do you increase the numnber of columns at the design stage? Thanks in advance...

Thanks again for your reply. The Convert Database Driver is 'pdsodbc.dll [ODBC]'. The report launches OK from the CR Designer, but not from VB. I've noted the following: (1) I have tried changing several of the drivers and ticked the 'Convert Database Driver on next refresh'. But everytime I...

Thanks for your reply Ken. (1) I have removed the 'Saved with data' option from the report. Actually, when I did this, the report did not launch from the VB application. While with 'Saved with data' the report could launch successfully. (2) I added a Crystal Report Control to the application...

Thanks for your reply Ken, The report is being excuted from VB, but the data extraction is being done through CR6. However, I did coded in an extra line prior to "printreport" as per below: EOMBy_Income_BandRPT.DataFiles(0) = "C:\My Documents\Database.mdb&quot...

Ken, I apologies for the brief details. I am new to VB and CR and is basically self-trained. I am using : * VB6.0 * Crystal Report 6.0 * Data connection is ADO. As per Marcus, I have : * Added a CR control in my form, the control is called EOMBy_Income_BandRPT. * ReportFileName was specified...

To Ken or Marcus, Unfortunately, I have exactly the same problem. I have tried the above Connect property and it still doesn't work. I am using the following command: EOMBy_Income_BandRPT.PrintReport However, I do not know what I should code exactly for the connect string. I am interested in...

Hi daimaou, The problem above is resolved. In my case, I decided to define a primary key to the table. Apparently, the datagrid gets confused as to which update I was doing. With a key, it was able to keep track of each update accordingly. Thanks for your assistance into this matter. Thanks...

Hi daimaou, Thanks for your prompt reply. The Recordsource I am using is adCmdTable. Initially I did use a SELECT * SQL, but found that it was not able to perform any updates. With adCmdTable, I could perform the updated, but get the 2 erraneous messages. As you had mentioned, with all the...

I have a simple MS Access 97 table bound through an ADO and Datagrid. The Datagrid display correctly the content of the table, but when it comes to updating existing cells, the following errors occurs: 1) The error message "Key Column information is insufficient or incorrect. Too many rows...

ndalli and deepa, Do you both have any further update to this problem. I have exactly the same message "incorrect of insufficient key column information.too many rows affected by update". I tried installing Microsoft Service Pack 3.0 for Visual Studio 6.0 and that didn't help...

May i have a copy of newsletter as well.<br><br><A HREF="mailto:dwong@zuelligpharma.com">dwong@zuelligpharma.com</A><br><br>Thanks a lot..<br>