I would love to visit Spain. (I studied Spanish many years ago.) I would have to fill up on tapas and skip dinner, or I'd be huge!
Thanks for sharing.
BTW, you're the best!
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, September 11, 2014 12:59 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Error Message On Opening Databases
Sheila-
Some restaurants are "service non-stop" - you can get a meal any time of day. Restaurants in the tourist areas serve dinner starting at 6p for the tourists. The locals wouldn't be caught dead in these places. Our local restaurants open at 7 or 7:30, but you're not expected to show up until 8, and many natives dine at 9 or later. You wouldn't survive at all in Spain unless you could make a meal out of Tapas. Breakfast is at 9, lunch at 1-3p, Tapas at 5-7, and dinner at 11p!
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Sep 11, 2014, at 8:40 PM, Sheila Vaughnn sheila_vaughnn@beaerospace.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Ah. That was my second thought.
I have to leave for an appointment soon so I may not be able to finish today. I'll keep you posted.
BTW, I just heard that the restaurants in France don't open until 8:00 pm. I would be starving by them. I guess I'm a Sinatra tramp.
Have a good evening.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, September 11, 2014 11:36 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Error Message On Opening Databases
Sheila-
The Startup properties are in Access Options / Current Database.
It's only dinner time here. 😃
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Sep 11, 2014, at 8:23 PM, Sheila Vaughnn sheila_vaughnn@beaerospace.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
John:
Wow! That was a quick response. And it's late in Paris. Thank you.
I think I understood all the steps except the last one. I don't know where the Startup properties are set. Is that in VBA code? That's over my head.
I am going to start the process now. I am eternally grateful.
-Sheila
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, September 11, 2014 10:48 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Error Message On Opening Databases
Sheila-
The problem is the parts of the VBA project have become "disconnected" from the associated forms / reports.
Try this:
1) Create a new empty database. Make sure you turn of Auto Correct in this database.
2) Import all the objects from the "broken" database
3) Open the VB Editor (CTRL+G works), and choose Compile from the Debug menu. If you get no errors, Save the project.
4) Compact and Repair the new database.
5) Put back the Startup properties that were set in the old database.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Sep 11, 2014, at 5:26 PM, Sheila Vaughnn sheila_vaughnn@beaerospace.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Hi, everyone:
My name is Sheila. I work for Liz Ravenwood, who is a member of this group. She is also the only expert I know of at our company.(I've been here less than three months.) Liz is on vacation, and I'm stuck. I'm a real newbie as I've been trying to learn Access 2010 for about two months. I am not a programmer, and I don't know VBA. I have been reading Dummies books to try to get up to speed.
Here's the problem I have:
On Tuesday (9/9), I opened Database A in one instance of Access and made some cosmetic changes to the main form. Then I opened Database B in another instance of Access to make a few quick changes as I waited for a meeting with the user for Database A. In Database B, I made a few edits to some sub-forms that reside on the main form. I selected a text box and thought I was typing a word into a property field. (Yes, I believe I have AutoCorrupt on, which I've since learned I shouldn't.) Suddenly the screen seemed to freeze, and I got a message box asking if I wanted to save changes. I decided I better, so I clicked OK. Both instances of Access disappeared. When I try to re-open Database B (which I have more than once), I get this message: The expression On Open you entered as the event property produced the following error: Return to GoSub.
I looked up the error message online, but the suggestions, like Decompiling, were over my head. Of course, Compact & Repair didn't work. It was late in the day so I gave up.
The next day, I opened Database A without using the shift key. When I expanded the left panel, I selected the form, right-clicked Open, and the form opened! Magic? I worked on the form for most of the day thinking I could at least get some work done until Liz returns. I saved frequently in vain. In the afternoon, I closed the database. Then I thought of a quick change, and tried to re-open the database, and I got the same message again.
I'm totally mystified, worried, and out of ideas. Can anyone help? I really don't want to text Liz while she's on vacation.
Thank you very much,
Sheila
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.
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: Sheila Vaughnn <Sheila_Vaughnn@beaerospace.com>
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (12) |
Tidak ada komentar:
Posting Komentar