Latest activity
-
Another year passes, and we are still up and running, despite all the difficulties and changes to the social, search and legal... -
isladogs replied to the thread How to test for Large Number.As stated above, both the code in post #2 and that in post #7 appear to give correct results in my tests However, here is the CoPilot... -
You can return the full address as a concatenated string expression in one query, and then base another query on that query rather than... -
then you are just Duplicating the infor already on the other table, thus, wasting space on your db.
-
Ken Sheridan replied to the thread Write conflict.You can return the full address as a concatenated string expression in one query, and then base another query on that query rather than... -
isladogs replied to the thread How to test for Large Number.The problem is that it doesn't actually check whether the value is within the large integer (BigInt) range: -9223372036854775808 to...
-
Ken Sheridan replied to the thread export time field to spreadsheet as hh:mm.I should have made it clear that this only applies to times under 24 hours. A value such as 31:05 returned in the example in my last...
-
DickyP replied to the thread How to test whether a form is opened as hidden?.This usage of the form as a settings source is probably not an ideal solution to your task as described. I would create a separate class... -
arnelgp replied to the thread Write conflict.then you are just Duplicating the infor already on the other table, thus, wasting space on your db. -
YYollem Crumble replied to the thread Write conflict.The query got overly complicated as it depends on so many variables. That is why I decided to ditch the query and just store it.
-
YYollem Crumble replied to the thread Write conflict.On further reading, updating the field through a beforeUpdate event causes an error. It needs to be done after the update so as not to...
-
YYollem Crumble replied to the thread Write conflict.Thanks - I think I understand that - I will experiment a bit more with the before and after update and see what occurs.
-
arnelgp replied to the thread How to test whether a form is opened as hidden?.you may try: If CurrentProject.AllForms(stDocName).IsLoaded Then If CurrentProject.AllForms(stDocName).CurrentView =...
-
The_Doc_Man replied to the thread Solved Form Size.In an OnOpen event, the object that holds the controls of the form/report is opened, but none of the controls have been loaded yet. It... -
arnelgp replied to the thread Write conflict.you don't need to Save the Full Address in your table, since it can be derived from the Other table. just link the two tables together...
