Recent content by MaleNurse325

AfterUpdate script. DoCmd.Refresh

Its two tables but the Name and DoB fields are in one table with another 7 fields that do work.

I have a data input from that contains the fields. [Surnme] and [Forename] and [Dob]. There are 7 other fields on the input form and the report. Several of the fields, including those above have AfterUpdate scripts to refresh the record. I have even added a button to refresh the data right...

On a form I have two date fields. I am trying to delete the record on the form if the dates are greater than one year old. I bet its simple but I am a bear of little brain.

All sorted. I had bound the drop down list to a text column not a numerical column.

I have sorted the issue out. On the subform I needed to display some calculated fields.

Ah another one? So I have s sub form called sfrmSickness I would like to calculate the number of episodes of sickness absence in the last year. (=today()-365 days) Thanks guys

Hi guys. This is something I have done in the past but forgotten how to do it. So have have an input file with a date. [Conducted] Next to this a drop down list with a text field that reads 3 months; =6 months, 9 months, 1 year etc in the same table from whence those text fields are the...

Thank you very much.

Hi guys, I have a report that I woudl like to print four copies of with this code. Where do I put the number of copies please? Function mcrPrintConsignmentNote() On Error GoTo mcrPrintConsignmentNote_Err DoCmd.RefreshRecord DoCmd.OpenReport "rptConsNote_by number", acViewNormal, ""...

Good day, So, I have a form with several fields that I need to carry forward to the next new record, These feilds will only be updated infrequently. I am trying a Before Update code that looks like this: Private Sub Form_BeforeUpdate(Cancel As Integer) Me.Manufacturer.DefaultValue= """"&...

Hello Chaps and Chapesses, On the main menu screen (Switchboard) I have placed a button that initiates a back up of the database. Works fine, but.. Id like a field under the button that tells the user how many days have elapsed cince last they backed up the database. Any thoughts?

Thanks Plog :)

Im not very experinced atthis and 'self taught' so ...

Guys, Im almost embarrased to ask this but it has bugged me for over an hour. On a record I have Item1 to Item8 and corespinding Quantity figures. so Qty1 to Qty8 All I am trying to do is, if for instance the field Item2 is not null then AfterUpdate Qty2 with the value 1 (that is going to be...