Recent content by Badswell

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