Search results

How exactly do you turn "off" both menu bars?? Once the toolbars are turned off is there a way to turn them back on??

Unfortunately that did not work, the form still closed. Thank you for the suggestion. Are there any other suggestions?????

I have placed code on the After_Update event of a form to check if a field named Quantity has been left null. If IsNull(Me.Quantity) Then MsgBox "You must enter a Quantity, it is a required field." DoCmd.GoToControl "Quantity" Cancel = True End If If the user presses the close...

If you have time, can you explain a little further how to incorporate a password with a pop up form. Thank you.

I have a button on a form that opens another form. However, a password must be entered before this form will open. The code was placed in the On_Click event of the button: Dim x x = InputBox("Enter Password", "Password") If x = "acct2001" Then GoTo DisEntry MsgBox ("Incorrect...

Ignore my last post. I just tried a combination of both suggestions and came up with something that works. Thank you.

I tried both of these suggestions with no luck. Maybe I did it incorrectly and just need a little more explanation. I did not get any errors but it still closed the form even though quantity contained a Null value. Any further input would be greatly appreciated. Thank you.

I am back with yet another question!!! First, of all I will just say that an older db I am working on again (and the one I am referring to in this question) has a poor design. Most of that is due to specifications by the higher ups here at work. There is a large table with a few forms based...

OK, quick and easy question I think. Is there a way to make a field required just in one specific form and not in the table. For example, I have two forms based off of one table. There is a quantity field that is in both forms, the users want it to be optional to enter in the first form...

Thank you for your help. However, this database got pushed aside right now and I am making some updates to another database. I will try out your suggestion when I get a chance, and if I have any questions I will get back to you. Thanks again:)

I tried out the input mask but it did not work correctly. Can you please tell me what you had in mind for that or if you have any other suggestions. Also, to everyone, I have another field that definately has to be converted to numeric, because users want calculations done. The only way for...

I have a notes field that different users will go into and continually add comments about one record. I have figured out how to get the cursor to appear after the previou comments that were entered. Is there a way for me to make the previous comments in the field unable to be edited??

It is not that anyone wants to do calculations with they field, they just want the data entered to all be the same. They now want only the clock number to be entered. Instead of changing the field to numeric, is there a way I can place criteria on that field that will only allow numbers to be...

When I originally designed a database, there was a field called Written By. The users told me to make this an alphanumeric field because the employees could put their name or employee num. Well now that the database is in use they decided they only want the employee clock number entered in...

Thank you for the help Adrianna. If you could explain in a little more detail or send that sample that would be great. I am not sure that I completely understand your solution but it sounds as if it will work. Thank you. Laura

I have a form where different users will enter in data. The primary key for this form is a number field. The users would like to be able to go to the form and type in a number in that field and if a record already exists for that number they want the rest of the data that was already entered...

I have a form based on a table with a multiple field primary key, SO Num and IRR Num. Is there a way for me to allow users to flip through only certain records on a form. Say for example, they only wanted to view the records with the SO Num 123. The only thing I can think of is to create a...

Thank you Stephen for the help. It does make sense to have the most recent at the beginning. I will change mine also. Thanks.

Thank you, I tried the code given to me and it worked how I needed it to!! My only question is Did you make your field a memo field, if so, what happens when it exceeds the 256 character capacity??

I am designing a database that has several different tables, one table is a comments table. Each other table has a button that brings a pop up form to enter the comments. The users of the database would like all comments to remain in the table, meaning all new comments for one record get added...