Search results

  1. vhung

    how to convert 0.475 to minutes as 28 mnts.

    Probably; 0.475*60 = 28.5
  2. vhung

    execution of this application has stopped due to a run-time error

    This sample is using loop... If Me.listObjects.Column(0) = "table" Then DoCmd.NavigateTo "acnavigationcategoryobjecttype", "acnavigationgrouptables" End If Also, could be OnCurrent DoCmd.NavigateTo "acnavigationcategoryobjecttype", "acnavigationgrouptables"
  3. vhung

    Which Sports do you like the most?

    Basketball is the game; Last 2018 Christmas Basketball League Civic Division Our Team got the Finals Championship;
  4. vhung

    Solved Display text field on Main Form after text entered on SubForm

    Right Arnel, the Else: should be = True otherwise the Else: has no function at all.
  5. vhung

    call subform validation from main form

    Nice "Parameter TagCharacter (String):" to "Validate Form controls are not null or missing"
  6. vhung

    Control a external program

    Good day... Nice attempt, SendKeys "{PGDN}{PGDN}" is enough for scroll down speed. Button: SendKeys "{PGUP}" is for 1 step, could be up and down fast scroll. However, if you have to open a PDF and scroll to the last page, Rather use the pdf header, number page box. See...
  7. vhung

    Insert 2 navigation control on top at same form

    Good day... There are several design for navigation form, and each choice would matter. See attached picz... This is cute and simple design in which you could add your favorite forms. On select, it would open a form and on click, "Close" button exit an open form.
  8. vhung

    Insert 2 navigation control on top at same form

    Nice, Horizontal Tabs, 2 Levels
  9. vhung

    Form - Select a certain entry

    racdata: "Is there a way to only display the Welding Tools to select the correct one.," On your Table, there should be a field, which has common name "Welding Tools" by this on select, the possible result is list of "Welding Tools". Hence "on Filter"
  10. vhung

    Solved Allow VBA edit even acForm menus is disabled.

    I change this command "DoCmd.OpenModule "Module1" 'replace with module that is present in your db" Into: Application.VBE.MainWindow.Visible = True Because the vbe open is password protected then use the CtrlG to open submacro Autokeys "^g" It's all done... I also add on a combo select =...
  11. vhung

    Solved Allow VBA edit even acForm menus is disabled.

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

    Solved Allow VBA edit even acForm menus is disabled.

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

    How I do i programatically force a record to update?

    EventProcedure: AfterUpdate= DoCmd.RunCommand acCmdSaveRecord
  14. vhung

    Guilty or Not Guilty? The George Floyd trial...

    A presumption of guilty verdict might not a result of thorough examination of evidences. Death of Floyd is not just simply breathless. A person lying on the street where three uniform police officers on guard, Before that, Floyd is inside the backseat. The person would not resist going out the...
  15. vhung

    Guilty or Not Guilty? The George Floyd trial...

    Derek Chauvin is guilty, The video records showed enough evidence, Which also taken captured by the people who witnessed the incident.
  16. vhung

    Solved Form: Colored Header, Footer, Detail, Alternate, Font

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

    Solved Form: Colored Header, Footer, Detail, Alternate, Font

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

    Solved Form: Colored Header, Footer, Detail, Alternate, Font

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

    Solved Form: Colored Header, Footer, Detail, Alternate, Font

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

    Solved Form: Colored Header, Footer, Detail, Alternate, Font

    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...
Back
Top Bottom