Recent content by hbez

Many thkx for the reply, however, I use qry1 to populate a dbgrid from table1, I then need an extra (lookup) field to qry1 that will get its data from Table2 and display it as a dropdown box in a cell of the dbgrid. Hope my explanation makes sense? Hannes

I have an ADOQuery qry1 which gets its ConnectionString programmatically. I need to add a Lookup field but, when I double-click the query, Delphi (7) complains there is no ConnectionString. So I need to code in the new field. I get as far as - I hope that's correct - <code>...

Tried EraseValue, same problem. This is on Win7 64bit. Will check it out on XP today. Hannes

Thank you all, I'm not going to redesign the wheel. Will look out for an affordable commercial solution. Hannes

I successfully create a new key and write a value to it. I cannot get to delete the values or the key itself. My code is <code> with TRegistry.Create do try Val := TStringList.Create; RootKey := HKEY_LOCAL_MACHINE; if OpenKey('SOFTWARE\VotAfr\', True) then begin...

Many thanks for the replies. Steve, that's exactly what I'm playing with, something I did once way back with QuickBasic (so how old am I) where it was easy as pie, not that I'm capable of baking one. Haven't thought of cracking it by using compare, tho I suppose one could involve the registry or...

I'm playing around with copy-protection and want to try the following: Assuming I have an application MyApp.exe with a variable assigned the value of "ABCDE' somewhere inside the executable. How can I locate where this value is written in the file? Then, how can I write a new (same size) value...

Back onto my favourite nemesis -- displaying updated data in a DBGrid immediately after inserting data into an Access DB from an Edit box or other non-db aware object. I have an Access db with one table (City) andone text field (City). The form has a DBGrid, one Edit box, ADOCommand, ADOTable...

I have in fact tried two different ADOConnections as well as two different ADOQuerys. Eventually I left the connection to the 'remote' (different directory, it may be on a server) db as is and moved the 'local' db to the folder where the executable resides. Using ExtractFilePath(Application.exe)...

Dunno if its of any help but, what I do if I have a problem seeing a variable value, I display the value in a temporary label or edt box on the form. Hannes

With a DBGrid, ADOConnection, ADOQuery and two buttons, my code is procedure TForm1.btnDB1Click(Sender: TObject); begin qryDB1.Active := False; //DB1 is in a sub-folder conStr1.ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0;' + 'Data...

I am experiencing two frustrating problems with an ADOQuery: 1) QRY1 uses a ConnectionString to Access db1. QRY2 must use a ConnectionString to another Access db2 in a different folder. However, QRY2 keeps telling me it cannot find db2 in the folder where db1 is located. To at least make the...

I am experiencing two frustrating problems with an ADOQuery: 1) QRY1 uses a ConnectionString to Access db1. QRY2 must use a ConnectionString to another Access db2 in a different folder. However, QRY2 keeps telling me it cannot find db2 in the folder where db1 is located. To at least make the...

Thank you Steve, why does one always want to choose the complicated way of doing things! :)

Could someone please show me how to close my application if there has been no user input for a specified period of time? I want my program to terminate if the user did not click a key for say 10 minutes. I'm guessing I will need to use a TTimer so I can specify the time, together with...