Search results for query: *

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

...how to populate the labels which are not datbase connected. Private Sub cmdHistory_Click() frmDataReports.adoHistory.RecordSource = "SELECT * FROM History WHERE Investor_Number = " & frmStartPage.txtInvestorNumber & " Order By Date DESC" frmDataReports.adoHistory.Refresh...

...Values based on which user is logged in. The code I use for this which loads a datagrid is: frmHoldings.adoHistory.RecordSource = "SELECT * FROM History WHERE Investor_Number = " & frmStartPage.txtInvestorNumber & " Order By Date DESC" frmHoldings.adoHistory.Refresh...

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

...(') and double quotes (") as shown below and I still get sytax error (Missing operator) Any other ideas? adoChart.RecordSource = "SELECT * FROM History WHERE (Date) BETWEEN " & CDate(txtFrom) & " AND " & CDate(txtTo) & " AND Investor_Number = " &...

...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 Investor_Number = " & frmStartPage.txtHoldInvestorNumber & &quot...

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

...is loaded with the correct Investor number. The textbox and data field are Integers. adoAddCash.RecordSource = "SELECT * FROM Holdings WHERE (Description) LIKE '%MONEY%' OR (Description) LIKE '%Treasury%' OR (Description) LIKE '%Cash%' AND Current_Value > 0 AND (Investor_Number) =...

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