RonPaii's latest activity
-
RonPaii replied to the thread Form Design to Allow Multiple Selections (Add your Ideas).I added a empty combo box control to better emulate MVF. Using the KeyDown and Click events to open the FakeMVF_Control and the... -
-
RonPaii replied to the thread Form Design to Allow Multiple Selections (Add your Ideas).I made 2 changes to your example to open the FakeMVF_Control over the button that opens it from frmUsersADO. frmUserADO, pass the Left...
-
RonPaii replied to the thread Another Input Box replacement.I did some cleanup on frmdInputBox to tighten up width by removing some RTF codes before calculating the space requirements...
-
-
RonPaii replied to the thread Save a Report as a PDF with custom filename.If any chance this will be done multiple times per JobID, add a loop to create revisions. Dim Filename As String Dim FilePath As String...
-
RonPaii replied to the thread Another Input Box replacement.frmdInput_Box had an un-needed validation on both the rtf and plain text boxes. For some reason they work on x64 but not x32. I am...
-
RonPaii replied to the thread Another Input Box replacement.You are correct sir🤷♂️ I was looking for InputBox defined somewhere.
-
This is my version of an input box form and function to replace the built-in InputBox. Features RTF prompt with resizing to fit...
-
-
RonPaii replied to the thread Solved Tab in RTF control.Thank you all for your input. I changed the font for the prompt to the fixed width font Consolas to allow using spaces to simulate tabs...
-
-
RonPaii replied to the thread Solved Tab in RTF control.I enable wheel mouse using a variation of Allen Brown's DoWheelMouse function. Most of my users want some wheel mouse functionality for...
-
RonPaii replied to the thread Solved Tab in RTF control.I have an input box function that takes the same input as the built-in function. The function controls my input box form opened as a...
-
RonPaii replied to the thread Solved Tab in RTF control.I have tried the following. "Invoice amount:" & vbTab & amount No space between : and the amount "Invoice amount:\Tab" & amount...
-
I am displaying static text in an un-bound RTF control on a message box form. Is there anyway to imbed tabs in that text built up with VPN?
-
RonPaii replied to the thread Solved Form Filter in VBA.If you are looking for the current month, use Month instead of DatePart. (Year(tblAppointmentList.AppointmentDate)=Year(Date()) And...
-
RonPaii replied to the thread syntax error with null values.True, the PARAMETERS section is not needed, but I like to be complete. With defined and typed parameters, passing improper types to the...
-
RonPaii replied to the thread syntax error with null values.I always try to use parameters, they allow me to lock down the types and values being passed to the query. ' Using Value for TheName...
