Search results

HI It looks like that screen is a macro security warning. Go to tools then macros - security and select low Hope this helps

Yeah I had done that but nothing happens when I click run. I will keep playing around with it

How would I go about the update query as I am trying but not getting very far

Thanks for your response I am now trying to make a button that on click it update the Last Check field with todays date and then updates the next check box. i have this sorted however it obviously still only updates one at a time. So would an update query be best for this Thank you for your help

The NEXT CHECK BOX is a unbound calculated field which ISNOT stored in the table. The problem is that the LAST CHECK BOX (which could be todays date) IS stored in a table. My problem is that every item in my table will be checked atthe same time and so will all have the SAME LAST CHECK DATE...

try going into tools and start up then load your form that way in the display form

I have tried: tbl!lastdate1.lastcheck = Date The table is last date 1 and the field is last check, but I get the error Run time error 424, object required

Is it possible to do it if you are trying to change a field in a table that isnt linked to the form the button is on?

Hi I am trying to do something which im sure I can do but just cant get my head to get it started. I am trying to create a button that when pressed will update a field in a table to todays date Any ideas?

Is that for the next check Date? As that is fine and is already unbound its the last check box which is the problem. This one is a field in the table so it means that I have to write the last date in each record even though there all the same

Yeah that works great

Thanks for replying. Everything works fine but the problem is that the date is the same for every record in the table so I just wanted to type it once and it shows in each record so when I scroll through the forms its there.

I made a "last checked box" and a "require next check box" (which are dates) they work fine however I put the last checked box in the main table and used a calculation field for the next check date. But what I didnt think of was that I would need to update each record in the table for it to...

I have tried this but cant get it to work it still changes the option

What I did was make a last checked box and a require next check box (which are dates) they work fine however I put the last checked box in the main table and used a calculation field for the next check date. But what I didnt think of was that I would need to update each record in the table for...

Hi Does anyone know how I can auto fill all the records of a field by just entering it once Thanks

Thanks for that

HI Does anyone know a way to stop the text box going grey when you un enable it?

Ok have got it to work perfectly and it also gave me an idea how i could improve another part of the database so thanks for your help. Thanks

Ok but think I have it sorted now. I will us the min qty and calculated field method. Will let you know if it work so fingers crossed Thanks