Recent content by MaleNurse325

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...

Guys, Why is my copy of access graying out Conditional formatting when I am in desing view for reports? Help :)

I have a check box on a form. I'd like, when it is selected to make a field ( A text box ) called [DanGo] visible on the report generated [rptConsignNote] only when the check box is checked. I hope that makes sense.

I could do that but I have 10 colleagues who use the system and they re.. lets say, less that reliable. Currently the font is light grey and can only be viewed from directly in front of the screen.