By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,653 Members | 1,847 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,653 IT Pros & Developers. It's quick & easy.

What Did I Do?

P: 675
I have no idea how I did this, but somehow my forms and code respond differently.
1) With all forms closed, if I change VBA code, the form who's module is changed opens in design view.
2) Forms in design view cannot be opened from within VBA code
3) VBA code cannot be changed with form in Normal view
4) When stepping code, I continually get message "2499 You can't use the GoToRecord action or method on an object in Design view." I not trying to. The window is in Normal view, and I am interacting with it.

I'm sure there is some checkmark that I changed. What/where is it?
Jul 29 '09 #1
Share this Question
Share on Google+
13 Replies

Expert 100+
P: 375
Try importing your mdb into a new blank db.
Jul 29 '09 #2

Expert 2.5K+
P: 3,532
I agree with Allan's thinking that this has to be a corruption issue, and hopefully importing everything into a new database will resolve it, as it frequently does.I can't think of any setting you could have changed that would account for behavior such as this.

I know you're going to hate this question, but what kind of development time have you lost if you have to go back to a previous, backed up version?

Linq ;0)>
Jul 29 '09 #3

P: 675
This is not a corruption issue, at least not of the database. Maybe Access is corrupt. As I type, I'm doing a complete VirusScan of my computers.

1) This problem occurs on a new database also. I create a blank database, create one form, with one button. OnClick is one line, Msgbox "xxxx". Save & Close form from design view. Visible now are Access window with Database pane visible, not maximized, and VBA window with module (maximized pane) for Form1 and 5 lines of code
Expand|Select|Wrap|Line Numbers
  1. Option Compare Database
  2. Option Explicit
  4. Private Sub Command0_Click()
  5.     MsgBox "xxxx"
  6. End Sub
Positioning my cursor on line 3 of code, and typing a blank opens 'Form1' in a design view pane in the Access window behind the Database pane. Closing it requires me to save the change (of course).
I opened an old access program, last modified in 2007, and the same thing occurred.
Moving to my new laptop, it now has the same new "Features". Some of these new features are:
1) ... as described above
2) VBA Window now opens with modules all displayed in individual panes, but not tiled or cascaded, just scattered random sizes and locations
3) Some databases open without sizing buttons and no way to work but full sized panes within the Access window (which can be sized)
4) Some databases open without the Menu toolbar. I don't know how to display this when missing.

If I have to reinstall Access/Office 2003, I want to know how to also remove any settings from existing database projects. I say this because this problem migrated to my laptop, where I wasn't doing any development, from the desktop. As I don't copy Access, only mdb/mde files, the 'Settings' in some project 'Infected' Access on the other computer.
Jul 30 '09 #4

Expert 100+
P: 1,287
I thought most of this was normal behavior.
When I change the code in the form, it opens the form in design view. It will stay in form view if it's open in form view already, but I generally avoid that. I have disabled Auto Syntax Check and Compile On Demand in the Tools->Options.
I often crash Access when I try to switch from form view to design view on forms with subforms, or sometimes just complicated forms.
Working in a converted 2003 db, I get normal forms, but when I start a new one in 2007, I get the maximized forms that I can't change. I don't ever use a new db except a quick test, so I haven't bothered with it, but it was annoying.
I do get modules scattered all over the place in the editor, but I assume that's how I left them at some point.
Haven't experienced the menu bar thing, probably because I hide/show it in my startup code depending on the user.
Jul 30 '09 #5

P: 675
VirusScan of Laptop is complete w/nothing detected. Desktop proceeds, nothing found 60% complete. I'm ruling out computer virus.
ChipR - You are implying that my Access 2000 & 2002 were not working correctly, and when I removed both and installed 2003 it did not work correctly, until now, when both computers are now working correctly. Believe in miracles, but don't rely on them.
1) It would seem logical to open in design view when code changed. I can live with that, but will take getting used to.
2) This is just more clicking sometimes when I enter Access. I KNOW I didn't leave it this way. Why would I ever want a pane 1" x 1" (retorical) ? You may do this, but I never even knew I could, and I'm not sure how.
3) OK, I now have a form open in Design View. I can right-click and change to/from Form View, but how do I close it? After modifying design, I have to close so code can open, otherwise error occurs.
4) Without Menu bar, how do I do things not represented on the FormView toolbar? Like Tools->Options...
Jul 30 '09 #6

Expert 100+
P: 1,287
Hmm. I have no idea what "working correctly" may be, just what mine has done in 2003 and 2007 versions. I would say if it's not the way you want it, it's not working correctly.
I have experienced errors while trying to code, and they were due to a form with a timer running and interrupting me in the middle of a line. Do you have any of those?
Jul 30 '09 #7

P: 675
No! No timers. You say opening in design view is standard, so that is 'working correctly'. Working correctly as is designed, whether I like it or not.
But if I don't have a menu bar, what do I do? Help is no help. To view another toolbar, click View on the menu, but if no menu, then what?
If no size buttons, even for database pane, what do I do? This is not working correctly.
I won't question why the changes now? I don't remember a windows update 2 days ago, but these are so ubiguous that you really don't notice. That is probably what changed.
Jul 30 '09 #8

Expert 100+
P: 1,287
I don't know if this will be helpful or not. I can't really picture the old menu bars now that I've gotten used to the ribbons.
Menu Bar Has Disappeared - Can't Get It Back
Jul 30 '09 #9

Expert 100+
P: 375
If it helps, Tuesday's update of IE changed my OutlookXP and AccessXP. I still haven't gotten my Outlook back to where it used to be.
Jul 30 '09 #10

P: 675
ChipR - I cannot click the "View" menu item without the menu bar. All solutions I've found with Google involve the simple solution, "Click View" and check the items you want.
RuralGuy - Thanks. If AccessXP changed, maybe 2003 did too.
Jul 30 '09 #11

Expert 100+
P: 375
That was my thinking. I did not expect the changes in Access or Outlook. Maybe try uninstalling the last change and see what happens.
Jul 30 '09 #12

P: 675
FIrst, I don't know how to uninstall an update, unless this is to restore to previous date.
Second, does this fix the problem, or only move it forward to a future update?
I'll have to think about this before acting. See if I can restore menu bar, which I can't figure out how to get around. Everything else I can adjust to.

This is annoying, however. If I test-drove cars and bought one, I wouldn't want the dealer continually coming around and modifying it without my knowledge. OK so he fixes a safety issue. But replacing the wheels with smaller ones, repainting over my custon paint job, or replacing the steering wheel with a bigger on is unacceptable. Microsoft doesn't see anything wrong with that.
Jul 30 '09 #13

Expert 100+
P: 375
Well you do stop Windows by pressing the Start button right?
Jul 30 '09 #14

Post your reply

Sign in to post your reply or Sign up for a free account.