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...
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?
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...
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...
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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.