Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: chevyv8
  • Content: Threads
  • Order by date
  1. chevyv8

    Excel VBA – loop all folders & subfolders

    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...
  2. chevyv8

    Excel lookup question

    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...
  3. chevyv8

    Problem using VBA with Excel 2007 Chart

    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...
  4. chevyv8

    headers with no SSI

    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?
  5. chevyv8

    Continuous forms question

    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...
  6. chevyv8

    how do i copy a recordset?

    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...
  7. chevyv8

    DataBase wont open

    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?

Part and Inventory Search

Back
Top