Recent content by YariLei

Hmm, the sorting option worked, but only if I do the sorting every time for the source file. When the file gets updated, it is again setting the field type to Numeric, giving the same error again. I wouldn't want to be sorting it every day to get the link to work... I wonder if I could generate...

Hi, I have an excel file coming from a 3rd party supplier as a source. One of the fields in the excel contains serial numbers, which are in most cases just numbers but occasionally there are cells which begin with characters, followed by numbers. When I link the excel to Access (2016), the...

Amazing! That worked like a charm. I've been pouring over the internets for hours, but this little code did the trick. I actually removed the date out of the calculation completely and used ReadingID<T.ReadingID instead of Date<T.Date, because all subsequent ReadingIDs for one MachineID would...

Hello, I have an Access database which stores data pulled in by another program from several machines in several locations. The data contains a date of the data reading at random intervals (random, because occasionally the connection fails due to machine being offline), the ID of the machine...

Unfortunately indexing and primary keys resulted in empty tables. The only thing that actually worked was to make a small loop for the tables. First, it would add the new data to Total, leaving duplicates there. Then, it would create a list of unique rows (using the reading 1 as "max" or "first"...

Here you go, a sample of the queries attached. This is about 1/10 of the query series, actually the first 7 queries of the 76 that will continue after this. Currently the DB is indeed in just a single file, so I'll need to separate them. But if I did split it to have one access for the queries...

Thanks, I got it to work, but for some reason no new values are being added to the Indexed table. When I tried to put in non-duplicate values, the index allowed only about 440 entries into the new table, instead of the 1.2 million. Also, append query rejects all entries due to type conversion...

Well, that didn't work. The database is too large for Access to handle. Having Duplicates Not Allowed in the target table Index and using an Append query for the new import is too complex for Access. It tries to compare each field in each row and gets the query to about 1/3 and then just stops...

Hi, Thanks for the tip. That's a good way of getting a clean table with unique data only (pretty much the same way as using 'First' as criteria for creating a new table). I'm just worried on what to do with the original table after this. I could just make a VBA macro to delete the old table and...

Hi, I bounced into a big problem with Access 2010 where I cannot seem to be able to remove duplicates from a table containing millions of entries midway through a series of queries. The table is formed like this: Date - Serial Number - Reading 1 - Reading 2 - Reading 3 30.7.2013 - 1122334455...