Search results for query: *

john, That did the trick. Thanks a bunch. Dwight

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

Mark and Swi, An additional question on this, if you don't mind. How would I get the last 10 records from the table, instead of the first 10. I tried to use the ASC and DESC keywords but this only succeeded in rearranging the order of the first 10 and did not call the last entries in the...

Thanks Guys, That will do the trick. Have a great day. Dwight

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

Thanks Guys, That was easy enough. Regards, Dwight

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

Dear SP, I did what you suggested and found that on the form load event I had a calculation procedure that, early on in the programming, I had trouble with text boxes with variable not adding but concotinating. I used the Int(txtBox) function on it to force an addition. Some how I must have...

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

Sorry about that, I'll be more detailed the next time. Regards, Dwight PS By the way I needed that bit of code to grab data for an MSChart control, and it works great. Can't thank you guys enough for taking the time to help. DK

Jimgary, Thanks buddy, your's did the trick. Have great weekend. Here's a star! Regards, Dwight

Jim and John, Thanks guys. DK

Thanks, I'll give it a try. DK

zarkon4, Thank you very much for your time and your help. Much appreciated! Regards, Dwight I tried this with single quotes (') and double quotes (") as shown below and I still get sytax error (Missing operator) Any other ideas? adoChart.RecordSource = "SELECT * FROM History WHERE...

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

Thanks to both of you. I just told my wife about how long I jerked that string arround and now that I have the answer, it cetainly makes sense and seems so easy. The wonder is..... When will I start figuring these things out on my own??? Soon I hope. Many thanks. Dwight

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

If anyone is interested, I think I solved my problems concerning the above posts. Becuase the standard coding method of moving from next to first always seems to bring up a blank record between the first and last records,or between the last and first, those blank records raised errors in sub...