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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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