Search results

  1. C

    Can't edit form

    I am very new to VB coding so please bear with me. What is the code that I would put in on change property? Tracy
  2. C

    combo box won't select

    One thing that I have found in my database creation endeavors is that if you have the allow edits set to no then you can not pick the option in the dropdown box. So try setting allow edits to yes and see if that works for you. Tracy
  3. C

    Can't edit form

    Okay, I removed the control source for the text boxes but then I can't autopopulate the fields using the combo box. So how would I do that? Trac
  4. C

    Can't edit form

    Sorry, forgot to attach the database so here it is Tracy
  5. C

    Can't edit form

    I have a form called contractors. It works exactly like I want it but it won't let me edit it. The form is based on a query. I have checked the query as stated to do on some areas of this forum and I am able to change it by typing something in a field and it also updates the form for me but I...
  6. C

    Msg box on close only if in edit mode

    Thank you. I did look at the mouse trap thread as I was trying to figure out the scrolling thing but I have to look more in depth. Again, thank you. Tracy
  7. C

    Msg box on close only if in edit mode

    okay did that worked like a charm I also made it a yes no msg box but when it pops up even if I select no, it still saves it and I want it to reset the form Here is my code Private Sub Form_BeforeUpdate(Cancel As Integer) If MsgBox("Save Edits?", vbYesNo, "Exit") = vbYes Then DoCmd.Close End...
  8. C

    Msg box on close only if in edit mode

    I have a form that is locked unless they click the command button to edit records. I want a msg box that when they click the close button it pops up with something like save edits? Just as an extra precaution. But I only want the message box to pop up if the form is in edit mode. Is this...
  9. C

    Subforms editing help

    Thank you thank you thank you! I figured it was a piece of code that I needed but didn't know what the code was. Again thank you. Tracy
  10. C

    Subforms editing help

    Okay, I am ready to throw this database out the window but I am so close to being done that I want to see it through to the end so I guess I will continue plugging away at it. I have a Contractors form and Contractors subform. I have made the allow edits, allow deletions and allow additions...
  11. C

    How do I do this?

    Never Mind, I got it. Tracy
  12. C

    How do I do this?

    Yeah, indecent exposure is illegal but I though I would see if anybody else wanted to streak with me LOL. Anyways, I tried you solution and it worked great except, now my main form is all scrunched up. Any suggestions? I attached the database in case you wanted to see it. The form is clients...
  13. C

    How do I do this?

    I am attaching my database so you can get a better understanding of what I need. I want to make a form called clients based on either the clients query or clients table I also want a subform based on my order details table(I can create a query as well) however, when I do a subform using my...
  14. C

    Unsure how to do this.....

    Thank you, I got it figured out. I had to mess with it a little bit but it worked. I would like to send you a token of appreciation for all the hard work and effort you have put into this and helping me. Let me know where I can send it. Tracy
  15. C

    Unsure how to do this.....

    I put the codes in just like yours are, I did the query just like yours and it's not working right. I have attached the database so you can hopefully take a look at it and tell me what I did wrong. The query is called order details query and so is the report. Tracy
  16. C

    Unsure how to do this.....

    Yes, exactly. Now how did you do it? And will it automatically update if you run the report? Tracy
  17. C

    Combo box help

    I understand what you are saying about the records. Here is my question for you: If I can get the lookup of the client set up right, can I just add buttons that say Add Record( which adds a new client) and Edit record (which allows like a change of address on the form? And then Can I also just...
  18. C

    Unsure how to do this.....

    Sorry, I sent the PM to you because I was giving you the option of helping or not because I didn't want to annoy you or anybody else with my questions. I will address it publicly now then. My client wants to pull a Success Rate Report per Contractor based on the status code that is placed...
  19. C

    Unsure how to do this.....

    Paul, I sent you a PM please give me your thoughts on it. thanks, Tracy
  20. C

    Combo box help

    Len, I just wanted to let you know that I sent you a PM back along with my email address. Tracy
Back
Top Bottom