|
Calculator Key Press
|
| |
I've bilt an on screen calculator. It works fine. I now want to tie in or attach the number keys on the keyboard to the command buttons on screen so that the user can either click on the command button on the screen or enter the number by using the keyboard or a combination of both. I'm assuming... more »
|
|
|
Input mask?
|
| |
Hello All I have a text field on a form where the value must be either empty (=null) or it must be exactly 7 alphas all of which must be either "Y" or "N". Is there an input mask to ensure this, or do I need code? I know I could do something along the lines of If Mid([myText],1,1) <>"Y" and If Mid([myText],1,1) <>"N"... more »
|
|
|
Ctrl+Minus
|
| |
Hey Guys I am desperate, I have a big Access DB on a network and someone has discovered that if you hold the control key down and press the minus key(Ctrl+-) it will delete a record. I cannot find any code to stop this Can anyone tell me how to stop users doing this. Thanks in advance to anyone able to assist.... more »
|
|
|
Default values from previous records in datagrid subforms
|
| |
Access 2003... Creating a data entry form using a datagrid subform. Data entry operators continually enter data for consecutive ranges and I want to set default values to fields from the previous record. Every now and again they will change the default values as well. For example: From To Value... more »
|
|
|
Set criteria for multiple queries entered in one dialog form?
|
| |
How do I set up option buttons to tell my dialog form for which query to set criteria? For example I have multiple queries and only want to use one dialog form. I want the user to be able to choose between "Europe" or "Asia" on the dialog form and enter criteria in the text boxes. If "Europe" was selected by the... more »
|
|
|
Delete query
|
| |
Will a delete query delete whole table or just records in table? I have. DELETE tblAdagePaidDebits FROM tblAdagePaidDebits; Will this delete the entire table or the records in that table? ryan
|
|
|
Display path of back end database
|
| |
I want to add a button to a form that will display the location of the backend database. Is there a stored procedure that will accomplish this or a command I can run on the event property of the button that will show this information? FYI: My clients only have the runtime version of Access 2003 that I package... more »
|
|
|
Message Box Reminder on close or Before Update?
|
| |
I would like a message box to appear once the user has filled out the form and wants to close it or move on to the next record. It's a simple reminder message and does not require any input, nor does it rely on data in any other field on the form. "Verify calibration equipment has been added to database!" Then the form... more »
|
|
|
Delete w/o Bloat
|
| |
I'm running SQL statements to delete unwanted records. Is there a way to do this without bloating each time a deletion is run? Thanks DS
|
|
|
Totals on a Form
|
| |
Hello. I have created a project tracking database that contains a form for entering and viewing data for each unique project ID. I also have a table for time tracking so that I can track how many hours are spent working on each project. This table can have many entries for each project. I created a query to total the number of hours by project ID. I want to use... more »
|
|
|
