Search results for query: *

I have a function that totals columns from a grid and displays the amounts in a textbox....it works great when there are records found but if the user clicks on the "total" button with no records i get the error "subscript out of range"...i want it to display...

Here is my code that allows user to search for records by Name and Date...records found are displayed in the Grid.....if user enters nothing then it prompts use to enter something....i guess the queston is....How do i let the user know there is no current record found or if that they must enter...

Hey...just wonder if anyone new how to use an input box to search for and display information in a Grid? Here is what i'm trying...it worked in the change event, but i thought it might be easier for the user to use a button...so i wanted to use the click event for an input box...here is what i...

How do i default a textbox and or Label to show a $ value when a calculation is perofmed? Curretn;y just the number appears but i want it to be shown in dollars. Can anyone suggest anything?

I have an MSFlexgrid that displays records based on Names and Dates. I was just wondering if there is anyway the user can view or scroll through each set by alphaetical order. Also, does anyone know how the records in MSFlexgrid are arranged? here is my code... Public Function...

Season's greetings all!! Just wondering how i would create a function to sum a column in a MSFlexGrid? I wanted to have a coomadnbutton to perform the function and a textbox to display it. Is this possible and can anyone help? simon

I have a combobox with a list of codes(product codes) and I have a text box that represents the dollar amount....I want to enable the button for the codes that do not require a dollar amount and only enable the button if a dollar amount is entered for the codes that require a dollar...

I have a Sales tracker form in VB6 that a user fills ( name,date, prod code, dollar..) I want to restrict the user from submitting this form unless a dollar amount is entered ( not all prod codes require dollar amounts). How do i force the user to enter a dollar amount if they choose a product...

I am trying to list 2 sets of criteria in my Grid ( Agent Name and Date). As you can see it works fine for the Agent Name, but when I do the same code in the Text2.text_Change() which is my Date field, it groups all the Agent's Names with the same dates. I am trying to group only same names...

I have a MSFlexGrid and was wondering if it was possible to have a running sum for a specific column?

I have a Flexgrid but it always shows 1 less record. If i have 6 records for one Agent, it shows 1 record with no name, and then it shows 5 records with the correct name. Am i making sense? Here is my code Private Sub Combo5_Change() Dim db As Database Dim rs As Recordset Dim strFile As...

I have a form with several textboxes(agent name, date, cx name, ref#, product code ,dollar, cross sell, cross sell dollar) . If the User makes a sale they must fill in at least name, date...product code and dollar. Both cross sell fields do not have to be filled. So my problem is that when i...

I have a DB that stores daily sales. I would like the salesperson (user) to be able to look up their own sales using a button that can Search Sales by Agent Name. My DB is called Tracker. I can use the seek and index method for the data control but i would like to use the ADO control. How...

This is what i have....i am using ado, but my connection is already bound using the properties box....is that ok or do i have to connect it using code...also, how do i know what provider i am using? i am using the built in DB in Visual Basic 6, does that make a diffrence? Striving to...

I have a Tracker table with the fields Agent name, Date, Customer Name and Product. I want to sumbit the records into my DB using a button. How do i do this? BTW, does i make a diffreence it's already bound using the Wizard or do i still have to write that in the code. ow do i find the...

I have a form set up connected to a DB. First field is a combo box filled with names. I can choose a name and it appears in the box, but when i tab to the next text box it disappears or it gets erased. How can i resolve this problem? Thanks in advance, Thom