473,320 Members | 1,821 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

What Did I Do?

675 512MB
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
13 1766
RuralGuy
375 Expert 256MB
Try importing your mdb into a new blank db.
Jul 29 '09 #2
missinglinq
3,532 Expert 2GB
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
OldBirdman
675 512MB
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
  3.  
  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
ChipR
1,287 Expert 1GB
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
OldBirdman
675 512MB
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
ChipR
1,287 Expert 1GB
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
OldBirdman
675 512MB
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
ChipR
1,287 Expert 1GB
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
RuralGuy
375 Expert 256MB
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
OldBirdman
675 512MB
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
RuralGuy
375 Expert 256MB
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
OldBirdman
675 512MB
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
RuralGuy
375 Expert 256MB
Well you do stop Windows by pressing the Start button right?
Jul 30 '09 #14

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

Similar topics

2
by: thecrow | last post by:
Alright, what the hell is going on here? In the following code, I expect the printed result to be: DEBUG: frank's last name is burns. Instead, what I get is: DEBUG: frank's last name is...
220
by: Brandon J. Van Every | last post by:
What's better about Ruby than Python? I'm sure there's something. What is it? This is not a troll. I'm language shopping and I want people's answers. I don't know beans about Ruby or have...
699
by: mike420 | last post by:
I think everyone who used Python will agree that its syntax is the best thing going for it. It is very readable and easy for everyone to learn. But, Python does not a have very good macro...
92
by: Reed L. O'Brien | last post by:
I see rotor was removed for 2.4 and the docs say use an AES module provided separately... Is there a standard module that works alike or an AES module that works alike but with better encryption?...
137
by: Philippe C. Martin | last post by:
I apologize in advance for launching this post but I might get enlightment somehow (PS: I am _very_ agnostic ;-). - 1) I do not consider my intelligence/education above average - 2) I am very...
12
by: Dario | last post by:
The following simple program behaves differently in Windows and Linux . #include <stdexcept> #include <iostream> #include <string> using namespace std; class LogicError : public logic_error {...
125
by: Sarah Tanembaum | last post by:
Beside its an opensource and supported by community, what's the fundamental differences between PostgreSQL and those high-price commercial database (and some are bloated such as Oracle) from...
47
by: Neal | last post by:
Patrick Griffiths weighs in on the CSS vs table layout debate in his blog entry "Tables my ass" - http://www.htmldog.com/ptg/archives/000049.php . A quite good article.
121
by: typingcat | last post by:
First of all, I'm an Asian and I need to input Japanese, Korean and so on. I've tried many PHP IDEs today, but almost non of them supported Unicode (UTF-8) file. I've found that the only Unicode...
8
by: Midnight Java Junkie | last post by:
Dear Colleagues: I feel that the dumbest questions are those that are never asked. I have been given the opportunity to get into .NET. Our organization has a subscription with Microsoft that...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.