Recent content by wshs1

thank you. definately helped.

i've created a simple monitoring system using access(vba). my network tech is asking if i've done it in dao or ado? how do i check that?

getting "missing operator" syntax error.. seems like it's capturing the Tdate but.. Tdate, Bdate, Ddate are all "date/time" and fymo set as "text

actually im getting a typmismatch. is there a symantic error that im not cathing? was certain that was gonna work..

tjv1611, thank you!!! your my hero of the day!!

wth.. it's working now... i just erased the row source and re-typed the bound field and it's working.. how frustrating.. anyways, thank you for your help guys. really appreciate it!!

nothing.. just a rowsource for users to choose from and trying to bound it to a field..

kjv1611, 'Tdate' is a field which returns today's date. field is locked and the moment user opens the form, it is upated. On that same form, i have a field "txtFYMO". based on Tdate, i need to update this(txtFYMO) field box. I need to update txtFYMO with 'fm' but i first need to find which fm...

yes, it is a bound combo box. By bound field you mean the field from the table that cbo box is bound to right? i've tried changing it to 255 and still no luck. i've tried changing it to memo as well. still same error message.. i've had texts longer than this. first time i've encountered this...

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...

just saw that.. but thank you~

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 got the currency to english part working thx to u guys. trial and error.. guess that always works lol