I am using the TransferText Method to export a fixed length file that is used to create checks. How can I format the amount (text field) so there are no leading zeros and the data is aligned to the right in the field?
I am trying to use a statement (attached to a command button) in a module to populate a history table with information from my current form:
dbs.Execute ("INSERT INTO FA_History ( FAHI_AcctNumber, FAHI_Amount, FAHI_InvNumber, " & _
"FAHI_PostDate, FAHI_HistType...
This error is very wordy but here is the first sentence, “This expression is type incorrectly, or it is too complex to be evaluated”. The error occurs when I try to open a form that has a sub form attached. I have no clue as to where to look for the problem. It does not happen every time I open...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.