How To Talk Dirty
Really cool to learn, but it's true for all dudes. 'How To Talk Dirty'
...What's the trick
I've tried everything I can think of to open a form from another form and
apply a filter with no luck. I'm using Access XP and have tried the
following from my main form:
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmPhotos"
stLinkCriteria = "VisitID = " & Form_frmVisit!VisitID
DoCmd.OpenForm stDocName , , , stLinkCriteria
I have also tried the following in this same routine:
Form_frmPhotos.Filter = stLinkCriteria
Form_frmPhotos.FilterOn = True
There are three records in the backend database (sql server ...Me.Dirty
Here is the setup of this monster database that we're using. We have an
Access frontend with SQL server backend. We have about 14 tables that all
link to one main table via main table's PK. To present this data, we have
forms that have 14 sub-forms on them (long story, but in order to get what we
needed, this was how we got it to work). We have the SQL server residing on
one server and then six laptops connect to that server via wireless router
(again, due to the mobility of the laptops, it has to be wireless). So at
one time, there are six users entering data, but never ...Form Dirty Property
I am having difficulty in exploiting the ‘On Dirty’ property of forms.
Sometimes it works as expected but, more often than not, changes to controls
bound to table fields fail to trigger the On Dirty event. I am then forced
to associate each amendable control with an After Update event. That
invariably works but, with a dozen or more amendable controls on a form, the
resulting code can look pretty clumsy. There is something that I have
clearly not understood. Can anyone enlighten me? I just want to take
appropriate action when any control on a form is updated or amended.
Peter ...Dirty Bits?
When I rebooted my computer (WinXP SP3) I got a bizarre message saying that
"The volume is dirty," apparently in reference to my external hard drive.
What the $%^& does this mean? And more particularly, must I do something
about whatever is "dirty" about that drive? When I did a google search I
found a reference to "setting the dirty bit," terminology which, I must
admit, seems to have more to do with connubial delights than with my
computer. of course, I also found ads hawking software which assuredly
(yeah, sure) would fix this and any other...dirty (?) footer
I have a form with several unbound field in it's footer (they will, after
verification, be added to the recordset);
I thought it would be nice to keep the "ADD" button disabled until the user
has entered info into all of the fields...
is there a simple way to add a check for this condition (all fields have
if len(field1 + field2 + field3 + ...) > 0 then
me.add.enabled = true
me.add.enabled = false
thanks in advance,
On Feb 20, 2:58 pm, "mark kubicki" <m...@tillotsondesign.com> wrot...Form Dirty not firing
I have a form that I enter and with the Load event I disable the Save
button. I want the button to appear as soon as the form is dirty. I
have done this before with no problems even with other forms in this
When I type in the first field, the Form Dirty event is not firing. I
have a msgbox statement in the Form_Dirty event and it never appears.
I have an AfterUpdate event on the first field and I test Me.Dirty in
that code. Me.Dirty is true in that test of the first field.
Why doesn't Form.Dirty fire? What do I need to look at that will help
me trace this issue? How can...Dirty Question
I have a question about the Dirty property/event=85
The following code will evaluate to False (which makes sense) when the
Private Sub Form_Current()
The following code will evaluate to True (which does not make sense to
me) when the record changes:
Private Function IsRecordDirty() 'tied to the on dirty event of all
In the Immediate Window I see:
Why is me.d...stupid Excel tricks
Here's a stupid sorting trick.
So, in an Excel worksheet, type in some integers in the following
format, the content of the inetegers is not important
Say these are cols A, B, and C, and rows 1 through 4 of
43 54 34
78 88 98
What is important is that you have a block with three columns
(well, any number seems to work) and following a block with two
columns, starting one column over (one less than the previous
seems to work as long as it's missing the one on the left).
Now, sort the first block (the three col wide block) on the second
You dirty bastards. I clicked on the "check for banks supported" by my
money product installed and i get this...
Direct Services* are the fastest, easiest way to connect with your financial
institution and have your statements automatically downloaded into Money
directly from your financial institution.
* This service is only available if you have Microsoft Money 2005. You will
need to use Microsoft .NET Passport in order to access your account
Your financial institution may offer an alternative means of downloading
statements and transactions from their web...Dirty Shutdown after Exchange database repair
Our Exchange database isn't being backed up (the back-ups fail), hence the
logs aren't being cleared. This has been going on for a while.
The backup reports are as follows:
Active backup destination: 8mm AIT
Media name: "Mon-04-01-2010"
Volume shadow copy creation: Attempt 1.
Backup (via shadow copy) of "D: "
Backup set #1 on media #1
Backup description: "Mon-04-01-2010"
Media name: "Mon-04-01-2010"
Backup Type: Normal
Backup started on 4/01/2010 at 11:04 PM.
Backup completed on 5/01/2...Error message if the form is dirty
Below is my code on click even of a cmdButton to fire off the before
update even of my form.But it produce error message if the form
is dirty :
'The setting you entered is not valid for this property"
And vba highlights the line "Me.Dirty = False".
If Me.Dirty = True Then
Me.Dirty = False
Why it's happen?How to trap it.
You get this message if the attempt to save the record fails.
For example, if you cancel the Form_BeforeUpdate event Access can't save the
record. Or if there is a required field missing, it can't save. When this
Has Howard seen or discussed the UK Jackass show called Dirty
Sanchez...it's pretty extreme. Makes Johnny Knoxville look like a
I posted a short Sanchez mpg over in the binaries group if you are
> Has Howard seen or discussed the UK Jackass show called Dirty
> Sanchez...it's pretty extreme. Makes Johnny Knoxville look like a
> I posted a short Sanchez mpg over in the binaries group if you are
I don't know "Howard", but I'm quite interested in "Jackass" et al being
banned since a 10-year-old boy...Favourite GP Feature
What are some of the members of this boards favourite GP feature or trick?
I am looking to compile a list of simple tricks users can learn quickly to
help them out.
Do an Interent seach for GP 50 tips and tricks. You'll get results from
Convergence 2010 presentations. some good tips in there. Also search for 50
more tips and tricks.
> What are some of the members of this boards favourite GP feature or trick?
> I am looking to compile a list of simple tricks users can learn quickly to
> help them out.
Try this blog for a da...Form Dirty question when used with unbound textbox and VB Code.
Hi all :)
For a certain situation I needed to use an unbound textbox to update a
hidden bound textbox.
This works ok but it seems that editing an unbound textbox doesn't trigger
to the Form_Dirty event.
Also updating the hidden bound textbox via VB code doesn't trigger the
Gladly I discovered that the Form_BeforeUpdate gets triggered before I move
to the next record,
so I could make a work arround to handle not having a Form_Dirty trigger
I am just curious if there is something I am not aware off that might be
done to trigger a Form_Dirty ...How to check the dirty state of a CPropertyPage set by SetModified?
Anyone know how to check the dirty state of a Property Page?
I have a pointer to a CPropertyPage and would like to know how to read the
dirty sate set by
SetModified for individual pages.
Todd Williams wrote:
> Anyone know how to check the dirty state of a Property Page?
>I have a pointer to a CPropertyPage and would like to know how to read the
>dirty sate set by
>SetModified for individual pages.
This is strangely absent functionality. I researched this myself a few weeks
ago, and CPropertyPage used to maintain an undocumented boolean ...Me.Dirty Problem
My form has Names with a checkboxes next to them, when I tick the checkbox those names are printed, the problem is I have to close the form and re-open it if I make any changes on the check boxes to print the correct selection. I think I have to have a Me.Dirty somewhere, any help would be good...thanks Bob Hi Bob,in the code to print, before you print:if me.dirty then me.dirty = falsethis will save changes if any have been made -- and, if not, you won't get an error ;)if you don't have code to print, instruct your users to save the record before printing (CTRL-S or click the diskette...Tips and Tricks XML
Anybody know where is the best site to learn Tips & Tricks programming for
...Me.NewRecord and Me.Dirty
Me.NewRecord and Me.Dirty
Is it possible for these both to be set at the same time?
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
For what purpose?
Microsoft Access MVP
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.
Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.
You can tha...Stupid formatting tricks
I have an Excel 97 spreadsheet that has a column of sizes. If I enter a
size range like 38 - 32, I have no problem. But when I enter 4 - 8, Excel
insists on interpreting that as 8-Apr. If I look at the format setting for
the cell, I find it has changed to Date format. If I change the format back
to General, I get the serial code for April 8th. Anyone know how to
override this? Thanks in advance.
format as text or enter with ' in front to make it text
"James Houston" <firstname.lastname@example.org> wrote in messa...Dirty Exit
I am having trouble with my DB closing and leaving the .ldb file open. The
users then cannot open the DB until the .ldb has been deleted manually and
the information must be re-entered. What script or macro must I use to make
sure this doesn't happen? I know it has something to do with the OnDirty
Many thanks in advance.
On Fri, 25 Jan 2008 12:29:02 -0800, F1stman
>I am having trouble with my DB closing and leaving the .ldb file open. The
>users then cannot open the DB until th...Set form dirty through unbound control
I have an unbound listbox (multiselect) on a bound form.
The listbox and its selection are populated via vba from a table.
I have an invisible helper txt field which is bound to a table.
The helper txt receives whatever is selected in the listbox by setting
its value property to the list box elements.
Unfortunately this does not make the form dirty. Apparently changing
the value property of a txt field does not trigger the dirty event but
only changing the text property of a text field does.
I can not set the text value of my little helper txt field because it
has to have focus ...Dirty Shutdown & eseutil utility
I've discovered that I have a bad database file for my exchange that is in a
dirty shutodwn state.
Most likely, my priv1.edb is all wacko - which of course, has caused my
exchange email to pretty much shut down and will not let me mount the mailbox
Anyhow...I've been attempting to run the eseutil /r <log file name> command
and it's not working because of a dirty shutdown.
I found the database was in a dirty shutdown (vs. a clean shutdown) because
I ran the eseutil /k priv1.edb and it told me.
Here's a little nibble from the results:
I am using a form that is unbound and know I cannot use the Dirty event.
What can I use in its place?
I guess I could use the AfterUpdate event however, there are a lot of
controls on the forms. I think what I could do is to open the form in a
state where a user cannot change control values but, must click an edit
button that will change the form to allow edits. User makes changes, update
button becomes visible, then is forced to save updates. Update made, button
hides, form clears.
I am just thinking out loud.
"box2003" <email@example.com> wrote in message
news:OR2##...On Dirty Event
Hi and TIA. I have a form in Single form view. Once the user changes a
value the OnDirty event fires as expected, They click my save button to save
the record it is saved. Now they see that they want to change something else
on the same form/same record. When they do this the OnDirty event does not
fire. Any suggestions are appreciated. Thanks!
If you change the process slightly to this:
The Save button has code like this:
If Me.Dirty = True Then
Me.Dirty = False
DoCmd.Close acForm, Me.Name
You wouldn't have any worries with the OnDir...