Search results for query: *

Morning Todd I assume it will be morning when you read this I believe your in US near Detroit I'm in UK on East Coast so about 8 hours time difference, any way below is full code as it is at the moment, to cure the previous error 3265 I changed the name of the Primary ID in both acad and access...

Hi Todd Happy new year I have tried using a different primary key basically the drawing number in the title block and in the database but it does the same thing says record exists and then goes to the 1st record and puts a blank in the primary key and enters correct data in the remaining...

Hi Guys solved problem above but now it says record exists do you want to over write, answering yes it goes to the first record in the database and over writes the data apart from the primary key which it over writes with a blank entry tried several primary keys it does the same each time. Any...

Ive tried to implement Todd Carpenters FAQ for extracting data from drawings to Access but keep getting errors have posted code below: Database primary key is called filename drawing title block is called drawingtitle primary key is drawingID I keep getting error 3265 - item cannot be found in...

Thanks All Got it Working at last for Info in Access it is UCase also need the % wildcard to work correctly Thanks again Graham

Thanks D Your suggestion almost there two problems I have now are the % wildcard doesnt do anything it just attaches to the end of the text also it is case sensitive if I Remove the % wildcard from the code and enter the full text data it returns data otherwise gives error message Syntax error...

Hi Folks I need a query to return data from jobtable I have tried code below from FAQ area but then found out that ParamByName doesnt work with ADOquery How do I change this to Parameters or is there an easier way I have tried filering with pos but its case sensitive so I dont get all the data...

I have just noticed in the help file that a TADOQuery cant be used like this. Graham

Hi Opp Thanks for reply, yes I had missed the "Select" keyword in the SQL statement but it hasn't solved the problem, when it gets to the first parambyname it says "missing Operator or semicolon". The inputbox you mention I am not sure what you mean as I am fairly new to...

Hi Guys Am I missing something here I tried a query code from FAQ but I cannot get it to work the problem at present is when it gets to Parambyname it says missing operator or semicolon anybody with any ideas please. procedure TJobStatus.FormCreate(Sender: TObject); begin inherited...

Hi Leslie Thanks I have tried those FAQ's and can get whole rows to change colour but I have not worked out how to change specific cells. Graham

Hi All I am quite new to Delphi and finding my way round I have an MS Access database which I need to run on individual machines so I have started rewriting this in delphi. How do I limit the data displayed I have looked through help and can find no assistance on Queries what I have is a table...

Thanks D I will give that a try.

Hi I am new to Delphi and have a problem changing Table field names programmatically, checked the FAQ's etc found lots of useful info but not the answer to my problem. I have several MSAccess tables which I need to add a column to also I need to change some existing field names, the tables...