Search results

I'm sure this has been mentioned before but I couldn't find a thread. How do I ensure that a database users work is always saved even if they exit using the X on the main access window? Is it possible to disable the X in the same way as forms? Thanks

Hi I am currently adding a piece of code which will loop through a recordset (query) to send out multiple emails. I am wanting to shows some totals within the email itself which are a count of fields bearing each email address. Is it possible to use Dcount or similar in the query itself or...

Is there a universal way to add drag/drop functionality to an Access form? We currently use a convoluted Excel form to assign staff to their vehicles each day, my idea is to have an access form with a list of vehicles on it with fields to show the staff member using them. A subform could then...

I currently have a table (tblnews) that contains [date], [comments] & [publish] fields in it - people can input new articles through the front end. What I want to do is when an entry has been marked Yes for publish field it would appear on an offline HTMl document as a news item, almost like...

You could simply add a basic search form to your database to filter the data you need. Add a form say frmsearch and put an unbound field on it say called [jobnumber] - then create a button on the form and use the wizard to open your progress form with the to Job Numbers fields linked. To...

What a daft mistake - all working now! Can I ask you other question - is it possible to add more than one Select Case under one event by adding the next one after the End Select?

Private Sub Command19_Click() Dim strProcedure As String Select Case Me.ppec Case Is = "1" strProcedure = "updateppe" DoCmd.OpenStoredProcedure strProcedure Case Else MsgBox "No access granted" End Select End Sub I am using the above code to execute a...

Excellent, all working - many thanks for your help with this

Expected variable or procedure not module - now appearing Was I correct to put this function into a module?

User Defined type not defined - is displayed when calling the function as you stated? Thanks for all your help so far

Not sure what you mean which 0 should i change - I tried altering the True section and it still overflows

Me.cupassppe = IIf([cupassppe] < 1, "0", [cupassppe] / [cutotalppe] * 100) I am using the above in an On Load event on a form - I ma using this code to deal with the possibility that [cupassppe] & [cutotalppe] may both = 0. However I am still getting an Overflow message - how can i correct...

Me.TotalRlppe = ([rlTotalCompppe] / [rlTotalRecppe]) * 100 I have the above as part on On Load event to display results on a form - however on some occasions both fields used in the above calculation can be zero. Obvioulsy when this is the case I get an overflow error Can I add anything to...

I currently have an autonumber field [RequestNumber] to give a unique identifier to each record in my holiday database - if the number is somewhat random that doesn't matter. The only problem I get is that one someone starts filling out a sheet the number is assigned as they type, if they...

Thanks for your help, thats sorted it Matt

DoCmd.OpenForm strForm, acNormal, , [Request Number] = " & [Forms]![frmmain]![frmmainsub].[Form]![Request Number]"

Thanks for the advice Gave this a try using the syntax for numerical values adding " & before the rest of the condition. I noticed an " appeared at the end of my condition aswell (appeared automatically) and now no results are shown at all Any ideas?

Hi I am using the following code to open a another form but the Where criteria is not filtering correctly - all field and form names are correct and the subform where the button is, is a continuous form Hope someone can point out what i have done wrong here Private Sub Command21_Click()...

Thanks both for your help - place the requery in the on load of the main form and works a treat

I thought of that but I've not used that function before, is it: DoCmd.Requery? would it be best to add this to the on load event of the main form? Thanks for your help