Search results

it's alright. just that i'm used to subroutines before :D just kept the term i guess.

no i do get the basics just that am not used to unbound forms. the purpose of this was so that i can track the changes made within my unbound form to trigger the enabling and disabling of certain commands. but it's ok, thanks for your hepl. i found a different way.

tried it but not working with the function within the module.

and where would this code be placed?

how bout combo boxes?

how do you loop the onchange event? sample for each control onchange = subroutine next

the reason for the global vars is that i want to use it in where clauses form in vba sql statements so that a certain record (form, unbound populated by the sql statement) can be opened anywhere. although what pitfalls are there to global vars? is there anything i need to consider?

@VilaRestal exit for worked. thanks

so i got this code off a site, it's neat cause it loops through the form. but how do i add in the else statement so that it won't loop? because basically what's happening is for each field in the form is the insert being run. any ideas? NotFilledIn = False For Each ctrl In Me...

so am thinking of setting a global variable for records opened so that variable will be used on different where clauses throughout the sessions. any thing i should consider before doing this?

so yeah with single inserts it works but with multiple insert i get the error. i have this code but it's for my mysql back end, how would i adapt this to ms access? because the idea here is, there is a temp table within the front end that needs to be appended to the back end...

i tried the .addnew before and it works fine for me, what i would like to know is how this would be doing using an INSERT statement in vba? i have this right now but am getting an error "Argument not optional" i think my sytnax is wrong. Function ShowIdentity() Set db = DBEngine(0)(0)...

can anyone show me a shell or sample of how to insert using a vba while capturing the last autonumber inserted? thank you!

not really no, i have put this problem on the back burner for the mean time. do you know how to convert it with the access connection?

so i found this in the internet by allen brown, it works well but i need help adjusting it when using it with appended tables because i keep getting a 0 in in the result. Function ShowIdentity() As Variant Dim db As DAO.Database Dim rs As DAO.Recordset Set db = DBEngine(0)(0) db.Execute...

Set rs = CurrentDb.OpenRecordset("qry_employee") rs.AddNew rs.Fields("EMP_LASTNAME").Value = Me.txtLastName rs.Fields("EMP_FIRSTNAME").Value = Me.txtFirstName rs.Update rs.Bookmark = rs.LastModified lngPatientID1 = rs!ID_EMPLOYEE rs.Close Set rs = Nothing...

so i have this string: strSQL = "INSERT INTO tbl_school " & _ "(school_name, school_degree, school_major, school_startdate, school_enddate) SELECT (school_name, school_degree, " _ &...

hello i have a mysql back end. im trying to set a table within the front end so that when users open a record or create a record on the listbox it would first get entered into the table then queried out to the mysql back end when saved. any good ideas or sample i can look at for this one? thanks.

so i have this form that creates a schedule and the way i made it work is that the time is being taken from another form. odd thing is when i type in the time (short time) it works, hours are calculated between the start and end time. but when the field's value is carried over to the form (Which...

so i've been trying custom shortcut but i don't get this part of the tutorial. can someone help me? To create an shortcut menu, you first have to create aCommandBar object. The CommandBar object represents the shortcut menu. Then, you use the Add method to create CommandBarControl objects. Each...