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

    Field Can't be Updated on Subform

    The problem is that when I go to enter data in the first data field of the subform I get the 'Field can't be updated' error message. As soon as I hit ok everything is fine and I can update the record. There are no other users as I am on a single PC and it is the only thing running. The...
  2. storyboy

    Run Update Query with out Message boxes and OK

    This was just what I needed. I'll use the vb code thing because I can just set it to false for the time that it is needed then back again. Thanks for your help. Not sure about the unsafe part as it is just a simple update that shouldn't harm any of the data, only sets up the table for a simple...
  3. storyboy

    Run Update Query with out Message boxes and OK

    I would like to run an update query in the background and not have it show the message box or ask for ok to continue as that is part of its usual routine, can I turn it off. Can you please tell me where that is done if I can do it. Thank you so much. I have read many screens, pages of them, to...
  4. storyboy

    Storing Calculated fields in underlying table. (Access 97)

    Trust me, I received the same thrashing from others on this subject, finally after persistant inquire got an answer. There are rules, and there are exceptions. Check my thread 702-1023228. I had had it and was going to trash access and do my project over in another system, then I got an answer...
  5. storyboy

    Where to look up commands/syntax

    Lorirobn, I felt the need to add to your orginal comment about finding answers. You should see the library I have, almost every current book on Access. I even took to spending time, lots of it, to reading most of them as though they were a novel. Though I now have a very good understanding of...
  6. storyboy

    Results of unbound into bound control.

    All worked great, I am very excited that I can now stuff that data into the table. There are 27 activities that depend on that data being there, and not constantly recalculated. There are rules, then there are exceptions. I thank you so much for your help and assistance. Appears you are very...
  7. storyboy

    Results of unbound into bound control.

    Where is the best place to put calculations. Here is the problem. Within the bound control on my form, I have been putting calculations in the Control Source Property. This calculation is based on entry of other fields, shipping cost, and discount amount, etc. I need to see the result of the...
  8. storyboy

    Where best to put Calculations

    My situation is such that the user need to see the result of the calculations on the screen, in the form, as they are working. Yes I agree that good design doesn't mean storing the result of calculations related to known data, that which is already being stored. There are times when a violation...
  9. storyboy

    Where best to put Calculations

    Where is the best place to put calculations. Here is the problem. Within the bound control on my form, I have been putting calculations in the Control Source Property. This calculation is based on entry of other fields, shipping cost, and discount amount, etc. I need to see the result of the...
  10. storyboy

    Unbound control on form, put data in form bound table.

    I did this I put in the bound box, then on the BeforeUpdate event property IATotals = Me![Itotals] Hummmmm, it didn't work. Has to be a way to do this. It is a simple type of thing and logically your suggestion seems correct. Gave it a try and no cigar, still nothing in file. Any help...
  11. storyboy

    Unbound control on form, put data in form bound table.

    New to this, love Access, read this site often for answers. Need help PLEASE. Have unbound control on form "Itotals" which does calculations great, shows the results great. Form is bound to table "InvoiceC" I want to have the Itotals figure displayed, put in the field IAtotals. Please help me...
  12. storyboy

    FORM/SUBFORM EXIT SUB IF 0, HELP

    Is there a way to exit a subform based on a field control in the subform, such as, If the QTY is 0. I want to not save that entry of detail, and continue filling out the fields on main form. This is an invoice data entry situation that I am working on. I really like Access, but being new at it...
  13. storyboy

    Exit SubForm and Return to Main Form?

    Is there an easy way to exit a subform and go back to the main form to finish entering data there. If the user doesn't enter a quantity in the detail of the subform I want to automatically leave the subform and continue on with entry to main form. Oh yes, can you tell me where to put the...
  14. storyboy

    Subform data entry layout problem ?

    ...for entry the form produces two lines of fields for entry. The first line has pencil symbol. Then lower is a line of fields same as above with an * which also allows data entry. I don't want that Lower line to be there. All I want to do is enter the data one line after another. This subform...
  15. storyboy

    Show MAX() value in Entry Form

    Not using autonumber, have simple numbering system that they had in use for quite some time. I get involved with converting clipper programs to Access. Pushing data and everything else, like new programs, screens the whole lot. I enjoy it a lot but some times Access stumps me because I am so new...
  16. storyboy

    Show MAX() value in Entry Form

    Being a newbie, some of this is so logical, so easy, and other things so complicated, I am missing something, DATA ENTRY Form. unbound text field and I want it to show the highext value in the current file. Form is connected to file, HIH and in that file is field VCNO so on control source...
  17. storyboy

    Lookup and Display2

    Yes, yes, and yes. It worked, and I thank you so very much. Works beautiful and is just what I wanted, and they need. Should name my first born after you, just don't know how the family would pronounce PHV. Thank you.
  18. storyboy

    Lookup and Display2

    When I put the [textbox name].requery in the AfterUpdate Event rocedure of the combo box, it tells me can't find macro of that name. Is there another way to get data from another file to display on a form that would be easier. Perhaps I am going about this all the wrong way. Please advise...
  19. storyboy

    Lookup and Display2

    Thank you for your reply. I have the dlookup in the controlsource property of the textboxs but I don't know how to requery in the afterupdate event procedure of the combo box. the customer file is FILCUSTOMER Fields fldcco (customer code) fldna (name )...
  20. storyboy

    Lookup and Display2

    I didn't make myself very clear before, sorry. I am creating an invoice system. My invoices involve two files, one for the header info and the second for the products ordered. In the header I have the entery person enter the customer code, then I want the customer name, address etc. to be...

Part and Inventory Search

Back
Top