Recent content by Crispy

Try the following: Forms!FormA.Form.Requery Hope this helps

Unfortunately, Access does not allow you to change buttons from their lovely grey colour. But all is not lost – you can make the button APPEAR to change colour… Create a label that appears as you want the button to look, with the background colours etc. Place the command button DIRECTLY on top...

It sounds like your user is entering the information and then the tab button is taking them to a new record. In the design view of the form, click View / Tab Order, then drag the field names into the order you want to tab through the form

Something like this should give you a start - put this in the Before Update event of your date field (which I have imaginatively called DateField here): Private Sub DateField_BeforeUpdate(Cancel As Integer) If (Me!DateField > Now()) Then MsgBox ("Date is in the future. Please enter a valid...

I haven't tested this but... First set the Enabled property of your Combo to No. Then place your code in the After Update event of the Check Box (note that the -1 value indicates that your checkbox is checked) If (Me!Helpdesk_Call = -1) Then Me!Combo23.Enabled = True Else Me!Combo23.Enabled =...

Hi - try something like this in the On Dbl Click event of your subform: Private Sub Form_DblClick(Cancel As Integer) Dim StrForm As String, strCriteria As String If IsNull(Me!YourRecordID) Then Dim msg, style, title, response msg = ("No details exist for this record") style...

Thanks both for your help. I'll give Scott's code a try. I agree with your comments on design, unfortunately I am working with linked tables from a number of different databases, which is why I'm having to use the union query to enable me to query the data on a like for like basis. Cheers...

krispi (MIS) 11 Nov 05 9:36 Hi all I have a database of mortgage applications. I have a query 'QryCasesToWork' which identifies applications to work based on a complex set of criteria. Once the query has run, I need a field called 'ToDo' to update to 'yes'. Unfortunately, one of the...

In the criteria for the date field, type >Now() and <=Now()+30

From memory: [forms]![training courses].[course_dates subform].form![course date]

There are many valid reasons why it's not good practice to write a calculated field back into a table. An alternative would be to query the table to include an expression which is UseName: [MemberFirstName] & [MemberLastName] However if you decide to store the field in the table, then put an...

You could try putting an expression in your query to show the week number and sort on that: WeekNo: =DatePart("ww",[WeekBegin]) This won't work unless Access is treating your field name as a date/time field. If it's not, you're into the realms of stuff far too complicated for me!

I had a look in the Microsoft knowledge base and the problem is with the way Access stores date/time values. However it does post some code which I have adapted and seems to work. Create a new module in your db and paste the following into it: Function GetTimeCardTotal() Dim db As Database, rs...

Ignore the above! It was a reply to a different post!!!

I had a look in the Microsoft knowledge base and the problem is with the way Access stores date/time values. However it does post some code which I have adapted and seems to work. Create a new module in your db and paste the following into it: Function GetTimeCardTotal() Dim db As...