Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: h4fod
  • Order by date
  1. h4fod

    Excel VBA User Form - Dealing with multiple user selections in code

    Hi Thanks for your reply. The spreadheet data set - which yes, is a flat file un normalised databased is output from a large MIS (which unfornately hasnt got this user friendly GUIwhich facilitates executive level analyses. So, rather than importing this data set Excel / CSV etc)into MS...
  2. h4fod

    Excel VBA User Form - Dealing with multiple user selections in code

    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...
  3. h4fod

    range.Find method - found address in r, c format as opposed to "A4" , say

    Hi Many thanks for your post which addresses my query exactly. Mike
  4. h4fod

    range.Find method - found address in r, c format as opposed to "A4" , say

    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...
  5. h4fod

    VB6 Data Grid - Cell Data Validation technique unclear

    Yes, see what you mean. Thanks for the last post - have now modified my code. Will try ado solution on the weekend and follow up. Thanks again
  6. h4fod

    VB6 Data Grid - Cell Data Validation technique unclear

    Hi Thanks, noted. Before I received your post I extended the if constructs as follows using Colums(index) as shown and this seems to work. Validation warning message helpful to user to constrain input values. Private Sub DataGridRewards_BeforeColUpdate(ByVal ColIndex As Integer, OldValue As...
  7. h4fod

    VB6 Data Grid - Cell Data Validation technique unclear

    Hi Eureka! Yes its clear now - and works as I wanted it to. Looking at one the arguments of the data grid BeforeColUpdate, namely 'Oldvalue'it should have been more apparent to me. So, many thaks indeed for your helpful responses. In the next week or so I shall experiment with the ado solution...
  8. h4fod

    VB6 Data Grid - Cell Data Validation technique unclear

    Hi I note from your last post that the focus is on programming the ado recordset object. Since I am looking (at the moment anyway) on programming the dataGrid object, is there any way that this can be achieved or I will need the ado workaround - your last post. If so, despite your last post...
  9. h4fod

    VB6 Data Grid - Cell Data Validation technique unclear

    Hi Thanks for post. Been trying for some time now to get a solution using your first suggestion. Code for event as follows. Basically, I assume that if the modified field value is out of range, the cell value would be returned to its 'original' value. However, I cannot seem to trap the...
  10. h4fod

    VB6 Data Grid - Cell Data Validation technique unclear

    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'...
  11. h4fod

    VB6 ADO-Excel 97- Data Grid linked to ado appears 'Read Only'?

    Hi Andy Tab problem solved! Many thanks again. Mike
  12. h4fod

    VB6 ADO-Excel 97- Data Grid linked to ado appears 'Read Only'?

    Hi again Thanks for enlightening me on this topic. You are a 'star'. will now continue to develop my solution! Incidentaly, on an 'aside' since I have several grids (same context), each will show 'maths' Science' and 'english' data sets respectively each based upon a corresponding worksheet in...
  13. h4fod

    VB6 ADO-Excel 97- Data Grid linked to ado appears 'Read Only'?

    Hi Your solution worked fine using an ADO object on the form and the connection string suggested. I can now edit data in the Data Grid and the changes are written to the Excel File - data linked. Grid cell editing on the KeyDown event is a cool addition too! Presumably this (implied) can be...
  14. h4fod

    VB6 ADO-Excel 97- Data Grid linked to ado appears 'Read Only'?

    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...
  15. h4fod

    ADO Recordset - Data Grid Results Update - Blank Grid

    Thank you for resply. have noted point '2' in my coding. Can you advise how I can ensure (declare) objects of this type so they are never 'out of scope'. many thanks again
  16. h4fod

    VB6 Data Report Issue using the Data Environment and SQL

    Hi Andy Perhaps my confusion stems from the fact that I am a 'beginner' in relation to the use of Data Reports and the Data Environment. Given the command below, the Data Environment1 object is a command in the Data Environment and strSQL acts as a 'filter' which returns records from the Stock...
  17. h4fod

    VB6 Data Report Issue using the Data Environment and SQL

    Hi Now checked / re checked code, created global variable as well. Created a new command 'AllStock' as part of Data Environment. Private Sub cmdPrint_Click() Dim strSQL As String g_strAllStock = "SELECT * FROM tblStock" DataEnvironment1.AllStock g_strAllStock End Sub g_strAllStock contains...
  18. h4fod

    VB6 Data Report Issue using the Data Environment and SQL

    Hi See your confusion - sorry!. 'DataEnvironment1.Pupils strSQL' should read 'DataEnvironment1.Stock strSQL'. Trying to resolve problem with another dB! There is a data Environment command called Stock' in DataEnvironment1 and against this 'tree' in the design Environment all the fields...
  19. h4fod

    VB6 Data Report Issue using the Data Environment and SQL

    Hi The answer is no to the question. What code would I need to put in the data Environment1 subroutine suggested? Many thanks for your resply
  20. h4fod

    VB6 Data Report Issue using the Data Environment and SQL

    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...

Part and Inventory Search

Back
Top