Search results

Hi Gemma, I've deployed your code, however I'm getting a type mismatch error in the following line of code Set rst = db.OpenRecordset("tblFiles", dbOpenDynaset) I've checked the field names and the data types for the following fields folder is set to text and will allow upto 255...

Hi James/Gemma, I've been also looking at the Allen Browne code which James pointed me to earlier to see if I can understand where I'm going wrong, It would appear I've gotten myself in a bit of a mess and so I'm going to start this part of my project from scatch using all the information and...

Hi Gemma, Thanks for that, could be part of my problem. still working on it. John

Hi Gemma, Thanks for the pointer. John

Hi James, I've tried your code, but I keep getting a Run-Time error 3048, can not open anymore databases! as I only have the one database open, I don't understand why I keep getting this error message. I'll do a search on the internet to see what I can find about this error message, but if...

Good morning Folks, Thank you all for your pointers and assistance, I'll let you know how I get on. This Forum rocks John

Hi James, Thanks for the pointer, I will have a look now. John

Hi James, The code works but only to one subfolder level, as there is another subfolder level within the subfolder, I need to be able to get down another level. I've been reading and searching stuff in this forum and the internet in general, but not having much luck in finding anything that...

Good afternoon, I have some help with an earlier post to do with obtaining the names of files in subfolders, however I've just discovered that there are to be subfolders for the subfolders from which I will need to extract file names! I'm at a loss of how to modify the below code to drill...

Thanks James, The pointer was a great help. John

Good morning folks, I have the code below which I obtain via this forum and modified to suit my needs and it works fine. However, I now have a need to go a step further with another aspect of my project and I need some help in modifying the code below to achieve this new requirement. Let me...

Hi Summer123, It would be a good idea to get some ground rules set up with your client, draw their attention to the benefits of meeting those rules which could be speed of processing, accuracy and quality of the data and the biggie, financial. Good luck John

Hi Summer123, The problem that exist is that if the person(s) that have supplied the data to you in the first instance are not consistently using a date format that you can work with, you are going to struggle to get the correct date out of that field. As Spikepl said in the above posts, if...

Hi, I export data to Excel and format the spreadsheet on a regular basis, below is an example of how I do this, this was achieved with help from the experts in this forum, so you could also do a search and find more information on how to do this. I also attached my spreadsheet to an email in...

Hi, Have you tried reading up on functions or search this forum for information on creating functions. Here's an example of an Array Function that might be of help or point you in the right direction from the help files in Access: Dim MyWeek, MyDay MyWeek = Array("Mon", "Tue", "Wed"...

Hi Splkepl, Thanks for that, it worked a treat. And Thank you MStef for your assistance as well, most helpful indeed. Most appreciated. John

Hi, Thanks for your response, I'll let you know how I get on. John

Hi, I have recently taken over a process that has been spreadsheet based for a number of years now, and I in the process of converting that process into Access 2000, because it will remove the hundreds of spreadsheets that have to be maintained daily. Importing the csv files into access has...

Hi, The following posts on this forum under VBA Modules may be of assistance to you: 03-23-2011 01:54 AM posted by ria arora 06-22-2007 06:35 AM posted by cpremo If do a search you may find others that have covered the subject of Compacting and repairing. John.

Hi, In short in the way that I have this code working, Yes you would. My process is based on the fact that I know the exact number of queries and that for the present they will never exceed that number and therefore I have created a process that specifically targets each one in turn and...