Search results for query: *

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

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.

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

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

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

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

<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!

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

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

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

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.

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

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

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.

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

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!

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

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

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

Thank you Duane, that's perfect.