Search results

I did this test, when i import the CSV file previously created, the values are showed ok. Only when i export in CSV are wrong, or better are visualized wrongly :unsure:

Yes, the code work fine but those values are always "wrong", i mean are written with "+". LCM IT T22_DN150X100_CL300 2.203E+12 LCM IT T22_DN50X40_CL300 2.203E+12 LCM IT T22_DN150X100_CL300 2.203E+12 Any other idea ? Cheers

Thank you. Does it work with CSV ? because i tried to add this code but to create CSV (instead of txt) but when it goes trough the loop is close immediatelly, probably because the file is empty. Any idea ? Cheers

Yes not possible to specify, i have only list of fields not possible to change any type.

I usually create specification when I import (with wizard) but how i can do when i export , i don't have even the possibility to save in CSV, only XLSX or similar and don't give me the possibility to choose the specification. Sorry don't know how to do it.

I work as CMMS of an Oil&Gas company so in general with all discipline, including Piping yes.

Surround the number with ' you mean in the query like : "'" & [Field] I tried and i got the same

Yes the number is there i can see it, however there is a team that take my CSV template and check the data in the file and they find duplications in this way so i need to also show as it is. I tried the 2 way suggested by arnelgp but in both cases i got the same. How to export as string ? By i...

In my table the field (Model Number) is a Short Text type not a number but it seams in the CSV is transformed in a number.

Good morning everyone. I'm actually use a simple function to export some data trough a selection query to a CSV File. The problem is that when i export the data from my table (trough query) in the CSV output file i have some values (long numbers) who change. See please below : This is part of...

Absolutely no. In the FE database, which is deployed, tables are linked to the BE which is one for all.

Thank you, absolutely yes, I do exactly like that exactly to avoid problems with different network drive letters setting. Usually I prepare the interface with linked table (using the structure \\servername\......) and than I locate it in a specific folder where the users will copy and paste in...

Apologies, when i mentioned "shared", i mean that i share with each of them a local FE DB. I understood that the "shared" word maybe is not the correct one.

Not recommended share FrontEnd database with user ? I suppose is the correct way to do having FE and BE for multiple users database. Cheers

Thank you for answer, yes i saw it but is not clear to me. It could be possible to get an example of reconnection in a small vba function? Thanks.

Good afternoon everyone. Having a FrontEnd MS Access DB (shared with users) with one linked ODBC Table (located in another separate database) I'm looking to a function who can reconnect that ODBC Table when the end user doesn't have any DSN. This because I would like to avoid to create a DSN on...

Yes absolutely, if I'm not wrong I mentioned in my ideal flow in another message, the replace (update) of the shadow table will be done as soon as after I sent e-mail (which means there are modification). Ok noted, in any cases I can manage if required in the future. Thank you, Cheers

You talking about the shadow Table ? if yes, this is "my copy" table from the linked one (i don't have access to BE Database of the linked table so i can't add any table).

OK noted, i will create the shadow table in my BE database and i will link it in the FE then i will clean and re-build (delete/append records) everyday. Yes i will add the same index I have in the Main Table (Project_ID) Yes the idea was to create a table where i have one field...

Actual size is 15000 Records I will send unique email to multiple recipient with one excel (or csv) file which include 2 fields: Project , Old Date and New Date. This file i will create based on the verification i do (with the check query).