Search results for query: *

Hi I am developing a programmed solution using a graphical front-end which will allow users with limited competence using Excel to interrogate the underlying data set. This is a learner spreadsheet (ed context) with 280 learners (rows), 40 subjects (cols) with 5 cols relating to personal data...

Hi I am prototyping VBA code to use in a wider app that I am building using Excel 2003. Trying to understand Find / findnext methods etc. However, with code below, how can I obtain the address in row, col format rather than traditional "A3" format for example in aCell.Address? many thanks in...

Hi I have a dataGrid control populated by way of an ado control. I have set arguments as shown to enable read / write access. I now want to validate grid cell data before it updates the field data in the underlying ado / access database. I have tried many permutations of using the 'click'...

Hi I had nearly exhausted all ways of connecting an ado recordset to an Excel 97 workbook for data processing. I then finally had success setting up a local PC ODBC Data Source. The ado recordset populates the ado recordset correctly and the Data Grid linked to the ado datasource displays the...

Hi I want to base a VB6 Data Report on an SQL Query which will retreive specific data from an Access 97 table. The context is 'Stock Control' and I have reduced the problem to the code below which will simply produce a stock list based upon stock search criteria (clearly at present all stock is...

Hi I may have erroneosuly put this in the VB Db Forum initially - sorry :-( I have successfully coded a sample application using VB6 for my students using two ADO recordsets. It is a straightforward 'Stock Management' context. The recordsets link to two respective MS Access 97 tables ('tblStock'...

Hi I have successfully coded a sample application using VB6 for my students using two ADO recordsets. It is a straightforward 'Stock Management' context. The recordsets link to two respective MS Access 97 tables ('tblStock' and 'tblStockAudit' using JET 3.5. Iteratively, the fields in the Stock...

Hi I am having difficulty displaying data in an MSChart control via an ADO recordset where the data is retreived iteratively using an ADO recordset connected to an Access database. The context is a student assessment database which stores "Surname", Attainment, Effort and Behaviour in a single...

Hi I am OK creating VB6 toolbar 'graphical buttons' using 'Insert Button Menu' Control on the VB Toolbar Active X Control. But having problems with 'sub' buttons created using 'Insert Button Menu' feature on the toolbar's Propert Page. The Style is '5-Dropdown' ie a drop list of menu buttons...

Hi Almost desperation here! I have tried unsuccessfully installing the 'Micrsoft Scripting Runtime' component in order to use File System Objects (FSO's)in my programming. I am aware via MSDN of issues (acknowledged by them) with this ocx so downloaded and installed latest VB6 service pack 6...

Hi I am having difficultly launching a file, in my case an MS Access file when selected using the Common Dialog Box object using source code below. Do I need to add additional source code to 'shell' the access application? Code samples are ideal for understanding how dialog is used to filter...