Latest activity
-
The_Doc_Man replied to the thread Write conflict.After looking at that again, the "preventing update" error is probably related to the repeated use of setting .Dirty to FALSE. In a... -
Ppekajo replied to the thread export time field to spreadsheet as hh:mm.Thank you all for your help
-
DDaveMD replied to the thread How to test for Large Number.It's clear from the follow-up responses that I did not correctly interpret the intent of the OP's post. My response was assuming the...
-
YYollem Crumble replied to the thread Write conflict.Ken - thanks for your reply. The database in mostly fully normalised but I found I was taking too long to create files to upload to our...
-
Ken Sheridan replied to the thread export time field to spreadsheet as hh:mm.Excel will still treat the expression as a time, and it will be possible to do time arithmetic on it, as with your example, subject to... -
Ken Sheridan replied to the thread export time field to spreadsheet as hh:mm.The DateTime data type in Access is implemented as a 64 bit floating point number, with zero representing 30 December 1899 00:00:00...
-
Sorry, I'm not thinking very clearly!! 😬 Increasing the detail height will not work here because it is a continuous form, and you will... -
mloucel replied to the thread Solved Form Size.The record source is filtered by the user, they need so many different reports, so I left those fields enabled but locked, so they can...
-
MajP replied to the thread How to test whether a form is opened as hidden?.To understand why this fails If CurrentProject.AllForms(stDocName).Visible Then The allforms collection returns a very different object... -
After a little while of moving things around, I had to go back to the original code, I just made 1 simple STUPID change. Instead of... -
cheekybuddha replied to the thread Solved Form Size.Sorry, I'm not thinking very clearly!! 😬 Increasing the detail height will not work here because it is a continuous form, and you will...
-
Actually, it doesn't look like you have a subform control. I'm not sure why you have only one row displayed unless you have filtered...
-
mloucel replied to the thread Solved Form Size.After a little while of moving things around, I had to go back to the original code, I just made 1 simple STUPID change. Instead of...
-
cheekybuddha replied to the thread Solved Form Size.Actually, it doesn't look like you have a subform control. I'm not sure why you have only one row displayed unless you have filtered...
-
Then add a similar expression for the subform control
