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!

Register Log in
  • Congratulations derfloh 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. PRMiller2

    Problem invalidating toggle button on ribbon

    Hi all, I have the following code: Public gobjRibbon As IRibbonUI Sub OnRibbonLoad(ribbon As IRibbonUI) ' Callbackname in XML File "onLoad" Set gobjRibbon = ribbon End Sub Sub OnActionTglButton(control As IRibbonControl, pressed As Boolean) 'ToggleButton...
  2. PRMiller2

    Hide a subform on a subform

    Hey kjv, thanks for the reply. There's a great reference here: http://access.mvps.org/access/forms/frm0031.htm. I was unsuccessful with all of the different combinations I tried, so I ended up just splitting the subform's subform out to a modal pop-up.
  3. PRMiller2

    Type mismatch in array, occasionally

    The MOD function esnures that an odd number of elements is passed. If an odd number is NOT passed, it skips the WITH loop (I should actually set it to exit the function, but that's neither here nor there). Whether I call the varStoredProc function with 5 or 7 elements, it will pass the MOD...
  4. PRMiller2

    Hide a subform on a subform

    I have a form called fmnuMain that contains a tab control with a number of pages. I have a table populated with Form names and whether or not they are accessible based on that user's security level. On startup, I loop through that table, obtain the number of forms for which the user has...
  5. PRMiller2

    Type mismatch in array, occasionally

    I'm afraid that change didn't resolve the issue. Removing the quotes around the 10 in MyArray(i) = 10 made no change when running this with an intTotal of 5 -- it still generated the type mismatch. Running it with an intTotal of 3 resulted in success. This presents a problem because I have...
  6. PRMiller2

    Type mismatch in array, occasionally

    I have adapated code found at http://www.vb123.com.au/kb/index.html?200009_br_adod.htm. The purpose of the functions in question is to build an array of paramaters, pass them to a function, parse the array into an ADODB command object, then execute the query. One of my weak areas is in arrays...
  7. PRMiller2

    Lookup and display unknown number of values

    <SIGH> Only two cups of coffee so far this morning. My reading comprehension skills are currently those of a 6 month old. That as a very well-deserved reminder, thanks!
  8. PRMiller2

    Lookup and display unknown number of values

    Figured it out: I had to enable "System Tables" in the options dialog of MS Query. Weird, but hey. Thanks!
  9. PRMiller2

    Lookup and display unknown number of values

    Hi Skip, Thank you for the link, I was not familiar with MS Query. I am, however, experiencing an error. I have inserted a table with the appropriate data (it ended up just using the existing data on the sheet). I have highlighted all of my data, clicked Control+F3 and defined a name. I...
  10. PRMiller2

    Lookup and display unknown number of values

    I have an Excel 2007 workbook that I use for staff capacity planning. I budget for 8 different groups within a cost center, and have built 8 different spreadsheets. Each of the 8 groups has a supervisor or manager who is responsible for that group, and they are tasked with populating supply...
  11. PRMiller2

    Programmatically test 1,700+ reports

    Thanks Michael. We actually decided to abandon this approach and instead open the reports manually as situations warrant while exploring the program. This is probably the best way to test it from a user's perspective.
  12. PRMiller2

    Programmatically test 1,700+ reports

    I have been tasked with upgrading an Access application from 2003 to 2010. The application in question has over 1,700 reports. Having converted a development copy from 2003 to 2010, we have stumbled upon a few reports that don't work. We need to find a way to determine if all reports in the...
  13. PRMiller2

    Error 1326 when attempting to install Access 2003

    Thanks Remou. The fellow over at Microsoft was indeed able to assist. For anyone else that has this problem, following are the other steps I tookk: 1) Right-clicked setup.exe and ran as administrator. No luck. 2) Logged out of my account and, although that account was an admin, I logged...
  14. PRMiller2

    Error 1326 when attempting to install Access 2003

    Thanks Remou. I just tried that and the utility did not detect any problems to repair. There is a FixIt at http://support.microsoft.com/kb/290301 that I also ran on the suggestion of a Microsoft troubleshooter, but no luck.
  15. PRMiller2

    Error 1326 when attempting to install Access 2003

    I am attempting to install Access 2003 on my 32 bit Windows 7 Professional N laptop. I had Office Professional Plus 2010 installed when I first started this process. While installing from a mounted ISO, I receive the following error from the Windows intaller: Microsoft Office Access 2003...
  16. PRMiller2

    Linked table not updating

    Sorry for the very late reply. Maze that works, thank you! I don't know what I was thinking... I should always be refreshing my table links!
  17. PRMiller2

    Line above record selector when no records present

    I've searched around for this but, aside from a pay-to-view forum, haven't found a solution. I'm pretty detail orientated with my form design, and a black line appears above the record selector in a subform when no records are present. Is there a way to remove this line or, alternatively...
  18. PRMiller2

    Linked table not updating

    Hi maze, thanks for the reply. Yes, I stepped through the code in debug mode, nothing errors out. It does execute correctly, as the latest copy of the database arrives in the local folder. The weird issue is that, if I check a linked table from the application, the data is stale. If I open...
  19. PRMiller2

    Linked table not updating

    Having trouble with something that has worked for me in the past. I have a database that is stored on our network. When users open the front-end Access application, the network database is copied to the user's local C drive. In order to view changes made by others, the user can click a...
  20. PRMiller2

    File directory monitor

    Thank you Duane, that's perfect.

Part and Inventory Search

Back
Top