Search results

Thank you CJ_London, i am attaching test database. Can you please show me 2 methods? With 2 queries and one query?

Hmm this is very strange: i am getting error here but some of relationships have number 2, some 3. I do not know why. Whe i have situation like here: it is working but adding topologyId will throw an error as above. Maybe i will upload example database ? Best, Jacek

ok thank you once again! yes because i am getting string names... DONE DONE and this i am not understanding. Can you explain more? Best, Jacek

thank you very much Galaxiom but it didnt work, i have still error: Please help, Jacek

thank you arnelgp. I have unfortunately this table because this is the part of bigger model. And i have to somehow join it to my tempTable and question is about approach, will you do the same or write it in one query somehow? How to do this via wizard? Jacek

Hi Guys, i have to get CustomerTopologyID based on Temptable: I can not simple create joins like here because i have: generally i am breaking this query into 2 steps: first where i am getting CutomerID and TopologyID, and in second query i am left join it to CustomerTopology table to get...

thank you Guys very much. sxschech - your method is ok but this is workaround with opening recordset - Access has native methods so i want to use them as much as i can. Looping through recordset can be slow. Pat Hartman -o nice, good to know. i can not post database because of fragile data...

Anyone please help, Jacek

Ok thank you. I am still confused. I created specCSV from one query. And saved it manually. And now i can change path and save into another file with your function. But how can i pass query which i want to export? I have qery "qryTest" and specifiction is "specCSV" for it. Now i want to...

Can anybody confirm please? Jacek

One more thing. in youe function arnelgp you can import any other file which you want. I tested and it is working. I created SpecCSV spec which is importing data and it is working. But what about export? I want to export few queries with the same spec. How can i provide them into function...

I can handle it. But this is ok with importing CSV table to OperatingSystems from CSV? In set up like in example? So createg FK from UniqueID text field? Jacek

thank you arnelgp, ok great i will use it

Ok i tried with this one: DoCmd.TransferText transferType:=acExportDelim, TableName:="ExportEnvironments", SpecificationName:="SpecCSV", fileName:="C:\Users\admin\Desktop\Newest Pull request\SpecCSV.csv", hasfieldnames:=True but i am getting error so SpecCSV has to manually created for EACH...

I know only old method, i do not know new one. Thanks Guys. I will test this one: DoCmd.TransferText transferType:=acExportDelim, TableName:="Table1", SpecificationName:="Table1Spec", fileName:="C://path/table1.csv", hasfieldnames:=True but first i will create manually specs. I am on polish...

TestTable lets say it is a junction table. Why the knowledge if this is a master data is important? I am adding example and please help me to set up this correctly. ImportedCSVtemp is table when i will be importing data from CSV. So updated,deleted or updated rows will be in...

Ok, why just not use DoCmd.transporText to do this? DoCmd.TransferText transferType:=acExportDelim, TableName:="Table1", SpecificationName:="Table1Spec", fileName:="C://path/table1.csv", hasfieldnames:=True and use variables for properties? Jacek

In other words -> Can i use text field - UniqueID as foreign Key? It will be something like here: Best, Jacek

thank you very much sxschech for help and support. Best Wishes, Jacek

Thank you Guys very much! Hmm the code seems to be complicated and i think i will use saved spec. Can i run macro only on selected queries? Best, Jacek