Search results

Graph Problem Resolved!!! Further to my posts above, I found an elegant method to resolve my graphing problem, which works quite well. It was simple, and was so easy it is scary! A colleague of mine steered me in the right direction when I explained my problem over coffee..... I just created...

Graph Problem Resolved - sort of I reviewed some hints and code I found on different sites. Here is what I eventually came up with for my problem. :cool: Private Sub Detail_Click() Dim oGraph As Object Dim oDataSheet As Object Dim db as Database Dim rs as Recordset Dim RowCnt as Long '...

I have an x-y graph on a form that gets its data from a query. The query pulls five records of data from a table. So there are five data points I want to have displayd on the graph. I got the graph to work properly except it only displays four points! The first data point is not displaying...

I have 10 fields on a subform. they are named value1 to value10 consecutively. I would like to loop thru them, and get their values to use in subsequent events. I tried the following to reference them... Dim iLoop as integer Dim fldVal as control Dim ItemValue as string For iLoop = 1 to 10...

Okay, I see what you are doing with your code. The only thing I wonder about is the "zztest". I assume it is just a variable that does not affect anything, just allows the code to run more dynamically.

Remebering field location on a form Thanks for the tip.... I like what you are suggesting. I was thinking about it just a while ago, and wondered about the tabbing around. I will implement your code suggestion. Thanks for the help.

Thanks for the Info - Have it working now Thanks for the help...I got it working. It is not as "elegant" as I would like it, but it works fine. Here is what I did. For each entry textbox/field I used the following code: Private Sub x1_GotFocus() Me![NameFld] = "x1" End Sub Private Sub...

I have a form with a sub form (ms access). On the subform are a number of textboxes for input by the user. What I need is for the sub form to "remember" the last textbox it was in when the form closes. Then, when the form opens again, the focus in the sub form "returns" to the last text box...