Recent content by DK47

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