Search results for query: *

I am having an issue printing a pivot chart from a sub-form. I have already created a pivot chart form. Then created another form to add a print function button along with the pivot chart added in as a sub-form and a report at the bottom. I wanted the user to be able to change the chart...

Can anyone point me into the right direction on how to import data from the desktop. I know how to import from Access but I am more interested in the code VBA. I would like to use a command button OnClick function to look for the specific file name and load that data into a table into Access...

I am currently using Access 2010 version .accdb but one of my programs that logs data is only allowed to link to .mdb versions. Is there a way to do this. Any help would be greatly appreciated.

Hello to everyone. Ok here's what I already have. In a form I have created a listbox set the property to Simple multiselect. The listbox is unbound in the form, but the values for the listbox comes from a table called Issues. I want the user to select more than one if the need too to find the...

I have created a query underlying to a button OnClick event. There is two list box that I want to set the criteria for. There is a date criteria coded: Between [Forms]![frmDetailQuery]![DateFrom] And Forms]![frmDetailQuery]![DateTo]. Then the two Unbound listbox that I want to set for a...

I am trying to count distinct or unique numbers from a field named Order. I have build the queries within queries but not sure how to make it work. I put the SQL code into the first query and it gave me an error such Circular Referece caused by OMOrder. What is wrong? Can someone help...

I want to create three toggle buttons name IQ, 4x6, and All. On the current form loaded, I want the user to click on one of the button which filters a combo box that holds the underlying table/query. Say if the IQ button is click, then the user goes to the field name Test Case combo box and...

The function works fine when calculate the numbers individually. When pulling the data in Pivot Table view the numbers are not correct. I have set the underlying table field as LongInteger. Can some one tell me what is wrong? What I am missing or needed? '**** 'Calculates the 4x6...

I have created a query table and want to count the distinct or unique number in the table-row. I have found some sort of a solution but it is not working for me. The solution was to use sub-queries in SQL statements nested with two other sub-queries. My data in the table row is called Order a...