Search results for query: *

How do I tell SAS not to print the value of a numeric variable if it is zero? I have a variable called SEGNUM which I initialize to zero at the beginning of my code. Then I have statements that set the value of this variable depending upon certain conditions, so there are times it will remain...

I have created a simple telephone message form in Outlook 2000 and saved it to my Personal Forms Library but now we want everyone to be able to use it. What is the easiest way to do this? I thought of just sending everyone a copy to save in their drafts folder, but then each time they fill it...

I have some code on the change event of my textboxes, but I only want it to fire if the user does NOT hit either the delete or enter key. I tried moving my code to the KeyPress event and prefacing it with: if KeyAscii <> 8 or KeyAscii <> 127 then 'my code here end if However, then my code no...

I am using the following code to automatically retrieve matching information from a database and populate a text box as the user types each letter. lngOrigPos = txtLName.SelStart Set rs = GetArtist(strName, strField) If Not rs.EOF Then With rs .MoveFirst...

I want the user of my program to be able to select which field they want to group by and then pass that value to Crystal reports, but I can't figure out how to do that. Do I use GroupSelectionFormula, GroupCondition, or GroupSortFields? I have created my report with a group section, but...

I am using VB6, CR 4.6 and Access 2000 and I think there is a discrepancy in my database connection. My global variable in my vb project is: Set myConn = New ADODB.Connection strDataSource = App.Path & &quot;\InventoryV1.mdb&quot; With myConn...

I am working with VB6, CR 4.6 and an Access Database. I have a customer table with the fields: LastName FirstName CompanyName There will never be both a LastName and CompanyName entered, so when I pull up my customer report I want to have one field on the report called customer and fill it...

The following snippet of code works fine, except after execution the cursor positions at the beginning of the textbox instead of where the user left off. What I want is for the user to be able to keep entering the name in case the name that the database finds isn't the one they want. Private...

I want to stop a user from entering information on a worksheet that is being updated through VBA code. I am using ActiveSheet.Unprotect, updating the cells, then using ActiveSheet.Protect at the end of the sub. The problem is that when the sheet is unprotected, the updated cells are somehow...

I am copying cells from one worksheet to another. If I hard code in a cell address it works fine. But I want to copy only certain cells from a row that the user selects. How do I assign the row ID to a variable. Here is the code that I have so far: Private Sub cmdPaySlip_Click()...

I am trying to write a macro to achieve the following: -the user highlights the row in the worksheet that they wish to use and clicks the command button to start the macro -the macro copies specific cells from the highlighted row and then pastes just these cells to another worksheet in the same...

How do I disable drag and drop on the root node only of a tree view control. I tried the following on the click event and also on mouse down: If tvwInventory.SelectedItem.Root.Selected = True Then tvwInventory.OLEDropMode = ccOLEDropNone txtAddOrder.OLEDropMode = ccOLEDropNone...

How do I reset the text in a MaskEdit control back to the mask? I have a form to enter a new customer and after the save has been successful a function clears all the text boxes ready for the next entry. I tried just coding mskPhoneNumber.Mask = &quot;###-####&quot; but it stills leaves in the...

I want to make sure the panels on the status bar are wide enough to display the message I am passing in. I tried: sbMain.Panels.Width = len(message) and got a compile error that the width property could not be set. Then I tried sbMain.Panels(1).MinWidth = len(message). This time it said that...

I need some help updating the quantity on hand in an inventory table with information retrieved from two other tables. There are three tables involved: Product, Inventory, and Ingredient. The ingredient table is the junction between product and inventory. What the stored procedure is...

I am working on a project for college that is supposed to do the following: take screen input for a payroll record validate each field if invalid allow the user to either correct or clear the screen to enter the next record if valid write the record to a file when no more records exit I am...

I am working with an Access Database with a VB6 interface. I need to create a report that includes information that cannot be retrieved with a single SQL query. I am a newbie to Crystal Reports and have only been able to create reports using one query. Is it possible to use more than one? If...