Search results

I normally perform validation by handling each control individually. This way you can define a custom message for each control should it fail validation and set the focus to the offending control. I also remove the X button and force the user to close the form using my own custom close button

If you want to send the email through Outlook then use this on the buttons on click event:- Dim MyDb As DAO.Database Dim rsEmail As DAO.Recordset Dim sToName As String Dim sSubject As String Dim sMessageBody As String Set MyDb = CurrentDb() Set rsEmail =...

You do not need the 2nd If clause for the No response as this is already dealt with by the Else clause. If Response = vbYes Then Me.Allowance = Null If Responce = vbNo Then Me.Allowance = Else Me.Undo There are only 2 outcomes to a vbYesNo - Yes or No. You have dealt with the Yes response...

Let me get this right. Your information is stored like this:- ID|Name 1|Bloggs-Joe 2|Smith-John 3|Smith-John 4|Bloggs-Jill 5|Bloggs-Joe And you wish to calculate the number of occurrences of the same name, each time adding 1 to the total? Like this:- ID|Name|CountofName 1|Bloggs-Joe|1...

Thank you David. Please feel free to provide some alternative code.

If you want to remove the values for fields when the checkbox is unchecked then in the on change event of the checkbox, something along the lines of (aircode, might need some playing with):- Dim Msg, Style, Title, Response Msg = "Your message here" Style = vbYesNo Title = "Title for message...

All sorted. Bit more long winded as I would have liked though. I ended up changing the sort of the control source to UpdateDate descending, disabling the right click menu to stop users changing the sort and then creating a control on the main form to concatenate the UpdateDate and CallStatus...

=Max([UpdateDate]) picks up the max UpdateDate for all records in the control source - I only want it to pick the max UpdateDate for the records linked to the record in the main form. I have created a new control on the main form to try to select the latest date using:-...

Create a new blank Database and import all of your tables into it. Password protect this Database - this is your back end. Now create another new blank Database and import all of your queries, forms, macros and modules. Then use the linked table manager to link to the tables in your backend -...

Thanks for the help Galaxiom - note taken about the presentation of the question - just thought it might be easier to know the names of the forms/controls if someone were to provide an example formula. I don't think I have been clear in what I was asking for. My subform displays data in this...

Hi I have a main form (frmIncidentLog) which holds details of all incident calls raised to our system providers. Within this form I have a subform (frmIncidentUpdates) which holds incident call status updates which are added to every 3 days. The subform contains the fields UpdateDate and...

In the before update event of your form, use something along the lines of:- If IsNull(Me.yourcontrolnamehere) Then MsgBox "your message here" Cancel = True End If And repeat for each control that cannot contain a null value

How about different pizza sizes? What about pizza prices - how do you plan to calculate an order total without any prices? DeliveryCharge - usually free if you spend a certain amount so would need to be calculated, therefore this should be calculated in a query, not stored in a table...

I would be very careful trying to sell the programmers source code - he clearly does not want to give it to you. I do not know any programmers who do not keep their work backed up somewhere. I would agree that he is being obstructive - he sees an opportunity to make more cash and without a...

You're right - I have searched for hours and found no probable cause or solution for this issue. I agree that setting form size in VBA is a lot of work but as my system is now live I don't have any other option! It is interesting however that this issue did not exist throughout testing and...

I have the same problem with an A2000 Database - turns out that the forms do open, but for some reason they are sometimes minimised - I have played around with all properties with no success - seems I will have to spend the time setting form sizes in VBA as this appears to be the only way to...

Why do you need to make a new table? Why can't you use the query as the source for the mail merge and simply prompt the user for a case number when the query is run?

Doesn't sound like you have split your Database. Your back end should contain Tables only - all forms, queries, macros etc should be in the front end with the tables linked to the back end. You can then password protect the back end meaning users cannot play around with table design

The Database should be split anyway - This way any information stored in the tables would be safe, and you would only have to distribute a new front end.

When should the textbox turn red? After a record is saved? After a control is updated?