Search results

One way would be to have all your search boxes in the form header and then the rest in the detail. Then you can just hide the detail as default when the form opens and then unhide it after the user has searched.

Is outlook already open when you run this code? Try moving the '.Display' line to just below the 'Set MyItem ...' line. I have found that Access 2007 the order of events is sometimes different. Also, if you are getting an error your error trap isn't going to tell you. Try using something like...

Try this: FormName.txtProjectName_Exit NB: Just replace FormName with the actual name of your form.

Try the Before Update event on the corresponding form

Because the default value is set in design mode you need to save the form whilst it's in design mode. Alternatively you could use database properties or a table to store the values then you wouldn't have to worry about changing the design of the form.

If you're using an mdb then you can use the in-built Access user level security: http://office.microsoft.com/en-gb/access-help/about-user-level-security-mdb-HP003070410.aspx

In my experience some of the methods you describe - including users having their own front end - can help but more often than not the only thing to cure painfully slow Access 2007 installations has been updating the hardware. This can mean the individual's pc or the server or both.

If you set up a trusted location then you won't see that question anymore: http://office.microsoft.com/en-gb/excel-help/add-remove-or-change-a-trusted-location-HA010354311.aspx

This must be a version thing as the exact code Keith is using works for me in Access 2010. Anyway, kudos to you Linq.

You're right that the Recalc and Requery may not be needed - if the form is set up as expected - but what you have written is no different to what Keith originally put so I don't think it will help. The following 2 lines are essentially doing the same thing...

Not sure why the error relates to a Union query as that's not what you're doing but give this a go: Private Sub Command178_Click() Dim dbs As Database Dim qdf As QueryDef Dim sqlstr As String Dim sqlstrwhat As String Set dbs = CurrentDb sqlstr = "SELECT tbl_Structure_Staff_hierarchy.* FROM...

Try a Me.Recalc after the sub has been loaded. Just wondering though once the sub is loaded does txtsum have a value in it? If not you may want something like this: =IIf(IsNumeric([Forms]![frmUpdateSubs]![frmSubTransTemp]![txtSum]),Forms]![frmUpdateSubs]![frmSubTransTemp]![txtSum],0)

Are you sure that there should be more records using the filter criteria? If you are then maybe something is wrong in your SQL? Have you tried stepping through the code to check what values are being passed and what the SQL ends up looking like? In this situation I often hard write the...

What is txtsum - is that a bound field on your subform or is it calculated?

Try adding a requery to your code as follows: Me.frm_staffSub.Form.requery

I have a few clients in a similar situation and I just create the forms to fit the smallest resolution/screen size and the other users except that on their larger screens the database will appear slightly smaller. The other option is to make the forms fit a larger resolution but add scrollbars...

Have you tried requerying the calculated field once the sub is loaded?

I have a 'main' form that is always open so if ever I need to run code when the application closes I do it on the OnClose of the 'main' form.

You are using Null wrong. What you have is a string called 'Null' rather than testing if it is actually null. Try this: Private Sub cboProduct_AfterUpdate() If IsNull(Me.cboProduct.Column(12)) Then Me.Surface_Resistivity.Enabled = False Else Me.Surface_Resistivity.Enabled = True End Sub

Try this: IIf(([ORDER DT]+21)<>[SHIP DATE]) AND [SHIP DETAIL]="None","Regular Ship","")