Latest activity
-
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. -
PUse 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 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...
-
-
GPGeorge replied to the thread Prompt for name.I agree with Ron. It's all about supporting the user. If you force the user to a) remember the EXACT name of the report, and b) type... -
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 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...
-
KI'm using the following code on a form with a command button. Instead of just opening Report A, I would like to be prompted for the name...
-
CIn this example, 2 transactions occurred on 2/12/2026: VISA credit card was used to purchase groceries at Costco for $100.00. A debit...
-
CClaraBarton replied to the thread self-referencing table with bridge.See... back to my junction table tblPost :cool:
-
CSomething like the following? tblAccount IDAccountNameDescription tblTransaction IDDescriptionTransDate tblPost...
-
RonPaii replied to the thread self-referencing table with bridge.Something like the following? tblAccount IDAccountNameDescription tblTransaction IDDescriptionTransDate tblPost...
-
CClaraBarton replied to the thread self-referencing table with bridge.I like Mark's best... Transaction to Post (one to many), Post to Account (one to one). 2 foreign keys in Post (transaction and account)...
-
Minty replied to the thread VBA Alternative to a Slow Query Chain.Hmmm - The most reliable way to make sure you capture the changes no matter where they occur would be a Data Macro. MS - Data Macro... -
Ken Sheridan replied to the thread self-referencing table with bridge.If I were to use a single accounts table I think I'd model the different account types as sub-types in a type hierarchy. That way every... -
Ken Sheridan replied to the thread self-referencing table with bridge.Coming back to the original topic of this thread, the following two 'append' queries are examples of how aggregated values from multiple...
