i keep getting this error message.
its from a combo box which has 2 columns.
i've tried expanding the field size but it's still not working.. i've also tried getting rid of the other column to make it one yet still not working. It only contains about 10-15 words so i have no clue why it's saying...
i have a table "tbl_AFYMO" which has three fields.
1. BDate
2. DDate
3. FM
on my frm_PurRequisition form
Tdate is automatically given. By using that date,
i need to filter and find the 'FM' which TDate is inbetween Bdate and Ddate. am i making sense?
so i need to update 'field1' based on...
i have a search form which seems to work fine.
user can select name or dates (from and to)to search
for specific log.
one problem. i created a command button which pops a calendar so user can easily click on the dates.
and it works fine. but for some reason, if user manually types in the date...
so im using the dlookup function.
i have a form, and i would like to update the field "paID" when user fills out the "PrNum" field.
this is what i have.. im getting a mistype match.
so user types in the prnum, i want access to look up the tbl1_PurchaseRequisition and find the "PaID" which has...
i have this table "HTran"
i've created a query using "Htran" and "Payee" tables.
i think i had it working before but it's not working all of sudden.
the form's rs is "Query".
i have 6 fields from both tables.
PrNum,DocNum,DocDate,BatchNum from tbl"HTran"
and PaID, Account from tbl"Payee"
for...
i have this convertcurrencytoenglish module..
actually function in a module
i've tried setting the control source of the text box to =convertcurrencytoenglish([total]) but it says i can't use module...
i have an amount on report and i would like to convert that in english..how can i do that?
im trying to create a report to print checks.
i am having hard time because information on the report must come from different table.
here is a layout i would want.
account #: 6/26/06 (date) $100.00 (amount)
===========One Hundred Dollars & No cents===
address here
account # and...
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.