Search results

Am trying to run my database in a minimised state with all forms and reports as pop ups on the desktop. This works no problem with the forms as they have a pop up option, but does anyone know how i can do this with the reports? Thanks for any help you can offer.

Have now got a system that works brilliantly thanks in no small part by the help offered by you guys, but i can't stop myself tinkering in a vani effort to further increase me access and VB knowledge. Am playing around with setting up a shortcut to run the database minimised. With all the form...

Sorry if i sounded like a dumbass with my last posted reply. Have looked at what you said originally and have set the code up on the button as follows: Private Sub ConfirmPRAF_Click() On Error GoTo Err_ConfirmPRAF_Click Dim Ctl As Control 'create a variable for the forms controls Dim Frm As...

Thanks for the thought. However the user needs to be able to edit the data up until the point where they confirm the data. I have set up different user levels and ideally all users would be able to confirm an order that they have placed using one button, and admin users would have another button...

Hi ...... again. Does anyone out there know of a way that i could add a button to a form that when activated would lock all data on that record so that users are unable to edit the data after it has been confirmed? Thanks for your time.

Which input mask would that be? The code is written in VB and attached to the onclick event of a button. Thanks for the thought though.

Works a treat. Is there any way to show the inputted password as a series of asterix rather than displaying the characters?

Any ideas on how i could password protect a button so that it does not activate unless a valid password is entered. I'm assuming i will need to add some sort of code to the OnClick event property of the button, but have no idea what the code should be. Any help gratefully accepted. :confused:

Any ideas anyone?

Have done as suggested but there still seems to be no change. A button launches a new form, for example originator, allowing the user to add more data. This is then to come up in the combo box on the main form, but the new originator is not on the list. However if i close the main form adn then...

Thanks Thanks for your help trucktime. Have stripped out all potentially sensitive material. If you can work it out and let me know what the problem is/was it would be appreciated

Any ideas on possible code? VB is not my strongest suit.

Thanks for your help. You have solved my problem on the first count easily although the user still needs to be able to access old records so the data entry to yes option is not something that i will use. On the second count i still seem unable to get all the data in the subform to group...

Guys, (and galls), i have a subform on a purchase order form listing all the specific product details for that transaction, however i want all transactions for that purchase order to go on the same record and so need to either remove or lock out the ability for the user to use the navigation...

At least easier than Cisse's

Hi again. Another easy solution for you to point out for me. Have a main form that has combo boxes listing suppliers, originators etc. All combo boxes have a relevant button which enable the user to enter another form and add new suppliers, originators etc. However when the form is closed the...

Have a purchase order system where users are added to the system using one form by inputting separate forename and surname and then selected via combo box on the main form which is displayed as a concantenated (thanks for the right word) value. I then need to use this value in generation of the...

Hi, I am trying to create a value on a form and then write it to a table field. ie. the user inputs first name and last name in two bound fields on a form. This then creates a users full name in a third bound field in the format surname, forename using a control source =[surname] & ", " &...

Put a combo box on to the original Employee form and tell it to look up a record. If you then set the employee ID which you want to use to pull the data as the combo box content you will then be able to type in the number and it will populate the other fields for this number