A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Rec. Nav. problem cause by checkboxes/Conditional formatting



 
 
Thread Tools Display Modes
  #1  
Old March 22nd, 2005, 04:59 PM
Shelbygt22
external usenet poster
 
Posts: n/a
Default Rec. Nav. problem cause by checkboxes/Conditional formatting

Hi everyone,
I have a problem that I realy dont understand with one of my forms for
the inventory. I use Access with SQL server, all my tables and stored procs
are on my SQL db. Since last week everything works great since I add a
checkbox on my form. My form as a unique table dbo.Inve and 5 subforms based
on stored proc, anyway the problem is not there. I also have a command bar
with button like delete, add, print and modify. When you open the form, all
the fields are locked, the only way to modify a record is to click on the
button Modify and then change the information you want and click OK after. My
form has 2 checkbox and last week I add one more that when you click on it
the field IdInventory is highlights in red with the Conditional Formatting in
the Format menu. So in grid mode I can easily see what records are affected.

The problem is that when you click on the modify button to unlock the fields
and then click on one of the 3 checkbox and click OK my form is stuck(jam) on
the record like he's doin a loopback. This only happen if I click on a
checkbox, if I modify any of the textfields it's ok I can navigate thru other
records. But if I click on one of the 3 checkbox I'm stuck on the record.

In debug mode, on the Form_Current event he pass 2 times instead of one
normally. The first time he pass with the IdInve of the next record like
usual and then he pass again with the IdInve of the rec that I modifyed. And
like I said previously he only do that if I click on one of the 3 checkbox.
If I modify anything else its ok. On my other forms, if I modify a checkbox
its ok too. It's only that ...... form who have this problem.

I try to delete them and re-add after, same problem. I even use my backup (2
months old, so before this ... happen) same problem.

I try the /Decompile and I still have the problem. Now I will try in design
mode to delete all of the existing Conditional Formatting in the Wizard to
see if it could work. But one thing still bizzar to me, why only me and my
boss have this problem, what do we have in common that make this thing
happen. My boss run winXP and me NT4 SP6. Still searching for solutions.

This is very weird it can only happen to me. All my computer here are on
NT4-SP6

Please help me................................................ ......

Thanks !
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Strange problem with different networks. Adam General Discussion 1 March 13th, 2005 10:17 PM
IE6 & Outlook Problem (Strange Problem)! KW Outlook Express 4 February 1st, 2005 08:31 AM
Reinstalling OE... KAR Outlook Express 24 August 21st, 2004 06:52 PM
Productkey problem when installing office 2003 on network Stefan Schreurs Setup, Installing & Configuration 1 June 1st, 2004 11:16 PM
Fromatting Problem w/ Document Created in Works Inky Formatting Long Documents 2 May 4th, 2004 04:22 AM


All times are GMT +1. The time now is 05:08 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.