Latest activity
-
TYou also don't need DISTINCT as Access won't let you create two objects of the same type with the same name ;) FWIW I prefer to filter...
-
RonPaii replied to the thread self-referencing table with bridge.Have you ever known an accountant that wasn't a purist?🥸 -
isladogs replied to the thread Prompt for name.You also don't need DISTINCT as Access won't let you create two objects of the same type with the same name ;) FWIW I prefer to filter... -
MarkK replied to the thread AI Options.If you experience AI as sweet-talking you, ask harder questions. If you ask AI to validate your process, it will, even if that process... -
MarkK replied to the thread Prompt for name.And with a single table you can omit the table name, like.. SELECT DISTINCT Name FROM MSysObjects WHERE ParentId = -2147483645 AND Not...
-
MMark_ replied to the thread Solved Form "Losing colours" - nVidia Card Installed.To add to Doc's comment, in the video settings you can also select number of colours. I remember this because one user had set theirs to...
-
The_Doc_Man replied to the thread AI Options.WOW! You got a relatively straight answer from it. I'm impressed. -
MarkK replied to the thread self-referencing table with bridge.I think this is true from a purist perspective, but it's convenient to just sum a single field as opposed to summing credits, summing...
-
CHere are my accounting system tables. • Journal rows that are in Invoices and Bills require a linked Payee, enabling creation of a...
-
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 "...
-
MarkK replied to the thread AI Options.I once asked an AI why it sucks so bad at VBA, and it explained that VBA is wrapped in a file type that requires opening an application...
-
RonPaii replied to the thread self-referencing table with bridge.There should not be any negative GL postings.
-
SUse message box strDocName = inputbox("Enter Report Name","Report ID:" & me!recordid,"Report A") A custom form with a combo box listing...
-
MarkK replied to the thread self-referencing table with bridge.Here are my accounting system tables. • Journal rows that are in Invoices and Bills require a linked Payee, enabling creation of a...
-
-
Ttvanstiphout replied to the thread VBA Alternative to a Slow Query Chain.For another perspective on inventory functions, take a look at the Northwind 2 Dev Edition template, and this video where Kim Young...
