Most excellent.
Can I throw a couple of thoughts out there?
"Take heed mine child and keep thine Immediate Window (ctrl+G) close at hand, for the BreakPoint draweth nigh."
"Be vigilant and never waiver in thine Watches as thou preparest for Deployment."
I still do the DJ dance. Mostly at home or over internet radio these days. Haven't actually been to a rave in ages but haven't been able to let go of the music....
I have a six year that lives with his excuse for a mother but I pick him most weekends. I enjoy spending most of my spare time with...
I never thought I'd say this but..... I couldn't agree with Colin more. It's a media circus. I'm going to paraphrase and widen the scope of the statement a little though:
This whole Administration is a little over the top, even for my tastes.
That's going to be an additional criteria in the execute statement.
Look at the MyQuantity variable at the beginning of the OnClick sub. You're going to do this for another variable called MyCondition and then add a tblAT.Condition = '" & MyCondition & "' criteria to the WHERE clause of the...
Your refresh command button stopped working?
Ahhhhh yes. there it is:
Me.sfInvDetail.Refresh
Exit_RefreshMe
Exit Subshould read:
Me.sfInvDetail.Requery
Exit_RefreshMe:
Exit SubOoops. There's some real help for you. Can't even debug my own code. :rolleyes: I've changed it in the...
O.k. I got that error taken care of. "Me.sfTblAT.SKU" wasn't a valid object so I got it pointed right for you.
Just copy and paste the code from
Changes in Red
See Below for Blue
Private Sub Add_New_Record_Click()
On Error GoTo Err_Add_New_Record_Click
Dim MyQuantity As Byte...
Do Not Store Calculated Values!
http://allenbrowne.com/casu-14.html
As for not updating? You're probably not pulling any records with your criteria.
Put a break point after your execute fires and debug.print (Or ? me.quantity) your variables in the Immediate window (CTRL+G in the VBA window)...
Not the natives. No. I've never been to Iran.
I have known a few Iranians that immigrated here to the states. They are in fact decent hard working individuals. That goes for the Detriot natives I've known as well.
I wouldn't be caught dead in Iran only because of the political fires that seem...
If you want my opinion it's because of the small percentage of unsavory individuals that hold the world's problems against US.
Similar to the small percentage of unsavory individuals here that make US such a hostile country to visit....
Also, I would like to hypothesize that since Colin...