Search results

Done it!!! DoCmd.ShowToolbar "Toolbox" Thanks anyway!

I currently have a form and when you go into it it opens in design view so that you can do changes to it. I have currently in the startup section disabled the toolbars so that users cannot mess around with the design of the database. So what I need is when the user goes into this form that I...

-------------------------------------------------------------------------------- I have a form which has two combo boxes start Date and End Date and I am using a calendar activeX control. Anyway I have added the code below where an error is been generated. I have a check that makes sure that...

WHAT I MEANT IS THAT the text boxes on my form get data from their field for example the address text box on a form can be bound to a table data field. So you dont understand!!!!

Thanks for that but I have altered my code to the same as yours but I am still getting the same error message as before? Help?? Thanks

I currently have a form which has fields in it and I also have two option buttons these option buttons are OPEN and CLOSE. Also I have an update button on the form so for example if the user was to select the option OPEN and then click on the update button the record would be saved. But if the...

Can anyone give me some help with option buttons. I have a form with options on and the options are open or close. So for example if the user selects the option OPEN and the clicks the update command button which I have also got, then I need the record to be added/or remain in the table to a...

Hello, Can anyone help me with a query which I need to set up. I have a user login form & when the user enters their username,password & staffNumber into the textboex & they click ok I would like it to display only their details for example staff number 1. I would like it to display all the...

problem with code I have now, just tried to run the code below in the same click event with nothing else in their, and it is still returning the same error message as before all that is in the click event at the minute is the code below. Regarding Recordsets I aren't the best at I dont...

problem with code Thanks very much for your help it is much appreciated. I have changed my code in the relevant to what you suggested but it is still giving the same error message as before. Any more ideas? The new code is below: Private Sub cmdformStaffDetailsDeleteRecord_Click() Dim...

problem with code I have taken your advice & removed the DoMenuItem parts out of this code & I have replaced it with the command. DoCmd.RunCommand acCmdDeleteRecord now I am getting the error message saying "The command or action acCmdDeleteRecord isn't available now" anyone help please?

Hello, I have got a problem with a command button on my form. The problem is when you click the delete button I want it to bring up a login form as only administrators can delete records, so this works fine but once you have entered you user name & password into the box & click ok it doesnt...

I have a problem with the code below I have created a login form & for this event I get an error everytime. The error message states "User Defined type not defined" & it goes to the line Dim rst As DAO.Recordset. Private Sub cmdOK_Click() Dim rst As DAO.Recordset Dim strSQL As String...

help! your example was sent to me earlier it does help but I got a bit stuck I didnt understand all of it & that why I thought is there any simpler ones than yours! Thanks

Hi all, I require logins for my database that I have created & what I want is to create a login form & this will allow the user to enter a user name & passowrd. I would like the username & password to be looked up from a table which I have got in my database called useraccounts. Once the user...

Error with form Thanks very much that worked!

Can anyone help with this small problem I am having when I open this form. I get an error message which says "The action or method requires a form name or argument" I have declared the form name but it is still not happy! Private Sub commandStaffAddDetails_Click() Dim username As String Dim...

Hello, Can anyone help with this problem I am having with a form. On this form I currently have several text boxes on the form & also I have a save button. when I click save if the text boxes contain NULL then I want to display a message box saying that they need to eneter data in them. the...

I have currently got a query that prompts you to enter a password this all works fine, but I wondered if it is possible to modify the parameter value properties instead of it displaying "Enter Parameter Value" can you for example make it display "Password Needed" in the title? any ideas? Thanks!

I just created a new form & copied all of the command buttons from the current form to the new form & under the command button just entered the same vb code as seen above & it worked. Even though the popup & modal where set to "No" it still never worked.