Search results

For a project review, an Excel template is sent to multiple people. Each person fills out this file and returns it. Within the Excel file, there are multiple worksheet of information that are imported into Access. These worksheets are setup to match the formats and field types of the Access...

I currently have a button (All_Current_On) on a form that refers to the query (Update_All_Items_Turned_On). This query is a simple update query that changes a Yes/No field for all records in the table from "NO" to "YES." UPDATE Current_Items_Info SET Current_Items_Info.[Item_ON-Off] = Yes...

I got it working, thanks again!

Thanks for the help on this. The code does work & the number displays once a name is chosen. However I think the a column does need to be hidden because the combo is showing the supplier # rather than the name.

Still having some issues with this. Here's the code that drives my combo box: Form: [Current_TNC] Combo Box for Name: [curr_tnc_supp_name] SELECT [PS_Supplier_Info].[SUPRO_Supplier_Name], [PS_Supplier_Info].[SUPRO_Current_ Supplier] FROM PS_Supplier_Info WHERE...

On a form I have a combo box that lists companies names. Each company has a number code assigned to each. Below the combo box, a text box is there that would display this number based on the user's choice in the combo box. I can't get the text box to update automatically based on what company...

I have a query that runs off of a specific product category through a combo box on a form. (((Item_Detail.Product_Category)=[Forms]![category_summary]![cat_name_combo])) The first option in the combo box is an empty entry that returns no results since it is not tied to any category. The...

Is there another method of export that would carry the footer along?

I was just using the export command through the File menu.

I currently have a report set like: Page Header Category Name Sales Category Header =[category] Detail =[Name] =[Sales] Category Footer TOTAL =[sum_sales] When I run this report, the output looks like: Category Name Sales 1...

I am currently having this same issue. In a multiple crosstable query that combines the results of a series of 9 individual crosstabs. The individual queries all recognize the combo box criteria and run perfectly fine. Yet when the “master” query is run, it refuses to recognize the same combo...

I have a blank database that has been designed to be used as an analysis application of companies. The user imports information from Excel into specific tables that feed into a series of queries. One of the queries is a multiple crosstab query that is fed information from 9 crosstab queries...

I have that much figured out. Currently I have 2 crosstab's being grouped together, but the results are grouped by the value of the individual crosstab.. cost for #1, cost for #2, price for #1, price for #2 I'm looking for the query result to be grouped by proposal, showing a set of fields...

I am currently working on a project comparing a current item program (cost, price, mfg #, etc) vs a series of proposal against the same program. Using crosstab queries, I have gotten the results to resemble: Current Program | Proposed Cost 1 | Proposed Cost 2 | Proposed Price 1 | Proposed...