great, thanks JKing, thats all I need!
Have a good day!...
bluray
Last Activity: Sep 11 '07, 08:41 PM
Joined: Jun 21 '07
Location:
-
After hours of finicking I finally got it to work :D Thanks missinglinq and JKing! Here is the finished code:
...Code:If DCount("[AppID]", "tbl_VEH4b", "Forms![frm_VEH4a]![AppID]") > 0 Then Dim stDocName As String Dim stLinkCriteria As String stDocName = "frm_VEH4b" stLinkCriteria = "[AppID]="Leave a comment:
-
Thanks JKing, it looks like were on to something here!
I no longer am being sent back to the editor now, but Access is not recognizing the the query when I reference in in the
line. It is giving me an "Item not found in this collection" error. Would it work if I just planted the SQL query directly into the brackets?Code:Set qdf = db.QueryDefs("VerifyExists")
For example:...Leave a comment:
-
tried
andCode:Dim db as DAO.Database DIm rs as DAO.Recordset
and it is still having issues.Code:Dim db as ADO.Database DIm rs as ADO.Recordset
are "Database" and "Recordset" supposed to be default objects in these libraries? Or do I have to define them somewhere?...Leave a comment:
-
Check for Existence of Record THEN Open Form
Hello guys, thanks again for taking the time to help me out with my problems!
This problem seems super simple in my head, however getting the coding to make it work is turing out to be not so simple...
Basically what I am trying to do is have a Command Button check to see whether the current "Record ID" exists in the sister table before opening the sister table's bound form for editing when the user clicks... -
ok guys, works perfectly. I actually had to use advice from both your posts and this is the result:
...Code:' ############################################################# 'CHANGE THE ROWSOURCE QUERY IN THE ClassSelectLIST LIST BOX ' THEN REQUERY Private Sub AppPosition_AfterUpdate() If Me![AppPosition] = "Installer" Then Forms![frm_VEH4a]!ClassSelectLIST.RowSourceType = "Table/Query"Leave a comment:
-
you guys are great! ill give it a try right nowLeave a comment:
-
Dynamically Switch RowSource Query for Listbox Options
I have been fighting with this for a while, and I know someone on this board will be able to figure it out in a split second :)
I have a List Box and a Combo Box. Based on the selection the user makes in the Combo Box, I need for the Rowsource in the List Box to be changed to one of two queries, and requeried so the user can select an option from the List Box based on the newly selected criteria from the Combo Box.
I... -
oh nice find on the space in the hyperlink address option! now all of my pretty image buttons act somewhat like a real button :) now if only i could figure out how to get access to allow seperate images to display during mouse move and down to give it that much more of a real button feel.Leave a comment:
-
ok guys, so I have now implemented the script provided by ADezii and its works great. I only had to tweak a few things to make it fit.
The first thing was of course swapping out the "txttest" control name fillers for the actual names of my controls.
The second thing I had to do was add ;0;_ onto the end of my input mask so it recorded the mask data into the table as well as the user entered data. Otherwise...Leave a comment:
-
Create Custom Buttons in Access
Does anyone know how to create custom buttons in Access using embedded images? I thinking of creating a button that changes visibilities depending on the action taken by the user with the mouse (ie: seperate images that become visible when when not being hovered over or clicked, when clicking, and when hovering over the button).
I have latched onto this tutorial at: http://www.tek-tips.com/faqs.cfm?fid=5307
...but I... -
I agree. However puppydogbuddy is right about how I botched the original rule I had in mind... can't wait until I reach the Zen level of designing databases you guys are at lol...Leave a comment:
-
oh wow thanks guys! Both excellent points :) I will test them out right away here and let you guys know how it works out.Leave a comment:
-
Validation Rules: Letter and Number Validation
Hello all, and thanks for taking the time to help me out here.
Basically, I am trying to set up a validation rule that correlates with an input mask where the user is required to enter select alpha characters followed by a series of numeric characters.
The input mask Auto-enters API, requires an alpha value in upper case, and up to 8 numeric values., as seen here:
"API"<L9999 9999
...
No activity results to display
Leave a comment: