Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jjd100
  • Content: Threads
  • Order by date
  1. jjd100

    manipulating mschart with vba in access: changing label position

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

    Executing new controls blows up

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

    assigning defaults to list control

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

    Calling Crystal from 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?
  5. jjd100

    Linking to Oracle views

    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?
  6. jjd100

    horizontal scrolling of a column title with the control

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

    changes not saved on form_unload event

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

Part and Inventory Search

Back
Top