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 Chriss Miller 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: *

  1. DannyLondon

    Selecting a tab in the TabStrip control

    Hi Folks This seems like it should be a simple issue, but I am struggling to find a solution for it. I have added a tabstrip control to one of my Access forms. Note that this is the tab control with just the tabs, not with pages. I can't work out how to select a tab using code (eg, to make...
  2. DannyLondon

    Access error - You don't have permission (3033)

    Hi Folks I am really, really perplexed here. I have an Access database with is secured by an mdw file. I use a shortcut to open the file, and automatically execute code within it. The shortcut contains the user, password and command line argument, eg: /user UserID /pwd Password /cmd Auto...
  3. DannyLondon

    Limit to List for VB ImageCombo

    Hello all Does anyone know how to limit the VB ImageCombo control to items in the list (ie not allowing free text)? I expect the behaviour which is achieved in the standard combo box by setting the style property to 2 - Dropdown List. Thanks Danny [rockband] [wiggle][wiggle][wiggle]
  4. DannyLondon

    Create PivotTable for Excel from Javascript

    Hello all I am trying to create a pivot table in Excel, driven by JavaScript from my intranet page. The code works beautifully within VBA, but it keeps falling over on the PivotCache object in JS. The code is below. I would be very grateful for any suggestions on why this may be. I have...
  5. DannyLondon

    Create Excel PivotTable from Javascript

    Hello all I am trying to create a pivot table in Excel, driven by JavaScript from my intranet page. The code works beautifully within VBA, but it keeps falling over on the PivotCache object in JS. The code is below. I would be very grateful for any suggestions on why this may be. I have...
  6. DannyLondon

    Changing data source in MS Query

    Hello all I have found this question asked a couple of times over the last two years, but have not found the thread coming to a good conclusion. My situation is that I have an Excel 2000 workbook with external data, linking via ODBC to an Oracle database. The MS Query is embedded in the...
  7. DannyLondon

    Use of regular expressions to simulate *

    Hello All I have wracked my brain trying to understand regular expressions and trying to solve a problem that I do not believe should be difficult. Alas, I have still not found a solution. I have the following two strings, which are defined at run time: var pet = "dog" var animals =...
  8. DannyLondon

    Returning rows n-m without RowNum

    I have a requirement to present 20 records at a time on an ASP page. I was dismayed to find there is no RowNum, as there is in Oracle, and so came up with the following logic. I hope this may be useful to some others. The example will return rows 61-80. The starting record (61), and number...
  9. DannyLondon

    Suppress section for first record on each page

    Hello all I am trying to create a report which has a divider line between each detail, but not one above the first record on each page. I have created a DetailA section which has the line in it, and have been playing with formulae to suppress this section for the first record on each page...

Part and Inventory Search

Back
Top