cb2 = CStr (me.cbo2.text) List of common misconceptions

No problem :) The need to optimize rises from a bad design.My articles[^]

No problem :) The need to optimize rises from a bad design.My articles[^]

Now this does make sense .... nice work around It worked fine (even the result data is not that much comprehensive) but it do the job, and save some extra lines of code ... great man, thanks alot :thumbsup: 0 will always beats the 1.

Could be any number of reasons. Such as - You are not using the same database - There are uncommitted records. - You are not running the code that you think you are - You are using some process to determine whether records and that process, not the number of records, is wrong.

Thaks eddy, i found that recordsets are read only by default ... and also are not modifiable if sql depends on two tables of one-to-many relation or invlove sumation of rows ... Also, if above conditions are not true, then a recordset to be modifiable, i think attribs should be set like: set st = db.openrecordset("SQL",2,0,3) or set st = db.openrecordset("SQL",adOpenDynamic,adUseNone, adLockOptimistic) 0 will always beats the 1.

I came across the same problem and I wrote up a little VBA code in ACCESS handle this. It is still in the beta phase and I am still pretty week in the code formating and documenting code, but the functionality is all there. So far it has the following features: - File Folder Scanning and Keyword Search - Batch excel file scanning - Semi-Automatic ACCESS database creater from EXCEL. - Data Viewer with column order, and sizing - ACCESS data filter - Export to excel based on the ACCESS data filter. Again it is in the beta phase. Email me at david.lario@ualberta.net if you want me to forward what I have to you. If there is enough interest I could try post the routine to the code project.

Thanks for your follow man, but seems that we r not on the same channel.. :confused: jschell wrote: You are putting the data some place - that is data source two. Putting data in some place , could be considered as Data Source ??? i dont know :doh: jschell wrote: 1. Get data - put it in a collection of some sort. 2. Write the data - by using the collection. U i tried to use 2 recordsets also didnt work, u mean that they should be done in two events ?? Any article?? any explanation ?? any examples ?? if you can provide .... most thanksfull :) 0 will always beats the 1.

me.combobox1.text giving he following error: You cannot reference a property or method for a control unless the control has the focus regards, 0 will always beats the 1.

You wrote: set classrecset1 = classdb1.OpenRecordset("select unit_price from contract_details where contract_number = ' " & a & " ' ") Nothing to say without seeing your table. Checkout "contract_number" is that string type or number. If Number type just remove the single quotes.

thanks aloooooot regards, 0 will always beats the 1.

You made v and c parameter of the query. DoCmd.RunSQL "insert into entities (Entity_Name,Entity_Location) values ('" & v & "', '" & c & "');" Cheers To other readers : Yes I know about SQL injection attacks If you can read this, you don't have Papyrus installed

for each record in X, the amount of numerical feild correspond to sum of records "not more than 900 record" in Z. ie: table Z has more than 900 records (unlimited), but the sum in X is limited to a max number of 900 in Z. Table Z is subjected to quireis, that accour not more than once a day. Regards, 0 will always beats the 1.

You're welcome. "When did ignorance become a point of view" - Dilbert

Thanks. 0 will always beats the 1.

No, I was referring to this website[^]. The third or fourth post down deal with how to do a repair installation of Windows using any XP-CD. If you don't have an XP-CD, you're out of luck. Cheers, Sebastian -- "If it was two men, the non-driver would have challenged the driver to simply crash through the gates. The macho image thing, you know." - Marc Clifton