473,414 Members | 1,888 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,414 software developers and data experts.

Odd Behavior of entry fields (not allowing edits...)

tdw
206 100+
I have a form which, when originally created, was solely for the purpose of viewing an order, not editing it (there was a different form for that), so the Allow Edits property was set to "No". But today I added a few new fields (mostly check boxes) to the table, and to the form as a tool to track the progress on an order. Since I wanted those new check box fields to be easy to use, I put them on the View Orders form instead of the Edit Orders (View Orders is the most commonly used form). I changed the form's Allow Edits property to "Yes". Allow Additions is still set to "No." Then I individually locked each of the fields that I don't want to be edited from that form (i.e. all of the fields that were there before I added the new check boxes). The new check box fields are not locked.

Here's the problem: When I open the form, it won't allow me to edit the new fields either. But if I switch the form to "Design View", and then switch it right back to normal view, it works properly! Why should that happen? If I then close the form and open it back up, I have to do the same thing again: switch to Design View and back again. Does this make any sense to anyone? Other forms that have always allowed editing are still working fine.
Feb 4 '08 #1
2 1627
ADezii
8,834 Expert 8TB
I have a form which, when originally created, was solely for the purpose of viewing an order, not editing it (there was a different form for that), so the Allow Edits property was set to "No". But today I added a few new fields (mostly check boxes) to the table, and to the form as a tool to track the progress on an order. Since I wanted those new check box fields to be easy to use, I put them on the View Orders form instead of the Edit Orders (View Orders is the most commonly used form). I changed the form's Allow Edits property to "Yes". Allow Additions is still set to "No." Then I individually locked each of the fields that I don't want to be edited from that form (i.e. all of the fields that were there before I added the new check boxes). The new check box fields are not locked.

Here's the problem: When I open the form, it won't allow me to edit the new fields either. But if I switch the form to "Design View", and then switch it right back to normal view, it works properly! Why should that happen? If I then close the form and open it back up, I have to do the same thing again: switch to Design View and back again. Does this make any sense to anyone? Other forms that have always allowed editing are still working fine.
Try explicitly setting the DataMode Argument of the OpenForm Method to acFormPropertySettings. Of course if you do not state a DataMode Argument, it will be acFormPropertySettings by Default.
Feb 4 '08 #2
tdw
206 100+
Try explicitly setting the DataMode Argument of the OpenForm Method to acFormPropertySettings. Of course if you do not state a DataMode Argument, it will be acFormPropertySettings by Default.
Yep, thanks a lot. I wasn't thinking about the fact that the forms were being opened by a Macro, which had them set to open in READ mode. It's working now.
I know that's not exactly what you said, but your suggestion is what made me realize that.
Feb 4 '08 #3

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

Similar topics

4
by: Ed Young | last post by:
Here is an example of the behavior: ------- code start ----------------------------------- #!/usr/bin/python #bugtest - test of class attribute initiation class Config: a = 1 b = 2 c = 3
7
by: Michael Onfrek | last post by:
Hi! I'm playing with entry again and trying to restrict length of entry widget to certain number of character, so users cannot enter more character into it. Any ideas? Reg. Michael Onfrek
0
by: David Emme | last post by:
Win XP Pro Access 97 MySQL 4.0.x I'm attempting to convert a number of apps to MySQL backends. Having converted the tables from the MDB backend, I'm running into a number of differences in...
1
by: KC | last post by:
Hello, I am using Access 2002. WinXP, Template from MS called Orders Mgmt DB. I have tweaked this DB to work for our small co. It has worked pretty well up until I made the mistake of deleting...
7
by: Mike Livenspargar | last post by:
We have an application converted from v1.1 Framework to v2.0. The executable references a class library which in turn has a web reference. The web reference 'URL Behavior' is set to dynamic. We...
2
by: Certys | last post by:
Hello, I have a form where I only allow new records to be added. I enable this by setting the form property "Data Entry" to Yes. I want to access other records in the same table- to autofill...
1
by: Microchip | last post by:
Hi, all! I have a list of about 100 records, each with only three fields. I want to write a VB6 program to scroll through this list, and edit any of the rows or any of the fields within the...
7
by: riceking | last post by:
Is it possible to do the following and if so, how? In one table, I have a list of email addresses I know are bad and no longer work. Another table has a list of companies with contact people,...
7
by: CCHDGeek | last post by:
I have a subform that is searched according to a field value on the main form. The subform has mutiple pages and each page has a subform based off a query. Today when I logged into the main form,...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

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.