Recent content by BradleyS

Sorry I have been away for a few days This works great now! Thanks for all your help! :)

Hi everybody, I have a little issue here! One Column in my table has multiple entries of the same data I have built a query called "QryForm" using the table column and added it to my form as a combo box called "CboForm" But when I open the combo box it displays all the duplicate entries, is...

Hi That works fine. However, I can't copy the folder so I changed it to "CopyFile". But the Folder must exist for it to copy the files, so I wrote in "CreateFolder" in the same way. That worked great! But if you execute it again it brings up an error because the folder already exists. I...

Also how do I get my CmdButton on the form to run the Module

Hi OK I understand now, yes that looks good. But it's opening the xcopy window, then it closes and pops up the finished message. But it doesnt run the copy commend line, nothing has been copied

I'm sorry I can't get to grips with this! I can open an application, but I want to be able to create a folder and copy files from one location to another and I don't know how to write this in VB code.

Hi I will give it a go, but it looks a lot of work for someone who hasn't got hardly any knowledge of VB. Its funny how a simple DOS command like xcopy can be so complicated in VB, I thought it would be easier not harder.

Hi Could anybody tell me how I can get this code into a VB Script xcopy P:\DATA.* C:\Database_Search /i /f /y Basically when the CmdButton is clicked it copies all the “DATA” files from P:\ to the folder C:\Database_Search. Additionally, if the destination folder does not exist it must...

Hi Lou The sample database looks good, but I need something slightly different. For example; your Subject field holds a string of words. “Smith family has a baby boy John” “Smith family John and Jenny” When I type in “Smith” it finds the 2 rows, but I want to be able to type in any of the...

Great :) That’s it! However, it has highlighted some table issues. So I wonder if I can get around them, I mentioned earlier that [Text1] holds all the main data. I don’t know if this is asking the impossible but what the hell, if I don’t ask! Would it be possible to search out any of the...

Ok Hope you had a good day Dcx693, I was at a friends barbecue today and had a few beers. :eek: I can’t believe I didn’t try that it works fine accept for 2 things. Text box 2 and 3 have a lot of blanks in there columns within the table and my query code is not picking them up, i.e. if the...

Hi Yes check boxes would be a good idea. I mean either using one text box or more than one text box to refine the search. Is it possible to build this in a query or do I have to put it in some VB code? Did “I’m in New York” mean that you thought I didn’t no where Brooklyn was? And does that...

Ok I understand what you mean, but I don’t think I can use a combo box for the first 3 fields because there are thousands of choices. In fact the database holds 47187 rows of data so far and it keeps growing. The 1st field is the name of the item and it can be a string of different words in...

Well, The table would be like this; Column Headers; Column 1 = Animals Column 2 = Colour Column 3 = Location Data in table; Row 1 = Cat ---- Black ---- Home Row 2 = Cat ---- White --- Outside Row 3 = Dog --- Brown --- Home Row 4 = Frog --- Green --- Outside If I wanted to find all the cats, I...

Hi Thanks for the prompt reply (1) Yes you could have multiple fields filled in, so that it would narrow down the results from the table. (2) Yes I have been trying to use a query to perform this, but I am open to any suggestions.