Recent content by chevyv8

Definitely, but it has been years since I last had to post a question and forgot to give a star at the same time I replied saying thanks and brilliant.

Thanks Tony, I just returned from holiday and saw your reply. Great explanation and your code works a treat. Brilliant

Please help, I wrote the following code expecting it to step through every workbook in a specific folder and every subfolder. But it only found the workbook in the Folder1 subfolder, it does not find any workbooks in the route Data folder or any subfolders within the Folder1 subfolder: Dim...

Thanks GlennUK, it works a treat.

I hope this is a better description A B C 1 Product Colour Who 2 product1 white 3 product2 4 product1 pink mike 5 product3 6 product1 blue If I use the following formula the answer would be 0 =VLOOKUP("product1",A2:C6,3,FALSE) But I am looking for is a formula...

This has been driving me mad all day, there must be some way to do this but I can't work it out. Is there some way I can lookup data in the 1st non blank cell in column C if there is a match in column A? In the example below I want to return the 1st person who has product1 in any colour...

Please help, I have upgraded to Office 2007 and one of my Excel reports no longer works, the problem is I cant select an Option Button on a chart using VBA. This is the code and line 2 fails with: Run-time error '-2147024809 (80070057) The item with the specified name was not found...

My ISP allows me to use SSI in my HTML pages, this makes it easy to create headers, footers and menus but now I have to move the site to another ISP that does not allow SSI but does allow Perl CGI, my question what do I need to replace the include statements with to make the web site work again?

What I ended up with was some VBA that is associated to the Close button of the Orders form so whatever was in the first field would be copied to the last field in the Customer form, then the checkbox just looked at that field. Very messy. I though that you may know of some way to could add...

Please help, I am new to Access / VBA and I have created a database with 2 tables, Customers and Orders and they are linked as a one to many, I have the customers sorted in a Query and then displayed in a continuous form with a button that opens a popup form for me to enter the orders. The bit...

Sorted, thanks for your help

Please help, I have some complete recordsets in a table that I want to copy into another table, once I have found the recordset how can I copy it? Is there a command like: RecordSet (OP_rec) = RecordSet (IP_rec) OP_rec.Update If so could I do a batch of recordsets without a loop as well? Any...

Yes, and if I look at the Advanced setting it also has the Open option set as well. I wondered if there could be something set as default in Access that was putting something in my databases, maybe in the autoexec.

If I create a database form scratch it wont open unless I open Access first and then select open, if I just double click on it nothing happens, anyone got an answer please?