Recent content by KirkJewell

I only use the dataenvironment for developing purposes, ie view the data whilst in Vb. I set up recordsets which point to the tables in the database. dim rs as new recordset set rs = rsStaff.recordset.clone ' In this example rsStaff is a recordset already connected to a table in my database...

This seems like a basic problem to me - I don't understand why I haven't come across it before. Using ADO.find = "StaffName = '" & string & "'" works fine for a string that doesn't have an "'" in it. But the StaffName column include names like "John...

Thanks

To connect to an Access Database using ADO you have to do one of the following:- ((Firstly get a book on ADO2.5 (and makes sure you have that version at least).)) Either connect manualy (vbcode). I haven't got the time and energy to go into detail. I would get a book 'SAMS Teach yourself...

Can anyone help - I want to open a Standard VB.EXE from a Standard VB.exe and get a handle to its public properties and methods. Do I have to use the Windows API? or is there a simpler way. Regards Kirks

I have a StartTime and EndTime and I need to know the difference in hours (preferable 6 1/2 hours as 6.5

I have several Ado controls on a couple of forms each attached to different tables in an Access2000(jet40) database. All work except one. I get a object not set error. When I run the app everthing works fine except this one which appears as though disabled on the forms. (I have tried this on two...

The SP4 update may help, but if possible you should upgrade your Access 97 database to 2000. And if possible drop DAO and work with just ADO. What version of VB are you using? I have the Enterprise Edition which definately includes Jet4 (jet4 is the standard for Access 2000). I also had...

I had written a little conversion function to do the above (what a pain - I assume microsoft had now easy solution for UK dates or VB and VBA would handle them better). I couldn't work out why my date filters didnt work and spent some time pulling (my already sparse) hair out. Thanks for the...

Or if you want 10 forms in an array try:- dim frm(10) as form set frm(0) = new form1 set frm(1) = new form1 set frm(2) = new form1 set frm(9) = new form1 each form is then accessable using:- frm(3)!UserName = "John Smith" frm(3)!UserTel = "020282828282" frm(3).show etc...

I can't believe you have a single form with over 250 fields on it. You really should be looking at which fields could be grouped onto subforms (use an sstab control), Or even better forms which are loaded on request. With so many fields (I assume derived from a single table) can your problem...

I am using an MSHFlexGrid control to display (as you would expect) A simple Parent-Child Relationship. There are several staff payslips (parent) with multiple payslip items attached. So far I have it working fine, it displays the right data and fields and formats well, however I would like it...

Aha! It works (Thankyou). However it changes the color of everything (in the test I did, I demonic shades of red) including the windows desktop (I guess thats what I asked for). Whilst it is not what I'm looking for - its a very interesting effect and I have learnt more about the API and API...

Thanks for the tip but you can't change the application window or child window colours (i.e. the button faces and windows surrounds) You always run the risk of a general windows system colour clash with custom colours on a form. I have also found out how to change the application colours when...

Thanks. I managed to suss the SetWindowLong myself (I learnt about the API View at the same time). Unfortunately my girl says its time I 'stopped playing ' on my computers (sheesh!) and paid her some attention. I shall make the changes to the handle declaration and check my SetWindowLong...