Search results for query: *

Hi, I used the code below to load data into a DataReport based on an ado recordset. I did this because my user needs to select reports based on investor ID's and other run time citeria. This works well enough but now I can't figure out how to populate the labels which are not datbase...

Hey All, Is there a way to code parameter searches to fill a data report by the user? We have an access database using SQL and we need to draw Dates and Values based on which user is logged in. The code I use for this which loads a datagrid is: frmHoldings.adoHistory.RecordSource =...

Hey All, Using Jet4 with an Access database, would it be possible to limit the number of records returned, using the RecordCount Property in an SQL statement? For example, if an SQL query called for values associated with dates, could it be written to return just 5 or 10 records? Thanks in...

This code loads the symbols from the ado recordset just fine. Can anyone tell me how to allow only unique items to be loaded? In otherwords, even if there are several records with the same symbol, the user only needs to see it once. adoSymbols.RecordSource = "SELECT (Symbol) FROM...

Hi All, The application I am working on requires tracking investment shares with percentages extended to three digits. IE (567.098 shares) I know I could get this to work with mskbox but I have grown to detest those nasty little controls and besides the application has so many references to...

I need some help with the syntax required to return data between user specified dates. txtFrom and txtTo are user input text boxes where only date formats are allowed. adoChart.RecordSource = "SELECT * FROM History WHERE (Date) BETWEEN ' & txtFrom & ' AND ' & txtTo & ' AND...

OK So no one that visits this site is up on MSChart. So be it. Here's a little trouble syntax problem I have with data access. Any help on this will be appreciated. This ado call procedure is supposed to return records from the Holdings table if the accounts fields match the LIKE expressions...

I am trying to create an MSChart for my user that will grow with each new record. Also I would like to create the ability for the user to scroll from beginning of the chart to the end. The record count(dates and values) could grow to significant numbers, possibly several hundred. My sense is...

The following code works OK with the command buttons for "FIRST" and "LAST" and OK too while inside the last and first records. When I hit "NEXT" while on the last record (ie 5 of 5) I get a syntax error. no error number it just says "Syntax Error in string...

A program I built for a used parts dealer uses local databases (Jet4) and ODBC connections to SQL sever at a remote location. The program works well on all my user's machines except the one he has Windows ME on. Has anyone had any experience with the ME OS? I had him install Jet4 service pack...

I have recently switched from the VB Installer program to the Visual Studio Installer. It offers many options that VB does not. The most compelling reason was the ability to have the program install on the user's machine in the directory of your choosing. This insures that the connection...

My user just called and complained that the program I made for him on VB6 continues to run in the backround if he clicks on the X box in the upper right hand corner of the Menu Bar. (Where the minimize and maximize buttons are located.) Since the progam uses a remote connection the connection...

Any ideas on how I can change the desktop icon that the VSI packaging program uses? Thanks, Dwight

I have set a DataGrid to dispaly 18 rows (records) on a page. The ADO bound to it will return thousands of records and I have set up comand buttons and the down arrow key on the keypad to allow the user to scroll through the remaining records. When the user clicks on a perticular record, the...

I have read through the threads for the problem of this installation error message generated on the target machine. I have used the vb6 p&d and visual studio installer and I still get the message. I changed the reference to Active X Object 2.6 and then got a message for msado26.tlb error...

I can't seem to figure out what is wrong with this code. Text1 receives a number from the IF statement and the txtTollerance receives a number from an ado control. (I also loaded a number in the text box with Form_Load) The embedded IF statment fires even if the Text1 value is less than the...

I have created a program that extracts information from an SQL server. When the user's search loads up the form with the datagrid the enire program drops from view during the data download. (The desktop or whatever other program that may be running displays) I wanted to use a form with a...

I have had some bad luck installing my vb6 programs that use local databases created by Jet4 on user machines. Looking through the faqs on this site I have not found a reasonable answer to these troubles. The following are my concerns and questions: 1. When the programmer creates a new Jet4...

I am having trouble getting my ado to bring up records from an SQL server data base based on a search for a perticular password. I know the connection is good becuase I can get the ado to load text boxes when the form loads but when I code the record source to call up a record based on a known...

I am using the vbSendMail.dll for an application I am working on. The dll requires it's own form which the author has prepared for programmers. My client does not want to see this form every time he sends an email to one of his customers. So I have coded to populate it's fields from a form the...