Search results
-
T
How do I save the data from a calculation.
Calculations This is a topic that comes up frequently. And the answer from the professionals (not me!) is always the same. Don't store calculations in a table. It can easily lead to inaccuracies and it also causes overhead. Calculating can easily be done in queries and/or forms and reports. -
T
Input Mask
Start In the On Click Event of the box put: Me.txtname.SelStart = 0 (replace txtname with the actual name of the box) -
T
How to display several queries seperately in one report?
Report You really don't need 3 queries. Just one will do and use the report sorting and grouping to achieve the result you want. -
T
Simple validation rule question
Mask You may want to check this link: http://office.microsoft.com/en-us/assistance/HP051875501033.aspx -
T
Simple validation rule question
Solution In the On Click Event of the box put: Me.txtname.SelStart = 0 (replace txtname with the actual name of the box) -
T
Simple validation rule question
Validation You could use an Input mask: L000000 -
T
Disable right click / close on database
Disable Please search the forum, there are several posts on this subject. -
T
Very Basic Question - Form Colours
Colour In Design View, on the Format Tab set Back Style to transparent -
T
Validation Autofill ?
Autofill Not sure what you mean, but may be this link helps: http://www.access-programmers.co.uk/forums/showthread.php?t=84034 -
T
Form display
Design In Design View go to Properties, on the Data Tab set Data Entry to Yes -
T
Validation Rule - Must enter number then letter
Validation You can probably accomplish this as follows: In the field use an Input Mask: 0L And use the On KeyDownEvent of the field to specify which characters are allowed. -
T
name search
Search Here is a sample DB. Hope this is what you are looking for. -
T
Dissalow Update until click submit
Update Trys this code in the Before Update Event of the form: Dim strMsg As String strMsg = "Data has been changed." strMsg = strMsg & " Save this record?" If MsgBox(strMsg, vbYesNo, "") = vbNo Then DoCmd.RunCommand acCmdUndo Else End If In addition you can... -
T
name search
Search Perhaps you can post your db (without sensitive data) and I'll be happy to put a search box on the form. -
T
How do I choose a printer to print a report
Printer Check this link: http://www.access-programmers.co.uk/forums/showthread.php?t=75887&highlight=default+printer -
T
name search
Search Check this link: http://www.access-programmers.co.uk/forums/showthread.php?t=65331&highlight=quicksearch