Hi Nej,
I haven't understood exactly the nature of your problem but you are probably right. The easiest solution would be a global variable but you would need to be cautious of how to handle it in the case you would want to use mupltiple instances of your form (either now or in the future).
I think the best principle to follow (once you have understood the behaviour of split forms - which by the way is not a good behaviour...
geosmy
Last Activity: Oct 19 '10, 03:56 AM
Joined: Aug 21 '09
Location:
-
Hi Nej,
To my understanding when access loads a split form it loads two instances of the form. One instance corresponds to the main form and one to the datasheet part. The main form is the main instance (default) on which events such as "On Load" and "On Open" fire at startup.
When focus is on the main form the events that fire (like "OnCurrent" ) correspond to the instance of the main form....Leave a comment:
-
All I am looking is to emulate the behaviour of the built-in Seach Textbox in Access 2007 forms.
In this Textbox as one types Access marks in real time the first occurence of the search string inside the form fiels. This is done without losin focus on the search textbox and without the cursor leaving it.
Alternatively are there any available classes out there that customise this search textbox?Leave a comment:
-
Is it possible to highlight text in a TextBox without setting focus on it?
Hi everyone,
Is it possible to highlight (a portion of the) text in a textbox without setting focus to it. What I'm interested is marking some portion of the text for reference while my cursor is still inside some other control. -
Sounds interesting. Maybe there could be a workaround for my issue (current event not firing in subclassed form) through table events...
When I get hold of access 2010 I will check it out.Leave a comment:
-
Hi Megalog,
I tried disabling the nav buttons and navigate through the datasheet but no luck.
I experimented with the orientation of the form (datasheet top, bottom...) and I noticed that when the nav buttons are attached to the proper form they work properly but when they are attached to the datasheet the problem is still there.
I think that the core of the problem is navigation through the datasheet...Leave a comment:
-
I saw that post and that's how I found out that Split Forms do not hold module variables. It was very helpful in understanding why this problem occured (the Current event not firing - this is how this issue started) but unforunately I could not see any workarounds.
I tried referring to the Form as Forms!Form1 instead of Me but that didn't work.
If you test in Access 2010 please let me know. I am very interested.Leave a comment:
-
Split Form does not hold Module Variables in Access 2007!!!!
Hi everyone,
First post here!
I have been trying to upgrade to Acc2007 looking forward to using Split Forms.
To my horror I have just discovered that Split Forms do not hold variables at module level!!! Although code is working perfectly well when in Single Form view, when switching to Split Form view... problems. This must definitely be a bug unless there are limitations to Split Forms (doubt it)....
No activity results to display
Leave a comment: