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?
13 1766
Try importing your mdb into a new blank db.
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)>
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 - Option Compare Database
-
Option Explicit
-
-
Private Sub Command0_Click()
-
MsgBox "xxxx"
-
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.
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.
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...
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?
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.
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.
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.
That was my thinking. I did not expect the changes in Access or Outlook. Maybe try uninstalling the last change and see what happens.
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.
Well you do stop Windows by pressing the Start button right?
Sign in to post your reply or Sign up for a free account.
Similar topics
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...
|
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...
|
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...
|
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?...
|
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...
|
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 {...
|
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...
|
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.
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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)...
|
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...
|
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....
|
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
| |