Search results

Good morning Friend, Thank you for your help!! I really appreciate the time and effort you put here. I now have a much better understanding on these quotations marks in SQL queries. I will try debug.print later today - this is something I have seen but never thought about using. The code I...

Wow Thanks so much! So I was missing the "Form" in between... I had no problems referencing a value from another sub form using: Forms!MainForm![SUB FORM]!ANumber.Value Not sure why the syntax is different there - is there anything on the internet that I can read to learn more about these...

Hello Friends, I am receiving the following error when trying to call a public sub from another form. The code is as below: Forms![Main_Form]![Sub_Form].PublicSubCreated_Click Wondering what possibly went wrong here? I had no problem calling another function/sub within one form but seems...

Hi Micron, I got the same run-time error today. I think I found the problem after reading your post and yes, it was due to the codes not being correctly compiled. After running the compile under "Debug" and fixing the issue, everything is fine. I think if the VBA editor is closed, Access runs...

Haha... I couldn't put the entire post above in the title line. Original title what I wanted to achieve based on my poor understanding when I posted :) :D Have a good evening everyone (if you share a same timezone with me)

Thanks! It does help!

Hello Friend! Me.Requery didn't work but Me.Refresh did! I do not know exactly what Refresh does but I will certainly check out after work today. Thank you for your help! Allan

Could you please elaborate on how that can be done? The challenge for me right now is to pick up the "new value". Me.ActiveControl.Value returns the "old value". Thanks for your help! Allan

Hello Friends! Happy new year to you all! My form has a lot of fields which collect information that is used to calculate insurance premium. I designed the form for user to enter data and ideally when all data is entered, user clicks on a button that runs a macro to calculate the rate...

Thank you! I will certainly check out

Hey Paul - I just read an article explaining Status Bar Text. It seems really useful and certainly something good to know for future I think I will go with the harder way - I will set the default value and adjust the codes. Thanks everyone! :D

Thanks friend - I might re-design the form to create more space for labels.

Thank you Paul! I have tried Input Mask - which showed "slashed" in the field. ControlTip does what I need here but it seems like user needs to hover mouse over to the field for about 2 seconds until the text(mm/dd/yyyy) shows. Are we able to make the text show quicker? Thanks! Allan

Hello Friends! I have some fields for user to enter dates. There's two types of fields where one filed's format is mm/yyyy and another field's format is mm/dd/yyyy. The goal here is to ensure user is aware of the date format being used. (mm/yyyy vs mm/dd/yyyy) Is there an efficient way to show...

Found something under Tools -> Options -> Editor Format to change color of comment text. This should be good for now :)

Hey Friend, Our codes are shared by multiple users - I think the purpose was to highlight some of the codes(where we made changes) to stand out. Changing the theme might change the color of everything I assume? Thanks and sorry for not being clear.

Hello Friends! Wondering if VBA editor allows us to change the font color of the comments? By comments I mean the texts after '(single quotation mark) - by default it's green. Thanks! Allan:D

Haha, there's certainly a way as long as you can offer me a job! :)

Hey Adam - Are you in U.S? That rate is not possible in Canada but in the states I am not sure...I have heard the insurance rates are way lower in the states. :)

I had to use Google to see which city "The Hammer" was referring to. :D:D:D