Search results

once again thanks 4 the help and the tips, i will try to use the debuger as you said and let you know how it works. keep up this great work.

wayne wayne: the file is the same i'll put here a real sample that i had to process in excel. is the fact that the file is a .txt in ascii format anything to do with it??? I also have a excell macro that can process 65000 lines but each day goes by the original file gets 2000 to 10000 new...

This is the db after runing the code (the tables as no records, the code deleted all records). this is your original db, i just change the path of the file to import, run the code and it stops with that error.

wayne: the bd is deleting the records but then returns: "update without addnew or edit" and debugs " Case "Job Nu" rstJob!JobNumber = Trim(Mid(buf, 13))" But i dont think i need a browser funct. cause the file is allways on the same path and name. but i do need to import the file...

what i really needed was to do the separation of the log file into the tables, like you did. Like chosing the file to open (log.txt ) and import the data into those 2 tables. after that i only need to do a report. can you help me with these one too?? tks

try to use a form with a sub form linked access as a wizard for it. when you select a member of the staff it shows the details for thet id, got it? hope it helped.

there are a few questions a liked to ask: the tables have already all the data or are beeing fill when you open the form?? also i tryed to change this "Open "C:\Print.Log" For Input As #1" to "Open "C:\my location\my file.Log" For Input As #1" and nothing!!! Can you give me another hand here????

thanks a lot i'll see if i can reach the next step of evolution .... LOL.

yes i know but can tell me how its done???

cause i have a table with more than 1800000 records and i need to break it for a txt file

cause i have a table with more than 1800000 and i need to break it for a txt file

i want to run a querie to criate new tables every 200 records, how can this be done?

when entering in design mode there is a button with a key select the column and click the button then rename it.

i got very little this is for a report but the only thing i've got is the import table from the txt file (1840000 records) but i'll give a example db for you to play

i need to retrieve date; job number;job name;user;account for each job plus a job can have several files and for this files i need the plotted area value someting like this: task 2540 date 02-12-2004 job_name IT_CAT_050 User vitor Account: 9999999 Plotted Area: 3225 hope this is clear...

i have autonumber but i dont see how it helps, cause i have the test word in more then 600 records . what i need is a code to loop the records and see that record 1 is "test" then records until 57 are not, but record 58 is "test" after are not but i want it to give me a variable with all records...

i want to build a query that says: in the col "properties" return all records that are between the word test. 1st record reads "test" and 34th record reads "test". so i want it to return the first 34 records. i know there is a way but i just can't see it. any help....

hope i can explain this this is a printer log . what i need is to get users accounts and print areas to make a report. this report is a little confuse to me cause a print job start with +++++++ but it refers to several prints that are divided by -------- i have an excell macro to this but it...

i've been ask to think of some solution to this problem but i'm no way near of it. i have a txt file (ascii) with aprox. 1845000 lines. the code is something like this "++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Date: 02-12-2004 Time: 11:06:24 Job...