Recent content by dennisell

Thanks for the input, so code it is!

I have been creating a database at my work and am 3 months into it. I am learning a lot from this project. I view this database as being pretty complex by my standards and am having performance issues (a little slow on some things). My question is: Which will ultimately give me better...

Could you steer me in the right direction as to make this happen. I have users that all run different resolutions on their screens and I have several forms that are on the large size with a lot on info on them. It would be great if the form could automatically resize itself to fit that users...

Is it possible for access to scale down or up the forms like it does with reports?

Thanks, I will give it a try.

Well, of course it would have to be the more complicated one. Other users are adding the records. Basically, the subform is a list of things that need to be priced out as soon as possible, and controlled by a query to sort out only the records for that user. The Main form called...

Is there a way to have a message popup to let a user know when something needs their attention. I have a main form that is always open with a couple of subforms in that form, I am trying to figure out how to go about having a form popup when a new record appears in the subform. The subforms...

I am creating a database for where I work and there will be around 10 different users and eventually up to 20. I have split the database up into two parts, one that goes on each workstation that is the "Program" and one on the server that hold the data. My question is: Is it...

I think I am almost there, the form is locking just like I hoped. I had to add a line to the code to lock the subform also. The only problem now is after entering a work order and clicking on the button to apply the value to the check box, it does lock everything, but when I close that form and...

I hate to be a pain, but there seems to be no effect on the form when the CheckBox is checked. This is what I have entered: Private Sub Form_Current() If Me![Ready To Build].Value = True Then Me.AllowEdits = False Else Me.AllowEdits = True End If End Sub I am using Access '02 if that...

Jeff, I must be doing something wrong, I placed the following code as follows: Private Sub Form_Current() If Me![Ready To Build].Yes = True Then Me.AllowEdits = False Else Me.AllowEdits = True End If End Sub It doesn't seem to have an effect on anything. Any suggestions?? Thanks in...

Thanks for the reply DreamerZ. Is there a way that I can do the same thing (lock all of the fields) but, based on the value of the CheckBox. When the user returns to the form to view it, the records wouldn't be locked until they clicked on the button. I don't want them changing it after my...

I have a main form called "Work Order" with 2 subforms in it. I am trying to figure out how to lock all of the fields on the forms after the work order has been filled out. My plan was to have the user when finished filling out the forms to their satisfaction, click on a button...

I can't figure out how to disable a button based on a value in a field on the same form. I want it to disable a button if the value is <1. I appreciate any help.