Search results for query: *

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

Not sure if I am asking this correctly or not but here goes.... There are a lot of examples of DoCmdTransferSpreadsheet acimport out there but haven't found one that answers my question. What I would like to do is have the user click a button on a form and then have this command import a...

Thanks Andy- The admin made it clear to me that he doesn't want to open the door to anyone using Access to pull data from his Oracle system even with read only access, so the only option that I have is to pull the data into a spreadsheet with his OBIEE query and then grab the data with my...

I asked the Oracle admin if he could create a user with less table access (only the tables that I need) as the problem appears to be too many tables for the current user login that I use which is more data than Access's link table window can handle so that not all of the tables that I need are...

Thanks for the reply... The funny thing is that the same user and password can access all of the tables (including he hidden ones) in Oracle. I did find a Microsoft knowledge base doc relating to Access 2000 (https://support.microsoft.com/en-us/kb/325835) explaining how to modify the...

I have been away from Access for awhile so I apologize in advance if I sound like a newbie or posted this in the wrong area and I am counting on you to set me straight if I am wrong... I am trying to pull some data from a couple of Oracle tables and the Oracle admin has set up an account...