Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: wshs1
  • Content: Threads
  • Order by date
  1. wshs1

    dao to ado??

    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?
  2. wshs1

    field is too small to accept the amount of data you attempted to add

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

    updating a field after filtering "inbetween" dates..??

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

    calendar only works with dialog..

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

    updating a field based on other field

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

    can't type in a value when i have a query set as record source.

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

    is there a way to use a module in a report?

    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?
  8. wshs1

    preview/printing checks with dot matrix

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

Part and Inventory Search

Back
Top