Search results for query: *

I have successfully printed a number of series in my chart in a form in MSAccess. I am trying for every third data series to post the labels to the left of the first point instead of the right. The right of the data point is the default. This can be done manually by selecting the label in...

we currently have 6 tabs and no subforms. I suppose we could put some new controls on a subform, food for thought, thanks.

We have a 5-yr old Access 2003 application with about 400 controls. Late last year we could not create new controls, reviewed the postings on tek-tips reading about the 754 maximum and MSAccess's non-clean-up of old controls that have been deleted. We created a new form, copied and pasted the...

I don't really want to give this control the focus, it causes other problems. The solution chart_LTP = chart_LTP.Column(1, 0) of June 29 to assign the first item in a list box as the default works perfectly in this application and I'll be going with that, thanks everyone for your assistance.

here is the function in its entirety: Private Function PopulateLTP(iYear As Integer) As Boolean ' 29b: LY 20070417 populate the chart_LTP combo box On Error GoTo Err_PopulateLTP Dim strsql As String strsql = " SELECT ltp_nme, ltp " strsql = strsql & " FROM ltp " strsql = strsql...

MSaccess 2003 (11.6355.6360) SP1

I get: Compile Error: Method or data member not found. the compiler does not like the word ".Selected(0)

I tried that and it didn't work, I got the message "You've used the listindex property incorrectly". The good news is that I did some more reading and then figured out that I only need to assign the bound column to the listbox when assigning a default, not both columns, which in hindsight now...

I am having trouble assigning a default value to a list box control that I have which contains two columns. The code I am using in the form_open is as follows: strsql = " SELECT ltp_nme, ltp " strsql = strsql & " FROM ltp " strsql = strsql & " WHERE YEAR = " & iYear strsql =...

I have this problem for the following reason. My subform's recordset SQL includes a field in the main form's recordset that I perform arithmetic on, and when I close the application it closes the main form first, then the subform complains that the main form's field is undefined (box asking to...

invoking from the shell works, the send key isn't working. Any other ideas? lots of documentation using vb.net or vb6, how about vba? :-(

I would like to invoke a Crystal report from VBA and pass a few parameters to Crystal as well. Does anyone know how to do this?

forget that question, I was creating the view in a different Oracle database than I was linking to in Access, a temporary brain cramp. Linking to views in Oracle works fine, looks just like a table.

I created a view in Oracle, yet when I link to Oracle (Oracle ODBC driver v 9.2) I only see a list of the Oracle tables. Is it possible to link to an Oracle view?

I have a situation where I had a listbox which displays the results of a query. I created some labels above it in the form to describe the contents. Life was good. The listbox is now wider than the screen, and I now scroll it horizontally, alas the labels are stationary. What is the best way...

Trevil, I can see where I have been confused, and that the rowsource is remaining blank once the form is closed, I have been viewing the properties of it while the form is running, my mistake. Thank you so much for your help.

Thanks Ken, but I still have a problem that I set the rowsources in the application, and these rowsources are automatically SAVED when I exit. Is there some way to keep these changes in the runtime scope so that when I quit the aplication they would be not be saved in the form?

Thanks for replying. The reason that I am trying this is to speed up form open time for a network MSAccess application, where the frontend is on the users c: drive and the backend is on the network. I found this tip in http://www.granite.ab.ca/access/performanceforms.htm. According to the...

I am trying to clear all of the rowsources for the controls in a form upon exiting the form, and I found this short piece of code to do just that. The code seems to run OK when I close the form, but when I open it again the rowsource values have not been cleared. I would appreciate any...