Search results

Macro One good reason not to use macros is the lack of posiblity to do error trapping. I think what you are trying to do can be done with some simple code. Perhaps you can post your db with some data and forms, and I'm sure someone will look at it and give you the right solution.

Format In a continuous form this is tricky. Check out this link, there is a downloadable mdb that demonstrates how it works. http://www.lebans.com/conditionalformatting.htm

Delete You can test on one off the fields and prevent deleting the record when it is empty. In the On Click Event of the command button put something like this: If Me.textfield = "" Then MsgBox "Record cannot be deleted", vbOkOnly, "" Cancel = True Else DoCmd.RunCommand acCmdDeleteRecord End...

Solution Sounds you need cascading combo boxes, search the forum on this topic. It is a very popular subject. You can also check this link, there are some downloadable examples here. http://www.candace-tripp.com/_pages/access_downloads.asp As for the calculated field: this field should not...

Column Go to File/Page Setup, you can set the columns there.

Parameter Check this link: http://www.microsoft-accesssolutions.co.uk/report_date_parameters.htm

Focus In the On Open Event of the form put: Me.thisbox.setfocus

Browse Check this link. http://www.access-programmers.co.uk/forums/showthread.php?t=75790

Update If you have calculated fields in your table the database design is basically incorrect. Having those fields may cause data inaccuracies at some point, it causes storage overhead and in your case leads to extra work. Generally calculations are done in a query, basing forms and reports on...

Update Probably the easiest way to do this is using an Update Query which can be run from the form by clicking a button. Check Access Help and the Forum on this topic.

Database You're welcome and Good Luck. You can also search this forum on this topic, I'm sure you'll find some useful information.

Archive Check this link, there is a sample mdb called Audit Trail, it may be what you are looking for. http://www.candace-tripp.com/_pages/access_downloads.asp

Flicker Don't know exactly what causes it, but it seems to be a bug in 2003. It can also happen when moving over unbound labels. I tried to find a solution by doing some research, but didn't find one. Hopefully Microsoft will isue a patch or may be someone will find a cure. It is very annoying.

Page Check this link: http://www.access-programmers.co.uk/forums/showthread.php?t=61272&highlight=totals+page+footer

Lables Try this. Put the following in the Control Source of the field in the report: =IIf(IsNull([Employee]),"","Employee: " & [Employee]) If the Employee field is empty you will just get the Label 'Employee :' else there will be the label and the field content.

Save Try this: Private Sub Command80_Click() On Error GoTo Err_Command80_Click DoCmd.RunCommand acCmdSaveRecord rest of your code.. Two remarks here: It is good practice to use meaningful names in the code, so instead of 'Command80' something like: 'OpenFormReplacement Unit'. It helps when...

Great You're welcome, and Good Luck.

Hide Try this: Private Sub Check61_Click() If Me.Check61 = True Then Me.123.visible = True Else Me.123.visible = False End If End Sub Instead of making the button visible or invisible you may want to enable or disable it. That way the user will know at any time there is a button to execute an...

Table Check Access Help and this forum for 'Append Query'

Screen In the On Open Event of the form put: DoCmd.Maximize You can hide the database container window by selecting the "Display Database Window" option under Tools Menu/Startup. However, if you need to show or hide the window on demand afterwards, you can use one of these ways. To show...