Search results

Thanks MajP, The table does look a lot like an excel spreadsheet at present. The DB was designed 15 years ago and was made with the best of my abilities at the time. Unfortunately, there are about 1 million records in there now, so it might be too late to change the table layout/format. I might...

Hi all, I need to add some data to a table using a form that has slightly different fields that need to be entered depending on who the data is for. It is used to enter data based on a particle size analysis and we have a lot of different screen sizes, not all of these are used for each...

Hi moke123, The process runs 24/7, when the instrument is running. It generates the .QAN file roughly every 90 seconds. Your process could work, I didn't think of it that way. All of the data generated by the instrument is stored in another database (unfortunately, this is proprietary and we...

HI Dave, Thanks for your input. I did try that years go when I first stumbled on it, without much success. The file is a bit weird, not really a text file, no delimiters etc. The import side of things works fine if there is only one file, but falls over if there is more than one.

I have attached an example file, but I had to change the extension, wouldn't let me upload as a .QAN file

Thanks a lot, it seems to work fine. Only issue is it is very slow, >5 minutes to import one file, but, this could be due to the fact that I am working remotely and my data is pretty slow.

Thanks a lot, I will give it a go and report back.

This is the full code and i have attached an example QAN file, had to rename it, wouldn't let me post a QAN file (the import part of the code works well, if there is only 1 file in the C:\Results folder): Private Sub Form_Timer() 'set timer to x milliseconds accordingly Dim fs As New...

At the moment, if there is more than one file the code falls over, (can't have more than 1 file called super.txt). The files are generated by an analytical instrument every 90 seconds or so. If all is working well, the generated .QAN file is renamed, the data is taken out of the file and the...

Thanks for the reply arnelgp. Unfortunately, all the files going into this folder will have the .QAN extension

Hi All, I have a module in my Access Database that looks for a text file in a folder, renames it (due to the weird extension the original file has .QAN) as a .TXT file, grabs the data and deletes the file. This is called on a timer, and usually works well. However, if the module falls over, the...

Hi All, I am not sure if this is possible, but here goes. I am making a split form which allows a user to "filter" records shown in a part of the form based on the criteria the user selects. What I want the user to be able to do is select about ten of the records (could be more or less) shown...

Thanks James, Didn't even think of that, much appreciated.

Hi All, Is there anyway that I can get access to "remember" values in a private sub routine after the sub routine has closed and use that value again once the sub routine is run the next time? My value might be say 14 after the sub routine is run the first time, so I would want to start at 15...

Hi Everyone, I was just wondering if there is a way to have an if statement that can determine if the number it is referencing is a multiple of another number? Like: If "my integer" = " a multiple of 10" THEN etc... can I write it as If "my integer" = 10 or 20 or 30 or 40 etc THEN... This...

Thanks Mailman, Worked perfectly. Thanks Zigzag. My project is a bit complicated. The form is unbound as it is makes a temporary table on running the code, then exports the temporary table to a CSV file, appends the data to the final table, then clears the controls ready for the next batch...

Hi All, I have been struggling with this for a while, and it might not be the best way to go about it. I have a form which is unbound, on the form I have 126 text boxes grouped in to sets of 3 each. The text boxes are named and are grouped as such: ID_1, CW_1 and IW_1 ID_2, CW_2 and IW_2 etc...

Thanks very much for the reply, I suppose a bit more detail would be helpful. The data in the table will be used for combustion analysis in a laboratory. We process between 500-1000 samples a day and this stage is trying to automate some of the process. The table I referred to originally is...

Hi All, I have a bit of a general query and I am hoping someone may be able to help out. I have a table and currently it has 5 fields, one of which is a nine digit number, unique for each record, which is used as a barcode identifier. The Barcode field, ID, links this to a few other tables, so...

Thanks Mailman, I can get that to work easily enough with an append query. I run into a problem when the data in the file is a negative number (our CV files can't have -ve values, hence the public function to prevent this). I tried the ABS function, but I would prefer the code to look at each...