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

Perfect thanks!

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

Exactly. I already know the specific file & range to drop it in, just need a way to grab the query results.

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.

That was my initial thought. The problem with that being the data is used purely as row headings in the export. There is no actual data fields to pull out. I think I may end up just using VB & work around it.

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

Unfortunately yes.

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

Ah yes I forgot about those. That accomplishes that, however, would there be a way (might need VB coding to do this) to run this query only if the company didn't already exist in Table 2? If they are already there, I don't want the information appended. Trying to avoid key violation errors.

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

Almost there...although by just hiding the warnings around the transfer spreadsheet command, the import process still tries to import bad data (ie alpha characters in a numeric field) and now the Transfer boolean always is set to True, so the "successful" message is always returned. Even when...

Thanks for the help on this Miles..I appreciate the patience.. That code does most of what I'm trying to accomplish. The run-time error message about the transferspread action being canceled is now hidden. However, the message on "Microsoft Access was unable to append all the data to the...

I've played with these warnings before, but what I run into is now there is no test on whether or not the import was sucessfull. I'd still like to put up a msgbox about the error, just not the default ones which would allow the user to get in and break things.

I'm thinking this may be the wrong approach to my goal. As you know when a duplicate record is attempted to be imported, Access brings up its "Unable to Append" message, prompting the user to select Yes/No/Help in regards to proceeding. Selecting No brings up Run-Time Error 2501 -...

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

Okay I got the common dialog working. That was pretty painless. For the time being, the path of the selected file is being brought into a text box named "Text1." Still not sure on how to bring this path that is selected into the import feature. Using name ranges for the sheets would work on...