Recent content by uniq_usr

Unfortunately No. The link I posted is for a excel macro. I need to do the same to my excel file from within access (using vba). Not getting anywhere with that.

Method for saving excel file to csv with both , and "" as delimiter. https://gist.github.com/fabriceleal/7803969 Couldnt post link in my earlier comment because of low comment count

As i have been doing all the manipulating with an open instance of excel in the background. I found it a bit of extra stretch on memory to again go through the whole file and write a txt file. The code i wrote above works perfectly except for the " " part. If I manually add character infront...

I find it easier to manipulate data to different cells as required using appExcel.application and .Activecell.offset. I also define cell names in the templates so I can easily focus where to start the writing from. Thank you for your direction so far and I have been able to save it as csv, for...

The template, as far as I can see, will not be changed via access. It will be a csv file with headers written into it and I want to write into the file then save a copy as filename_timestamp. This leaves the original template intact (This is what I have been doing with excel) The user will be in...

Hello All, I have question as to the approach I should take regarding a problem I have. I have a template csv file which has comes with headers. I now need to export multiple datas from my different tables into the csv file. I thought I would open an instance of excel, open the query as...

I have the authority to change the structure of back end so I can certainly institutionalize a unique dB number for each backend database. Should I create a tdbID table with one field in each database just storing the unique database key (long-number) and every table in the database will have...

Thnak you for the significant insight. The idea of tracking the master id in each user back end is a very good idea but I will have to convince my company of sending data back to user each way. The way it works now is they send us a copy of data and we only send them newer copies of front and/or...

Hello everyone, I have already posted a question before the introduction :D but wanted to introduce myself in this friendly forum. I have recently graduated from uni and in my first job out of uni. I am working on upgrading a half built access app for a company and found lot of helpful...

Sorry, I think I mislead you into thinking there are different backend. All the databases for different users have exact same structure. Only the data in them is different. I really like the idea of marking each record as being sent and if I make that field a boolean and indexable, I think I...

I do have access to backend but there are multiple (around 100) copies of it out there at the moment. The data once entered for the day aren't usually changed much. For the sake of easier implementation at this stage, I can assume that the existing data wont be updated. I am thinking of creating...

Hello Everyone, the forum has helped me countless times and I am finally posting my own question. I have started working on an existing MS access application (Front-end & Back-end) built with VBA. The frontend linked to a back-end access database which contains only tables. Because of the...