Recent content by robojeff

My table name did have a space in it's name, so I changed it and now when I run this code it wipes out the whole table: The table is created with the following command: DoCmd.TransferSpreadsheet acImport, 8, "members_tbl", "C:\MemberList\Newlist.xlsx", True Private Sub update_Click() '...

Thanks MajP I added: rs.close Set rs = Nothing to the end of your code and imported the # field from the spreadsheet but received a run-time error '3131' Syntax error in FROM clause. When I looked at the table I realized that there were a couple duplicate records which I am guessing...

Thanks Skip I have coded in Access with queries via DAO objects in the past and it was several years ago so I will have to look at my old databases. Because I have been away from Access for some time now, I was just checking to see if there was another means of accomplishing this or if there...

Thanks Skip. My choice is not to modify the actual excel spreadsheet form and what I need to figure out is how to export my access table into the correct excel tabs whether it is by using the DoCmd.TransferSpreadsheet method or by some other means...

Thanks for the reply Skip I am not the owner of the excel spreadsheet and prefer not to modify it except for appending records to it from access. I am attempting to automate a manual and time consuming process that the spreadsheet's owner currently performs in order to add these records...

I have a table that I would like to append to an existing excel spreadsheet and I am using the TransferSpreadsheet method with the following syntax: DoCmd.TransferSpreadsheet acExport, 8, "Table-5", "C:\Stuff\MySpreadSheet.xlsx", True This exports table-5 into C:\Stuff\MySpreadSheet.xlsx but...

Not much to share really. What I posted was a smaller sample of the database that I am working on as I was mostly wondering about the concept of how to get the data into a format that I could use... I realized that I was attempting to do too much at one time with a query that had several...

OK, I figured out a work around for this by using several queries, one at a time.. Thanks everyone for your help and feedback

Thanks Randy- 99.999% of the time there is only one computer type per order and the software ordered quantity equals the computer ordered quantity, so I am fine with making this assumption...

LineNO OrderNO PartNO PartDesc Qty ------ ------- ------ ------------- --- 1 100100 10001 Computer IBM 2 2 100100 20002 Computer Dell 1 3 100100 10222 Bogus Software 3 Order# comes from Order_tbl.OrderNO Item comes from Order_tbl.LineNO One item per line per Qty ordered...

Thanks for the tip Andy. I will try it again... I have a multi line item order that I need to read into a form with a query where a couple of line items fields need to be contained on one line for each quantity ordered. Quantities ordered will vary from sales order to sales order and it...

No replies yet, so maybe I need to ask this in a simpler way... Is there a way to make a query that will take fields of each row of one table and display them in one row of a query? thanks

Any ideas out there on how to do this with a query or do I need multiple queries? Thanks

I have a multi line item order that I need to read into a form with a query where a couple of line items fields need to be contained on one line for each quantity ordered. Quantities ordered will vary from sales order to sales order and it is assumed that each order will contain a line item...

I tried the DoCmdTransferSpreadsheet command and it actually appends the table instead of replacing the table. Is there a way to have the DoCmdTransferSpreadsheet command replace the table. Also, it places the first Row of the excel spreadsheet in the 2nd row of the table as it places F1, F2...