Search results

i am trying the breakpoint, but i do not quite understand it. it's odd that only 1 of my passwords work.

Private varArray(1 To 9) As String Private Sub Form_Load() Dim db As DAO.Database Dim rst As DAO.Recordset Dim i As Integer Set db = CurrentDb Set rst = db.OpenRecordset("Employees") i = 1 Do Until rst.EOF varArray(i) = rst("Password").Value i = i + 1 rst.MoveNext Loop rst.Close Set rst...

do you know of any coding that does the same thing except i preload the passwords into the VBA coding? this works great for 1 of my passwords, but the reast are not triggering the command button to enable.

i corrected it. i just added Me.commandbutton.enabled = false on the form load. thanks!

that code works great when i type the incorrect password in the text box. but yet the button remains enabled when i do not select the text box at all and on the load of the form itself.

say the password is cat. then the button remains disabeled until the full word of cat is typed.

i have a command button on my form that i do not want to be enabled until 1 of 10 or so passwords are typed into a text box on the same form. i wish that i had more insight on this then the zero i have, but i am pretty lost on this one. is anyone able to assist?

i have a form that generates emails and the end user has the option to select upto 20 "lines" to display in their email. problem is, the user may not be utilizing all 20 options and possibly only 1 or 2. what i would like is if the user selects any less than 20, than the remaining "Employee...

thank you boblarson once again! also, do you by any chance know the coding so that whomever is using this form, their default OutLook signature will be apart of the email?

how about if all the contents of my subform where within my main form and then for the "HTMLBody =" i would have multiple Me! or Me. in one line. i tried that before. for example: Me.text1 & Me.text2 & Me.text3 & Me.text4 and this would kick back errors as well. for the record my current...

do you know of anyway to possibly accomplish what it is i am trying to do?

i am about ready to give up on a project i am attempting to complete. i have a form that is going to be used for generating email and within this form is a subform. the subform is viewed as a continuous form. what i would like is to take the contents of this subform and send them as the body of...

i don't know if a report would be possible for me either as my form is unbound. and the subform that i am trying to send as the body is unbound.

do you happen to have a sample code of how to include the report as the body and not an attachment?

i have some coding in my form as follows: DoCmd.SendObject objecttype:=acSendForm, _ ObjectName:=strDocName, outputformat:=acFormatHTML what this does is send one of my forms as an attachment in my email form. what i would like to doe is have this form (which is in continuous...

could the problem be that i am using Access 2003 and my default Outlook is 2007?

I have a form with 20 Combo Boxes in it organized vertically. my goal here is to have only 1 combo box appear on load and not have the second one appear until there is a value selected in the first one. and so on for the third, and fourth, and fifth, etc. these combo boxes are placed within a...

alright, now i am getting a compile error in regars to the Dim appOutLook As Outlook.Application line.

as always you saved me from another problem i was having. i have yet another thing i would like too accomplish on this... on my form i have a text box, and between MyDate and test, i would like to have the values of this text box displayed serated by commas (the values in the text box are...

thank you very much. that did the trick. now i am running into another problem. no error being given this time... but i would like to have a space between these two. the end result being: "5/25/10 test" rather than: "5/25/10test"