Recent content by wjulaxer13

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:

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

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]=" & "'" &...

ok, i have the code recognizing the correct selected list member. now to get the query to run. would the easiest place to place this code be the unbound listbox or a command button that I created? How does it tie to the query? through vb? Right now I have it as part of the On Click event.

sorry, let me rephrase. I want to run the query using the listbox selection as a variable in the where clause (where resourcename = ?) and just have it display the results of the query. I may create a form to make it a little prettier latere but just showing the results of the query would be...

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

thank you. that helped guide me to the answer. THings work now.

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

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