Search results

Ok Arnel, Thank you very much I will try the steps you made.

Good day... Could anybody share help, to give tips on editing VBA While acForms default menus is disabled.

EventProcedure: AfterUpdate= DoCmd.RunCommand acCmdSaveRecord

Good Afternoon... We know that too much color use makes it bad. What I impose now is the suggestion that rather use the Post # 2 of mine. Only I still have the selection for single color change of Header-Footer.BackColor and Detail-Alternative.BackColor together in one click-select.

Good day sir... May that be, but the idea is to have an options of color if desired to change and select. For now, I already set fixed color selection as Theme for this acForm.

Thank you sir... In fact could make choices as many as could, while open the Form, However, on close it would go back to its default color/view. In addition, I wish to mix perfect colors and add it to default choices. It would be the next step, so that no more color mix experiment during use...

Thanks a lot sir... This is why I try to create this Continuous Form with combo selection of an "Access Form" parts. So that I may see the actual response of expert with this Screen Showing. Maybe there are times that while using an own program every day and that for instance may seems bored on...

Thanks... You made your points well. Yes, it would cause distraction to viewer, but that color is not constant on open. Colors would vary according to your choice, could be simple or more colorful, color choice be made through combo select and on palette button. You could change color of...

Thanks sir... Color choice and mix is possible according to your idea on colorful. This maybe done if need to set focus on specific field or item.

Thank you sir... The color on details and alternate could be change as you select on combo or on palette button. Any color choice is applicable. On every field, color is changeable only after change of choice, but constantly on close back to normal view.

Normal acForm View

Good Day... May this post annoying to AWF but all I need to know if this Design of acForm is accepted or not. Alternatively, maybe there is worse than this. \\: See attached acForm

Good Day... What makes difference with your "net share cost" and "net share quantity"? -difference between "transaction price" and "transsaction comm"? Hence: there should be, Transaction Net Profit = (Transaction Total - Total Cost)

Could this be? if InternationalCharacters = "a" then: InternationalCharacters = Replace(InternationalCharacters, "a", "[aàáâãäå]")

Or by using cmdOpenForm button then insert; DoCmd.OpenForm "FrmEventNewTrackPart": DoCmd.GoToRecord , , acLast MsgBox "FormLoaded goto LastRecord... " _ & vbCrLf & "ID: " & Forms![FrmEventNewTrackPart]![ID] & "= " _ & Forms![FrmEventNewTrackPart]![ranyfield], vbInformation

Could be applied using "Button" after open a form DoCmd.OpenForm "FrmEventNewTrackPart" then set on "Event Procedure" during "Form Load" that if last record is required always to viewed. DoCmd.GoToRecord , , acLast

Try: DoCmd.GoToRecord , , acLast

Good day... Checking Internet Connection Type using “vba” on “msaccess” is so wonderful. NAME: Check Connection Type ' AUTHOR: Mark Randol ' DATE : 4/29/2015 "modified by arnelgp for VBA use." I used: If chkConnectionType = "wi-fi" Then MsgBox "Your Internet Connection Type is {Wi-Fi}."...

Good day to you cpampas Allow me to join this discussion though it is too late. Please see the attachment if it will work for you or not.

Hacker names were trace down. Therefore, they are human. Maybe they set an automated program that runs over the Internet. Alternatively, bots run automatically, while others only execute commands when they receive specific input.