Search results

Hi, Thanks for your response, I've been doing what you have suggested for a long time now and I really wanted to be able to do away with that manual process and come up with some coding that would do all the work for me. Perhaps it's not doable. Thanks anyway. Regards John

Good afternoon folks, I hoping someone can help me, I want to extract specific data from a text file and place it in my table. The following is an example of the data: Display Author="All Saints" Title="On & On" Genre="Pop" Color="7693971" Tag="2" I want to extract the following: Where...

Hi, I've googled as you suggested, came up with a lot of stuff to do with XML programming to parse text files, unfortunately I'm not that familiar with XML programming, nodes, tags etc a bit out of my depth to be honest. I'm only just starting to get some sort of handle on VB, but as you can...

Hi, Thanks for the tip, I'll have a look and let you know how I get on. Regards John

Good day, I hoping someone can help me out, I have some code that enables me to read a fixed width text files data into my database, which works fine, however I also have a text file which is not fixed width or of csv type which I want to read into my database, but I’m stuck on how to amend my...

Hi, From your posts it looks like you want to use access to search Excel Spreadsheets and that's it. Whilst you can link to a spreadsheet from Access, it's not just a matter of doing that and away you go. You can import you spreadsheets into access and you can update data in your...

Thank you for your response, but I'm not looking to delete the original file, that would be retained in it's original location, I'm looking to copy the file and then rename it in the same location. The problem I'm having is working out how to give the file the name of the folder in which the...

Good day folks, I hoping someone can help me with the following: I have a file structure that is created by a scanning system which I can not change, and what I want to do is to rename a tiff file that resides in the last folder in that structure with the name of that folder, there only ever...

Good day folks, I've searched the internet for VB/VBA code to convert Tiff Files to PDF Files with no success, there are loads of Converter software applications both free and payment, but unfortunately none of them give me what I need. I have a file structure that looks like this...

Hi, Thanks for that, I give that a go. Regards

Hi, Thanks for your response, commenting or removing the code was my initial thoughts, but I would still like to know that the folder the folder doesn't exist, because I can then investigate after the process has completed. Thanks again Regards

Good Morning Folks, I have this bit of code that if the file path does not exist it ends the process, but what I would like it to do is to not end the process but continue to the next record. If someone wouldn't mind looking at the code below and give any suggestions or pointers that would be...

Hi, As far as I'm aware you can't do that from within the active database, you need an external process to do that. Have you tried searching this forum to see if others have tried. Regards John

Hi, Normally the runtime files come with the developer version of the software, I'm not sure if the runtime files are available seperately, but have you tried searching the internet to see if the runtime files for your version of access is available serperately from the developer version...

Hi, There is a limit to the number of fields you can have in tables/queries which is 255, I've found that you can't in fact have 255 fields in a table or querie because Access starts to generate errore messages when it starts to get to 225 fields, it generates messages like "too many fields...

Hi Paul, I see where your coming from, and thinking about that I have another process in my database that imports the text file data that pertains to those tif image files and I import the image path along with it which I use when I am carrying out my QA checking of the data. I convert the...

Hi Paul [Pr2-Eagan, Thank you very much for your help, you code worked a treat. Your point on the time it would take is very important, I narrowed the search down a bit, by adding \01_Q at the end of the basePath to reduce the time taken to do the search and open the file. I think that...

Hi Pr2-Eagin, Thank you, your code made a difference. Having ran the code again, something does appear to have happen, but no results appeared. I was expecting the file to be opened once found, but this hasn't happen. To take a step back, after you supplied your code for the trailing...

Hi TJPoolman, I've deployed the code you supplied as follows: I created a new module and callled it mod_SearchQuesDir and copied the code named Public Function RecursiveDir into this module. I then created a button and called it cmdFindTifFile and in the on click event I put the code below...

Hi TJPoolman, Thank you for the pointer and of course the code, I've read a few posts on the internet on the subject, it's quite involved, I think I have a basic understanding of the subject, I'm still learning about such things. I'll deploy the code you kindly supplied and let you know how I...