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!

Register Log in
  • Congratulations Rhinorhino 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: *

  1. bigfigkid

    method or data member not found

    thanks much guys, worked like a charm ... :)
  2. bigfigkid

    method or data member not found

    sorry, in my previous post I posted the correct error message but the wrong highlited line, it's the following : Set rst = Me.tblINVOICEDETAIL_Subform.Form.RecordsetClone
  3. bigfigkid

    method or data member not found

    i commented out the ".Edit" and now I get the following error : run time error 13, type mismatch, with the following line of code highlited : Set rs = db.OpenRecordset("tblINVOICEDETAIL", dbOpenDynaset)
  4. bigfigkid

    method or data member not found

    I have a form called : tblINVOICE which contains a field called PRICERATIO. I also have a subform called : tblINVOICEDETAIL Subform with fields called PURCHASEWEIGHT, PRICE, BOATPRICE, and AMOUNT. I have written this code(below) to calculate what the BOATPRICE and AMOUNT's are for each record...
  5. bigfigkid

    Textbox Error

    for some reason the nz function still yields an #Error. This error only happens when the field I reference in the subform contains no records. The subform is derived from a query.
  6. bigfigkid

    Order/Invoicing Question

    thanks much, worked like a charm. I have made an update query which worked ok as well, but it was annoying to have to confirm the update when the update query executed.
  7. bigfigkid

    Order/Invoicing Question

    I have an order/invoice system which consists of a form with a subform. General information such as client name, date and invoice number are found in the main form, and the subform contains the items ordered along with quantity ordered and quantity shipped. My question is this. I would like...
  8. bigfigkid

    Textbox Error

    textbox is on main form. =[qryTRANSFER subform].Form!SumOfWALLEYETRANSFER
  9. bigfigkid

    Textbox Error

    Hi Everyone ! Happy Holidays ... I have an access form which has in particular a textbox and subform. The subform is comprised from a query, and the textbox references a field in the subform. Everything works fine, until at which time I have no results in the subform, and the textbox gives me...
  10. bigfigkid

    checksum

    I have researched a bit through this forum and others about checksums. From what I gather, a checksum is a summation of bytes using the xor function, and is used as a 'check' so to speak to verify that data is valid. The below lines of code are in hex format and each have a checksum I believe...
  11. bigfigkid

    updating data in subform

    I would rather have unfilled orders show up as 0's for quantity shipped until point of shipping. I have been able to have the quantity shipped=quantity ordered when quantity shipped is double clicked. But I have to double click each item in the invoice that needs to be filled. I want to click...
  12. bigfigkid

    updating data in subform

    Hi all ! I have on order/invoice dbase in access. Our invoice form has a subform, which contains the quantity ordered and quantity shipped fields. Most of the time there are no changes, and the quatity ordered = quantity shipped. I would like to place a command button on my invoice form...
  13. bigfigkid

    pcanywhere problem

    I'm in a small office with only 5 computers, so i'm using the server for day to day data entry and other activities. I have managed to setup pcanywhere 11.0 on this server as a host behind my smc router without much difficulty. However, I don't like the fact that the remote control feature...
  14. bigfigkid

    dec to hex & oct

    got it figured out... use cdec("&H" & vartoconvertodecimal) thanx anyways
  15. bigfigkid

    dec to hex & oct

    how do you convert back to decimal from hex ? i don't believe there is a Dec function...
  16. bigfigkid

    spaces in a textbox

    I am aware of the ltrim, rtrim and trim functions. But I would like to remove any spaces inside a string. Any ideas ?
  17. bigfigkid

    problem with textbox

    thanks, it worked after compiling it.
  18. bigfigkid

    problem with textbox

    i have a text box which diplays a result from a function. I would like to copy and paste this result. Trouble is, i need the textbox to be locked, and during run time when result is displayed, if I copy and paste into notepad results in a display of the code for the function instead of the...
  19. bigfigkid

    problem with textbox

    why is it that when i copy and paste a textbox which has been locked, all that is pasted is the formula or subroutine which gives the value of the text box instead of just the value of the text box
  20. bigfigkid

    Run Time Error 429

    Sorry about this dumb question, but this is the first time I have used the package and deployment wizard to make insallation files for a program I have devised which uses the com port. Why do I get the following error when trying to run a compiled program on a computer without visual basic ...

Part and Inventory Search

Back
Top