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

dan08 I have inserted True after fullpath and it works great. Thanks again.

Thanks dan08, it works well, though it keeps telling me that there is no F1 field in the table. Until I put an F1 field it works but completely puts that data into just that one field and seperated by rows. I have already made the field names in the table and would want it to insert those data...

Here is what I got and I am running into error where object is required. The error points to the DoCmd line. Not sure what needs to be there. The file name that I want to import is PrintQualityData.txt. Private Sub UpDateDatafromNotepad_Click() Dim file_name As String Dim strPath As String...

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

This will not work since the features are newer and not supported in the older version. It prompt me the incompatibility. Thanks for the response.

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 have the query base on the field call cboJobNo. What I want was to have the Operators click on one of the toggle buttons which filters the query where the cmdChoice is equals to the value as you have string: "qryIQ, qry4x6, and qryAll in the cmdChoice column. The query have the column names...

MajP, the toggle buttons only, what EventProcedure do I put the code. OnClisk is not available. I tried putting it in the On Key press event. Thanks for the quick response everyone.

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