Search results

  1. W

    scrolling through report using the mouse key?

    I have a series of reports of reasonable length that I can move up and down using the arrow keys but I just haven't figured out how to set it up to use the mouse wheel. I am looking for ideas on getting this to happen. Thank you. :banghead:
  2. W

    table relationships and select statements

    I have coded a select statement that uses multiple tables for information used to populate a report. It returns the correct information, sort of, but it doesn't recognize the already existing table relationships so I get dupicate records. Is there a way to run the code so that it recognizes the...
  3. W

    how can I process a select query using a list box value as a where variable

    I am using Access 2013. I have the ability to pull a selection from a listbox. I can create a Select Sql string using that variable sql As String, strCompany As String, strWhere As String strCompany = strCompany & Me.lstResource.Column(0, varItem) strWhere = "[Company name]=" & "'" &...
  4. W

    running a query based upon a listbox selection

    this is likely very easy but being somewhat new to access listboxes I am having trouble. I have a list box that is correctly listing resources from a table (tblResource). I would like to select one of the list box entry and run a query against the tblResource to show the information for that...
  5. W

    getting entire reports to show on a tab control

    I have tab controls, each of which holds a report. If the report is longer than the tab control the report is stuck there. no slide bars, no overflow. I have set scroll bars but they dont seem to take or work. I need to find a way to add verticle scroll bars to the reports within the tab...
  6. W

    connecting a main form to a subform

    I have a form that shows information on a person (think first name and last name) at the top and contains tab controls that hold subforms each containing a different set of info about that particular person. Ex: for person 1 the main form will display the persons first and last name as well as...
Back
Top Bottom