Recent content by johnlatona123

alright, ive spent all morning surfing the web for solutions to my problem, and maybe ive found one, i dont really know. ive tried many methods that i have come across and maybe i am just not referencing things correctly, but in any event, i could use some help here. i still need to do the...

also, this code is not providing any errors, it runs smoothly other than the fact it doesnt do what i want it to do. ha!

thanks for the links, ive played with the idea further and heres where i am at: Private Sub Command140_Click() Dim rs As adodb.Recordset Do While Not Recordset.EOF If Me![master subform].Form![verify] = True Then Me![master subform].Form![Page1] = True End If Recordset.MoveNext...

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] &...

thanks guys, that was the solution to my problem, much obliged.

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...

aha! i got this working....check it out.... Option Compare Database Option Explicit Function FileOrDirExists(PathName As String) As Boolean Dim iTemp As Integer On Error Resume Next iTemp = GetAttr(PathName) Select Case Err.Number Case Is = 0...

im willing to do whatever method will work, and i appreciate you helping me through this. ok, the looping thing makese sense, the verify check box is currently bound to make it record specific, however no data is stored in it ( all records have this false) for the sake of the verification...

ive been putting the code on open on the main form, does it need to be on the subform?

the [verify] item is a check box on the subform (1 for each record) cant quite get it working, any more ideas?

Are you using a main form and then your continuous form records are in your subform? yes. so i tried this on open/load: Private Sub Form_Load() Dim yourfilePath As String yourfilePath = "N:\DRAWINGS\" & [Drawing#] & "-01_" & [DwgRev] & ".dwg" If Len(Dir("N:\DRAWINGS\" & [Drawing#] & "-01_"...

can you rephrase that stamemnt using this? "N:\DRAWINGS\" & [Drawing#] & "-01_" & [DwgRev] & ".dwg"

access 2010. when the form opens, all records need to be validated before the form loads. the structure is that there is one main record in this example that has multiple sub-records

so not sure how to write it, but my thought is to write something like: when the form opens validate file path for each record in the continuous form, if file paths are good, check the box for each record that is good, if file paths are bad(no file found), then dont check the box for each...