Recent content by spectrolab

Apologies to all on the delay in getting back to this The there are 2 buttons on the form, one adds records to one table based on the following code: Private Sub LogSam_Click() Select Case Me.CustomerID Case 9 Select Case Left(Me.SamPre, 1) Case "D" Call...

Hi DB Guy, The form is unbound. Shows blank fields on opening. There is a button to add the records to the table.

Hi all, I have a form that adds records into a table based on the fields in the form. It then calls for a few append queries to add these records to other tables based on check boxes on the form, i.e, if this box is checked, run this append query etc. It all works fines and has been ok for many...

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...