Search results

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

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

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

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

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

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

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

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

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

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

Never Mind, I got it. Tracy

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

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

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

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

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

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

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

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

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