MajP's latest activity
-
MajP replied to the thread Create new child record with modal dialog?.This is annoying, but for some reason Access sets the default value property in the table properties for all numerics to 0 instead of... -
-
MajP replied to the thread Create new child record with modal dialog?.Pass the ID in the openargs argument of the docmd.openform In the forms beforeInset event set the foreign key to your openargs value.
-
MajP replied to the thread "Namespace" reserved in VBA?.Interesting. I did not know, nor did it even occur to me that you could use properties in a standard module. In all my time in VBA, I...
-
[OT] Note: There is a simple way (video) to set VB_PredeclaredId = True without using an additional function or editing the exported...
-
MajP replied to the thread "Namespace" reserved in VBA?.@riktek, You may want to look at the link discussed in this thread...
-
MajP replied to the thread "Namespace" reserved in VBA?.There will be no problem. NameSpace is a keyword in VB but has no meaning in VBA. If there was a problem then VBA would have to worry...
-
-
MajP replied to the thread Module variable.I still do not completely understand. But lets say sometimes you call jumpsomehoop and it does something, but when you pass it a form...
-
MajP replied to the thread Module variable.If it was something more complicated than that where you have lots of methods that need to use lots of common properties then maybe make...
-
MajP replied to the thread Module variable.What exactly does that mean? If you are calling this procedure RepositionForm me you could simply call the other procedures Procedure2...
-
MajP replied to the thread Two ways to access controls on other forms.FYI there is never a case where Bang notation is needed and cannot be done in dot notation. There are times when it provides shorthand...
-
MajP replied to the thread Two ways to access controls on other forms.As @theDBguy points out if you reference a form property through the class it will open a hidden version of the form immediately if the...
-
MajP replied to the thread Enter Parameter Value.SELECT tblpayrolltaxes.myuca, tblpayrolltaxes.[percent of withholding], tblemployees.democlientid...
-
MajP replied to the thread Access Item Genie demo for Organizing / Tracking your Items.You can use the column name or the column number to sort any query. The column numbers are 1 based (not zero) indexed. If you look at...
-
MajP replied to the thread Majp Search and Filter.I updated the demo to be a little more understandable. I added a menu and did formatting. There was so much going on I was confused on...
-
