Search results

I have some large code that is based around "DoCmd.TransferSpreadsheet" but it appends by default. Any ideas on how to get this to update exist data instead of bombing out due to primary key restrictions? I was thinking of uploading to a junk table, then automating some queries to update the...

Probably an easy one...I have two tables, each with a number field say "Cat-ID" and "Ref-ID". The query I am looking to write will show the outstanding values. For example Cat-ID: 100, 200, 300, 400, 500 Ref-ID: 100, 200, 500 Query Result: 300, 400 Any ideas on how to do this? I'm stumped.

In my database, I have a form that has 2 subforms on it. Both subforms are set to run off a query that is driven by a text field on the main form. I want to have a button on the form that when pressed, it will refresh the subforms based on the value in the textbox. I can't find a good way to...

Probably an easy one... I have a subform that displays the results of a query. I'm looking for the VB code that will select all the values displayed in these results & copy to the clipboard. From here, going to have it auto-open a set Excel file to export that data produced by the query.

Hi, I've attached a small JPEG file showing some query results and some data transposing I'm trying to work inside of Access. The top box shows the how my query results currently come up. The lower box shows how I would like to transpose this data so it can easily be exported to other things...

I have a form with a subform on it. When the user clicks a button, I need it to populate a field on the subform for each record in the subform. I am using a foreign key for the subform which is equal to the primary key on the form. I can get it to work on the first record in the subform using...

A co-worker is currently using an Access database to download data from a webpage. Once this data is loaded into a temporary table, it is copy/pasted (or extracted, same result) into a blank Excel sheet. One of the problems that has recently come up is with the ZIP Code field, for example...

I currently have a table that company information is imported into. On of the fields is whether or not the company is current (0=No, 1=Yes, 2=Left Blank). These profiles can also be added and edited manually. I have a 2nd table of information that is entered manually for only the current...

From a form, I have a button that does the following code to import a range from Excel into a specific Access table. I'm trying to figure out how to test to see if the record already exists in the table as to prevent key violation errors from occuring. Any ideas? I'm not sure where to start...

I have created a database application that compares bids on items from multiple companys vs. the current info for each item. As this tool is used for each analysis, it starts out completely empty. One of the main reporting features is a monster crosstab query that shows every current item...

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

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

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