I have a form in (Access 2002 File Format) that has 61 combined Text
boxes, Combo boxes, and List boxes... 11 of those fields are in the
Form Header, the rest are in the Detail area... I also have 43 Command
Buttons in the detail area, each with a "strtextval " code to a certain
text box... 10 of those Command Buttons are in the Form Footer area,
with a macro assigned to them to go from page to page....
I duplicated this form, so that I can have a Data Entry Form, and a
Non-Data Entry Form...
My problem exists in the Non-Data Entry Form... Once I open the form
and search for a RecNum and find it, it won't let me update
information. (i.e. Name, State, Phone Number, etc...) The only way I
can update this info is by choosing one of my Command Buttons. Once
the Cmd Bttn executes, I have to delete what the Cmd Bttn just did, in
order for me to go ahead and update any other info on this form.
On the Default Open Mode I've selected the Shared option, and on the
Default Record Locking I've selected the Edited Record option.
Do I have to many fields on one form?
I've created Forms similar to this one in Access97 with no problems...
Thanks for taking the time to read this... I appreciate your help..
Mike G.
1  1459  mi************* @aig.com wrote: I have a form in (Access 2002 File Format) that has 61 combined Text
boxes, Combo boxes, and List boxes... 11 of those fields are in the
Form Header, the rest are in the Detail area... I also have 43 Command
Buttons in the detail area, each with a "strtextval " code to a certain
text box... 10 of those Command Buttons are in the Form Footer area,
with a macro assigned to them to go from page to page....
I duplicated this form, so that I can have a Data Entry Form, and a
Non-Data Entry Form...
My problem exists in the Non-Data Entry Form... Once I open the form
and search for a RecNum and find it, it won't let me update
information. (i.e. Name, State, Phone Number, etc...) The only way I
can update this info is by choosing one of my Command Buttons. Once
the Cmd Bttn executes, I have to delete what the Cmd Bttn just did, in
order for me to go ahead and update any other info on this form.
On the Default Open Mode I've selected the Shared option, and on the
Default Record Locking I've selected the Edited Record option.
Do I have to many fields on one form?
I've created Forms similar to this one in Access97 with no problems...
Thanks for taking the time to read this... I appreciate your help..
Mike G.
What command are you using to open the form? Sounds like you are opening it
ReadOnly. If one of your command buttons alters a value then the ReadOnly
option is overridden (for that record).
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: John |
last post by:
Hi,
I've recently upgraded from Access 97 to Access 2002 & the performance
basically stinks. I have tried the following items listed below but it
has only had a minor impact:
1) Upgraded Jet 4 to Service Pack 7
2) Set Subdatasheet Name to from
3) Shortened the file name of the .MDB file
4) Made sure the Track name AutoCorrect info is...
|
by: Richard |
last post by:
Hi,
I have a form that take some time to load due to many comboboxes and at
least 8 subforms.
When I filter or sort the main form I get an error message and then Access
shuts down. They ask if I want to send the error report to Microsoft. Has
anybody seen this type of error message and what can I do to prevent it from
happening. Am I doing...
|
by: Sabine Oebbecke |
last post by:
Hi Experts!
I have several forms and reports where controls get their values with
'Forms!MainForm!Control' or 'Forms!MainForm!Subform!Control' resp
'Forms!MainForm!Subform.Form!Control' which works without any problem
in Acc97, 2000 and 2002, but now in Access 2003 there seem to be a
problem with this.
A user is working with my app, and...
|
by: Wayne Aprato |
last post by:
I have a simple database which was originally written in Access 97.
When converted to Access 2000 file format it ran flawlessly in Access
2002. I've just tried to run it in Access 2003 and I am seeing the
following behaviour:
Some of the fields on the continuous main form which is a list of jobs
with their related details "flicker". While...
|
by: Peter Frost |
last post by:
Please help
I don't know if this is possible but what I would really like to do is
to use On Error Goto to capture the code that is being executed when
an error occurs.
Any help would be much appreciated.
Thanks in advance
| | |
by: J |
last post by:
Hi,
Ive got 3 forms, (a subform within a subform within a form) and when I
refresh the outermost form, Access closes and offers to send an error
report.
The forms worked fine a few weeks ago, but now they cause this error
in Access 2002 (Access 2000 is fine)
Each of the sub forms use values from their parent forms to produce
results.
|
by: Neil Ginsberg |
last post by:
I have a client who is using Access 2002/2000 (the database itself is
written in 2000), and is considering migrating to Access 2003. Any
recommendations on whether Access 2003 is worth the migrate, or should he
stick with 2002?
Thanks!
Neil
|
by: Neil |
last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is
upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server
at the same time. We're moving to SQL Server 2005, and, since he already has
licenses for Office Pro 2002, he wants to upgrade to that.
I've been saying that we need to upgrade to Access...
|
by: Frav |
last post by:
The Reps team have been experiencing that Access 2002 unexpectedly
quits
while working and also lots of Corruption Failures and "Record lock
can not
update" messages since the upgrade from Windows 2000 and Access 200 to
Windows XP and Access 2002 (XP) was done.
Now, they are working and at anytime in anywhere of the application
access...
|
by: rhobson2 |
last post by:
Hello,
I wrote a database applicaiton using Access XP (2002) and everything
has been working good for the client until they purchased a couple of
new computers with Access 2003.
The meetings form has an unbound combo box listing all the meetings in
the database allowing the user to navigate between meeting records.
The meetings form also...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
| | |
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
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 then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
