Search results

Hi, thank you. Can you please provide example - is needed. Best, Jacek

Hi, thank you. Can you please provide example - is needed. Best, Jacek

Ok, so assume that i have second table - t_junction. And in this t_junction i have JunctionID, UniqueID and Atribute. So i have to create relationship from UniqueID in t_OperatingSystems (1) to UniqueID in t_Junction (many) as TEXT fields? So join text fields? Thank you, Jacek

Thank you very much arnelgp. uniqueID should have index as unique? So constraint (1 to many) should be from uniqueID field (1) into second table (many) yes? Jacek

Hi, thanks. Yes i can export specification for each query manually and use it in macro. But i do not want to do this. I want to have full automation here. Maybe there is something like: application.fieldseparator .... Best, Jacek

Hi Guys, i have table which is imported from CSV. And i want to use uniqueIDs there for each OperatingSystem which i have there. But rows in CSV can be deleted or added or updated. How the process should look like and temp_table in Access? I should have autonumber Primary Key and additional...

Hi Guys, i want to export selected queries to separated csv files and do it via VBA. The problem is that my standard settings of Access are: And i have to always go to advance --> and change decimal symbol from ";" to "." and Field delimeter from ";" to ",". Is there any command to do...

hi Colin, thanks ! Sorry my tasks changed and i didnt have time for it yet :( I will investigate. Best, Jacek

o wow thank you very much! Working like a charm! Jacek

ok thank you, i tried with: SELECT TableSource.KeyName, TableSource_1.KeyName FROM TableSource, TableSource AS TableSource_1 WHERE (([TableSource_1].[DiskSize]>[TableSource].[DiskSize])); but it failed. Jacek

Hi Guys, i have table like here: So KeyName and DiskSize corresponding. And what i want is to get this table: So for keyName P6-64-Premium_SSD i have 3 keyNames which DiskSizes are bigger or equal: P6-64-Premium_SSD, P20-512-Premium_SSD, P30-1024-Premium_SSD. For P20-512-Premium_SSD we...

hi Colin, thank you vey much! And sorry for late answer, i am on road last time. I will investigate solution, is very helpful. Jacek

ok thank you very much. I tried to add one additional string columns with MD5 function: https://www.di-mgt.com.au/src/basMD5.bas.html but i can not use having count >1 in find duplicates query... this is your second menthod yes? Ok how can i create the last of each duplicate? How can i do...

Thank you Colin, yes i am using your method to avoide duplicates but before i didnt so i have duplicates already. ok but problem with this approach is that i have a lot of fields and index composite key can noe be applied for more than 10 fields yes? Jacek

Hi Guys, i created access built-in find duplicates query but i do not know how to delete from my primary table based on that table. Because in Find duplicates query are 2 records but i only should delete 1 of them. Can anybody help? To precise: I have main table with primary key. But in...

thank you Guys very much, Best, Jacek

Hi, i am trying to do in one query left join like here: as you can see it will work. Problem is that i have to match not only CustomerTopologyID but also ServerID with ServerIDFK in tblCustomerTopologyServers table. But when i am doing: i am getting error. Please help, Jacek

ok thank you very much for nice explanation. I will not close the topic because i have to rethink whole idea. Best, Jacek

thank you CJ_London. Hmm what do you think by lookup for specific row? you mean run insert into queries from link table to access temp Table? Where i can check which records where deleted or added? Jacek

Hi Guys, i have one big 16 fields table which is imported from csv without any primary key. How to standardize data? How the ideal process should look like (if i do not have PK in source files). I should have multiple tables and load them to access ? And check if records are deleted or...