Search results

hi all, i could use some help here. ive got a form with a subform subform has 2 check boxes i have a button on the main form im trying to click the button on the main form to reference one of the checkboxes on the subform and click another check box on the subform based on the value of...

hi all, i could use some help trying to combine this code together to occur as one on_load sub routine. heres what we got: Private Sub Form_Load() Dim rs As adodb.Recordset Do While Not Recordset.EOF Dim sPath As String sPath = "N:\DRAWINGS\" & [Drawing#] & "-01_" & [DwgRev] &...

hi all, i have yet another unique issue that i could use some help with. i have a form that contains a sub-form that has a check box in it for each of the numerous records. the sub-form is a continuous form. i want to do a "on close" unchecking of any checked boxes so how can i tell...

hi all, i was hoping someone can help me with an issue. i have a form, that now has 2 checkboxes. one checkbox, when clicked, opens a file on my server based on some criteria --------------------------------------------------------------------------- Private Sub Page1_Click() On Error GoTo...

h iall, my code is corectly writing to the first table and set of fields correctly, now i want to add the ability to write to a second table with a different group of fields. what am i doing wrong here? it all should be done on after update. Private Sub Form_AfterUpdate() Dim cnn As...

im just about ready to shoot myself.... ive got this string of queries based on a table that use this function correctly. and i have a second string of queries based on a DIFFERENT table that will not work when i have the criteria entered. what am i missing? i think ive checked all the...

hi! how does one go about subtracting an [start time] from and [end time] to get a total of the difference in a usable format such as minutes? i keep getting wild decimals when i try to do this. please help!

hi all! im having some trouble doing some types of conditional formatting in VBA, let me lay out the scenario here and we can go from there. i have a report that requeries itself every 30 seconds as an updating display type of deal. there are forms within the database that contain pulldown...

I have a zillion forms in my database and I needed to develop an automated kill-switch of sorts to handle some specific user issues. I’m open to other ideas, but the main purpose is to close forms and even the database based on user inactivity. i do not want this to effect reports however. I...

hi all, i cant even attempt to write this one, so i would like some help if anyone can write this... heres the idea... 1) i want a FORM based piece of code that closes the form after 5 minutes of inactivity 2) i want to close the database when any pc goes to screen saver please help me...

hi all! please review the attached files for screenshots of my issue. the database i have here has worked forever UNTIL we upgraded to office 2010. that is the only difference and it still works on PC's that do not have office 2010. This is the error I am receiving on this code...

how do i create a totaling query that results in monthly totals? available fields: date category amount

hi! so i have a form for data entry and i am trying to reduce the duplication of user actions by having 1 field in my form write the same exact value to another "hidden" field on the form example: text 1 with control source A - is my visible text field where a user will input a value...

so i am trying to make a fancy version of a checkbook transaction register with access. i then realized that i have no idea how to write a calculated field that can add or subtract based on the balance of the previous record. anyone able to help me out here?

hello access guru's! heres my issue... i have a multi line report with a mess of fields in it. i would like to change the back color of specifically a field, a header, and a group based on the criteria of a field. so for example i tried this... on load if [field] = "word" then...

hey! any idea whats the problem here? see photo please. thanks!

hi! can anyone share with me a method to lock all users out of all access objects through a means other than merely hiding the navigation pane? please let me know if this is possible. thanks!

hi! how do i reference a field in VBA to compare values in an if statement, please help me with the []'s and ,'s and whatnot. my statement should read like: private sub after update if {textbox on form} {is = to or matches text} {field on a query or table} then checkbox = true end if end...

hi! a little background...i am a novice access user, learning as i go, so bear with me :) this may all sounds like a bit of crazy talk, but i could really use a hand in writing something that accomplishes the following in microsoft access 2010: i want to create a username and password...