RonPaii's latest activity
-
This is a sample lookup input form. The calling functions takes the same type of input as a combo box. The sample form has 3 buttons... -
RonPaii replied to the thread Runtime Issue.At the start of your code you delete "NISFeatureData2". Then turn off error trapping in the function Then open the now missing...
-
RonPaii replied to the thread Solved Code not save when at runtime.Very little change that anyone can force Microsoft to put Access in public domain. MS Flight Simulator, which in no way competed with...
-
RonPaii replied to the thread Solved Code not save when at runtime.With source control you can branch the FE allowing you to work on new features while maintaining the production FE. When the new feature...
-
RonPaii replied to the thread self-referencing table with bridge.Have you ever known an accountant that wasn't a purist?🥸
-
RonPaii replied to the thread Prompt for name.My lookup function call would look like this with your query. Lookup("SELECT DISTINCT MSysObjects.Name " & _ "FROM MSysObjects "...
-
RonPaii replied to the thread self-referencing table with bridge.There should not be any negative GL postings.
-
RonPaii replied to the thread VBA Alternative to a Slow Query Chain.If the temp table has no primary key, any query using it will be read only. Fine for reports and lookups but a problem in a form.
-
RonPaii replied to the thread Prompt for name.Long ago I create a lookup form and function to make this type of input easer. The call would look like the following Lookup("Report...
-
-
RonPaii replied to the thread Prompt for name.Use message box strDocName = inputbox("Enter Report Name","Report ID:" & me!recordid,"Report A") A custom form with a combo box listing...
-
RonPaii replied to the thread self-referencing table with bridge.Something like the following? tblAccount IDAccountNameDescription tblTransaction IDDescriptionTransDate tblPost...
-
RonPaii replied to the thread self-referencing table with bridge.I originally made the mistake of doing negative amounts, luckily an accountant put me straight and showed me how to do reverse postings...
-
The AI - like me, these days - sometimes gets confused about specifics. We have seen "Chattie" give you VB answers for a VBA problem...
-
RonPaii replied to the thread self-referencing table with bridge.I still don't like that structure; it encodes information about the account type in the table name. IMO have a single account table and...
-
RonPaii replied to the thread self-referencing table with bridge.I think it should be row for each type of account not table.
