Forum Discussion
FindFirst not working
I have a 365 database with the following code: Set rst = CurrentDb().OpenRecordset("SchedFieldTable") mFID = DLookup("[FID]", "SchedFieldTable", "[Width]+[Left] > 10.5 * 1440") MsgBox "[FID] = "...
My table has fields to locate controls on a report. The Width and Left fields will be used to position the controls on a 10.5" wide report. If a lot of fields are selected for inclusion on the report, some will have to be moved down to a lower position. That is why I am testing for "[Width]+[Left]> 10.5*1440". The error is: 3251 Operation is not supported to this type of object. Can you help?
Okay, that objective makes sense.
This procedure, though, doesn't.
Can you provide some sample data from the table to help me visualize what's going on?
- Something happened to the post. It's blank.