Search results

I've just done that but now no Expiry date is added when the Warranty Period is populated. I've removed the code from the "Warranty Period (Yrs)" After Update property and placed it in the "Date of Acquisition" After Update property

Again thank you very much for your help. Is there anything I can add to the code to make the "Warranty Expiry" field auto update from the "Warranty Period" field should the "Date of Acquisition" field be changed for any reason? I'm not trying to confuse you honest ;)

You are a star. Works very nicely cheers. Slapped wrist for spaces in my field names though. I didn't realise this was poor practice but am more the wiser now thanks ;) One other thing. Should I want it to take the source date from the "Date of Acquisition" field which is a date/time data type...

Ignore my last update as it's not relelvant and what you mention is exactly what I'm after. I'm adding the provided code to the "Warranty Period (Yrs)" field AfterUpdate property on the form. Is this right? Sorry for being a bit dumb here but should the "Me.WarrantyExpiry" be Me.Warranty...

Bah sorry I forgot to add I have a "Date of Acquisition" field which is also a "Date/Time" data type field and would be from this date that the warranty period in x years would take it's source from.

Hi I have an inventory database main form and for each item on this another form can be opened via a button providing more detailed information. I have a "Warranty Period (Yrs)" field on this form which is just a "Number" data type field and a "Warranty Expiry" field which is a "Date/Time"...

Sorted!! Managed to do this by creating a Macro with a "SelectObject" action to select the form and then an "ApplyFilter" action with the relevant argument and adding this macro to the main form's "OnOpen" property. This now removes any last set filters and applies the chosen one instead. Cheers

Cheers for the reply. How would the VBA code look for the fase filteron property? Something like ?

Hi, I have a form which has a "filter on load" set to apply. This works fine however when further filtering the form after initially opening and then simply closing the database without clearing the latest filter and then opening the database again, the latest filter is applied instead. How...

Thanks for the replies. I was under the impression that was a short example of my actual database as removed almost all records!! The demo db you sent does exactly what I want but attempting to integrate it into my actual db gave me errors that I just couldn't figure out however I managed to...

It's an Access 2007 database. I've attached a cut down version which hopefully will be of some use. Many thanks

I'm aware of this but want it to default the view every time it's opened to not show this and want a quick toggle between the Two views which is why I wanted to use a check-box

Hi I have an inventory database with a main form that has a field called "Status". I simply want a check-box on this form that will filter out a specific status ie. "Dead" from view. Nice and simple yet I can't seem to find straight forward instructions on how to do something that should...

Hi Well at least something's now happening....I've added the code to the "On Unload" event but this give's me with ".SetFocus" from the 4th line highlighted Blue. When clicking Ok, the "Private Sub Form_Unload(Cancel As Integer)" line is highlighted Yellow!! Code currently looks like this...

Any ideas on this?

Ok thanks that makes sense however these are macros on the button so how would I go about adding the Me.Dirty = True statement? Looking at the current code for this button it reads: Private Sub Command60_Click() On Error GoTo Err_Command60_Click If Me.Dirty Then Me.Dirty = False...

Hi I have searched through the forums and although found relevant threads, none have helped me out. Basically I have a form which has a field ("Status") that I've set as required from the sourcing table. This form has a button that makes various changes to the data shown and one of them...