I found this thread by doing a Google Search about two months ago.
Bytes.com/Absolute Position of a Control
I downloaded the sample code and learned alot from it. Now, I'm coding a database that requires something unique for the end user here at the Company where I work. The End User has to filter the data in a table that changes at the End of Every Month by adding strings of what NOT to return. (NOT "*B22*, NOT"*B02*")....
shiznaw
Last Activity: Apr 8 '16, 09:09 PM
Joined: Jun 9 '07
Location:
-
Modify Zoombox for use with tables
Last edited by zmbd; Feb 5 '16, 11:59 PM. Reason: [z{Please post new questions in new threads, link to the old thread for context}] -
Thank you very much for solving a problem that comes up when beginners like me begin to program. I appreciate your knowledge.
Thank you again for chosing to share. Your answer worked when placed in a form.
Shiznaw 11-24-09 -
Would it be simplier if he were to simply create a query and set the dates of the query to parameters / fields on the form? or no?...Leave a comment:
-
MS Access - VBA - How do you Delete?
So, umm...how do you delete a record on Form A while on Form B?
DoCmd.RunComman d acCmdDeleteReco rd ..but where, how?
--shiznaw -
thanxs...now i'm reconsidering the whole thing altogether...Leave a comment:
-
I fixed it...I'm getting better at answering my own questions...'ca use I suck ne ways... The following listed below is a tweak
Private Sub Unid_AfterUpdat e()
Dim con, rs As Object
Dim stq As String
Set con = Application.Cur rentProject.Con nection
stSql = "SELECT * FROM [Students]"
stSql = stSql & " WHERE [Unid]='" & Left([Unid], 8) &...Leave a comment:
-
MS Access - VBA - Subform null.value problem
So, here is the deal... I have a SubformB within FormA. [FormA]![Unid] is a field on the form that searches Table1 to offer the end user choices from a drop down list. Once the user chooses an offering within the drop-down listing, the field is populated with that choice and the following happens:
Private Sub Unid_AfterUpdat e() <~~~ on FormA
Dim con, rs As Object
Dim stq As String
Set con = Application.Cur rentProject.Con nection... -
Thanxs for clarifying. I needed that. so, umm....you guys should start charging!
shiznaw...Leave a comment:
-
VBA - Saving Current Entry ?!?
Is the following correct?
DoCmd.DoMenuIte m acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 ' to save
DoCmd.GoToRecor d , , acNext ' to auto next
Me.Requery ' requery for the hell of it
shiznaw -
MS Access - VBA- NZ (Null) General Question
I just wanted to ask whether this is the best way to reset or clear data out of a form field?
Me.cCode.Value = Nz(Null, Null)
--shiznaw
univ. of utah -
what you just posted is, in actuality, the Julian Date. And had saved the rest of us, approximately 52 lines of coding otherwise.
Thank you, Neopa. No, seriously...Tha nxs
Shiznaw
Univ of Utah...Leave a comment:
-
Thank you for your help....
shiznaw...Leave a comment:
-
MS Access - VBA - Generate Autonumber
So, umm. How would you generate an alpha-numeric autonumber
each time an end user clicks a field/button on a form without using
the autonumber option within a table. -
MS Access - Fiscal Yr-to-Date VBA Code
I think I got it: How to establish the Fiscal Year-to-Date Parameter in VBA
Dim fscldate as Variant
----------------------------------------------------------------------------------------
If Date < Format("08/01/" & Year(Now)) Then
fscldate = Format("08/01/" & Year(Now) - 1)
Else
fscldate = Format("08/01/"...Leave a comment:
-
MS Access VBA - Dates
I got another problem while working on this database for the Univ.
The Form.viewreport s has several radial button options so that the user can
view a Report for several periods--like a day, a week, a month, etc. The frame is linked to a select case statement.
The user is also able to choose the radial button options: "fiscal year" and "fiscal year-to-date" reports. The fiscal year for the... -
NEver mind...I'm an idiot. Its DateAdd() method. Took out the extra crap. Thanxs anyway.
---shiznaw, the Scripts Villiage Idiot...Leave a comment:
-
MS Access - VBA - Add 1 Month to Current Date
Private Function rprtdate()
Dim rprtdates As Date
Dim 1mnth As Integer
1mnth= Month(Date) + Month(DateSeria l(Year(Date), Month(Date) + 1, Day(Date)))
Select Case Frame35.Value
'the following if end user choses one month from the day chosen for reporting period
Case Is = 3
rprtdates = Format(Calendar 1.Value, "mm/dd/yy", vbSunday)
[Beginning] = rprtdates
... -
GOD bless you for being a super genius !...Leave a comment:
-
MS Access Splash Screen
Is it possible that I can create a splash screen when an end user opens the database? Anyone? Anyone?
---shiznaw
Univ. of Utah -
This works !! I also found some other methods.
--shiznaw...Leave a comment:
No activity results to display
Leave a comment: