Hi Crystal,
That is what was so weird. It is a table.
I have a theory that I haven’t checked out yet though. There is something running when the excel first opens and sometimes takes longer than other times. I suspect this is actually preparing this table and if the user clicks the button that causes the code to run prematurely, I think it locks.
I did get a report from her that the process went through that point yesterday but now we’re on to something else --- some other bit that isn’t getting updated further along in the code.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, October 14, 2015 6:27 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] query must be updateable on transferspreadsheet?
Hi Liz,
What is the SQL for "WO Routing Actual vs Standard"?
warm regards,
crystal
~ have an awesome day ~
On 10/14/2015 4:06 PM, Liz Ravenwood liz_ravenwood@beaerospace.com [MS_Access_Professionals] wrote:
Pros, This is a command from a db that got dumped on me and I don’t know why it is breaking.
objAcc.DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, _
"WO Routing Actual vs Standard", strName2, True, "Actual Data!"
Gives the error query must be updateable. Other than someone having the table open, I don’t know why it is crashing.
Respectfully,
Liz Ravenwood
Programmer / Analyst
B/E Aerospace | Super First Class Environments
1851 S Pantano Road | Tucson, Arizona 85710
Office +1.520.239.4808 | Internal 814-4808
beaerospace.com
Passion to Innovate. Power to Deliver
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Liz Ravenwood <Liz_Ravenwood@beaerospace.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar