Search results

hi, could anybody tell me how i can set a password on a command button that opens a form that only administrators should be able to open? thank you in advance, simeon.

hi, i know how easy it is to create a command button that opens a table, but is it possible to create a button that opens the table in design view? i want it because i need an administrative side to my program that allows easy deletions of records etc...any ideas? i also need aministrators only...

hi, i've got code that ensures that people enter data shown in a certain textbox into another textbox correctly by displaying an error message and then resetting the focus. the code i've got usually works fine...but then on adding another command button that closes the current form and then...

hi i've got a form with a textbox on it showing Dmax result from an unrelated table. i've also got another textbox on the same form into which i want the user to enter the output given in the Dmax textbox. when the user doesn't do this, i've set up an error message in the before update event...

hi. i've got a form and on it is a textbox with its control source set as DMax from another field. i have got another textbox with its control source set as one of my tables. i want the user to enter the digit displayed in my DMax textbox into the other textbox but need a validation rule that...

hi, i have a form and on it is a textbox that has its control source set to the Dmax function. it is the only textbox that i don't want the user to be able to use and so i have set it so that the user has no control over what is displayed in it. however, because its control source is now set...

i have got a form based on one table, called tblcar, and in in is a field called Mini ID. I'll call this Mini ID2. It is a number. I have another table which is not bound to any form with another field called Mini ID which is an autonumber. i'll all this Mini ID1. what i need is a way of...

hi i've got a table called tblcar and a field in it called Mini ID which is an autonumber. i have also got a form attached to a different table with a text box on it that i want Mini ID to be displayed in. i have entered the DMax code: DMax=("[Mini ID]","tblcar") - or whatever was shon to do...

hi, i've got a text box in a form and i want this textbox to generate a value from a table that the form it is on is not assigned to. i've been told to use DLookup and have read the 'bible', looked at help and still don't know what i'm doing. i want it to show the most recent addition to a field...

hi, i've got a text box in a form and i want this textbox to generate a value from a table that the form it is on is not assigned to. i've been told to use DLookup and have read the 'bible', looked at help and still don't know what i'm doing. i want it to show the most recent addition to a...

is there some code that i can put behind a text box on a form that automatically makes it the same as text entered or generated in another text box on a different form? this way there will be no need for it to be entered more than once and so can guarantee data validation. if you could help...

hi...i have 3 tables. in each one is a field called ID - for the first table it is referred to as ID1, for the second ID2 and the third ID3 (unsurprisingly). however, is there a way to write either a bit of code or something that automatically makes ID2 and ID3 equal to whatever the autonumber...

Can someone please tell me how i can create a button that launches Outlook Express with the address of my company (minimarket_uk@yahoo.com) already in the bar that the recipient's address should be in? Any help wouold be hugely appreciated.

i posted a topic on how to open one form whilst closing another not long ago. i received an answer saying: Put this code on the OnClick event of the Command Button... DoCmd.OpenForm "Nameofformyouwanttoopen" DoCmd.Close, acForm, "Nameofformyouwanttoclose" The problem is, I'm not sure where...

can anybody help me? i need to create a button for a form that closes that form and opens another at the same time...kinda like a 'submit' button that takes you to the next page where you can fill in more tables. there'e no wizard for opening and closing forms at the same time but i've looked...

i've created a form with an OLE object in it, namely a link to Microsoft Office, containing lenghty prose that i did not feel was suitable for a text box. however, when using the form, i know of no way that inserts a scroll bar to let me read all of the text entered. short of making the box as...

can somebody tell me how i can set up a form, the data from which is entered into a table, but then deleted from the form. an example of what i want is a system that asks for details and then when 'submit' is clicked, these details are added to the table and cleared from the form. this way...