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 Rhinorhino 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: PRMiller2
  • Content: Threads
  • Order by date
  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

    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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. PRMiller2

    File directory monitor

    I currently have a form that runs a timer event every x milliseconds. It checks to see if a file exists in a certain directory and returns a value (1) if one does exist: If FileExists("C:\Mypath\Queue\*.*") = True Then ... I'm trying to build this out so that the program detects whether or...
  10. PRMiller2

    Enable design view of objects programmatically

    I have found this before, but 2 hours of Googling have so far been unsuccessful. I have a database in which I cannot view any object in design view. For example, right-clicking on the name of a table does not bring up the usual menu for allowing me to select design view. I can create a new...
  11. PRMiller2

    SELECT DISTINCT text field results in duplicates

    I am having a problem with SELECT DISTINCT... it is returning duplicate rows. I have imported an Excel spreadsheet to a table with the following structure (just the first few columns): HMSPIID, Text, 255, @ FIRSTNM, Text, 255, @ MIDDLENM, Text, 255, @ LASTNM, Text, 255, @ The first few rows...
  12. PRMiller2

    Left join oldest (min) record

    My SQL is not where it should be -- I've done a search and can't seem to get the syntax of this quite right. I am selecting all Claims from my ClaimDetail table, and related Contacts in the ContactHistory table, but only the most recent one. In a nutshell: 1. If a claim has not had any...
  13. PRMiller2

    Move focus before unload to prevent loss of data

    I have a form for data entry. If a user hits Escape or close, the program checks to see if data has been changed. If it has, then it asks the user if they want to save their changes. If they do want to save, a SQL statement is executed to insert data from the unbound form into the database...
  14. PRMiller2

    Almost-evenly split groups among 4

    I have a number of phone calls that need to be made to clients in a variety of states every day. I have four staffers making those phone calls, and they will be splitting up the work-load by state, so that no two staffers make calls to the same states. Here's what the data looks like: State...
  15. PRMiller2

    How to troubleshoot emptry Crystal Report

    Using VS2010 professional, C# with Crystal Reports. What is the best way to step through and debug a Crystal Report? I have three reports that load successfully, but a fourth that loads only the report and page headers, with no data. I used the debugger to capture the SQL statement and...
  16. PRMiller2

    Combobox text remains selected after autocomplete + tab

    I have a combobox which is populated with a dataset and autocomplete enabled on MainForm_Load: private void FillClientComboBox() { try { string conn = ComplianceManager.Properties.Settings.Default.CS_DBConnectionString...
  17. PRMiller2

    Write today's date to registry during installation

    I'm using Visual Studio 2010's Installer to deploy a Windows Form application. I have figured out how to add keys to the registry during the installation and how to change a string value. However, I'm not sure how to set today's date. In my case, I have created a registry key during...
  18. PRMiller2

    Changed field format in designer

    Good morning, I am new to Crystal Reports so please bear with me. I have a C# project designed in Visual Studio 2010 Professional Edition with Crystal Reports embedded. I created a report with about 20 fields, and populate the values at run-time with a data-table. My question is this: I...
  19. PRMiller2

    Excel 2007 format as percent inside quotation

    I have the value 73.27% in cell E19 of a spreadsheet named "data." On my report spreadsheet, I have a cell that I would like to display as follows: "73.27% of data..." So far, the formula in my cell is as follows: ="∙ " & data!E19 & " of data..." My question is, how can I format the...
  20. PRMiller2

    Index was out of range only on last record

    I'm very new to C#, so hoping someone can help me out. I've been banging my head against the wall on this one. I'm receiving the following error: "Index was out of range. Must be non-negative and less than the size of the collection." In Main.cs, when a user has a customer selected in a...

Part and Inventory Search

Back
Top