Search results

One last thing I have all these check boxes but I only want one to be clicked at any one time is there a way you can add a piece of code to say uncheck all other boxes then check this one on click?

The excel file drives the access table To be honest im thinking to get rid of this linked table would that be better and auto update therefore?

HI I have this code that runs if i enter a date into the Txtboxshipactual and then enters a date into txtExpectedDeliveryHUBactual after its added TxtBoxshipactual.Value then it reruns the date diff into TxtDaysdeltatoplan My issue is that I have to click the check box once to get the...

HI I have a excel file that's is linked to my table in access what id like the access table to do is auto recheck the data in that excel sheet automatically when you start the data base up. Is that possible? Dan

HI Can you tell me what small procedure that is? Basically I want the form when I go to next record to re check all data I have a number of text boxes now linked to colums in a combo box that were not when I first built the db How can I get it to re check and fill out with out...

I would like to update all records with all formulas without clicking

Hi I have this text box txtExpectedDeliveryHUBactual I would like when this text box has anything in it (will always be a date) TxtBoxshipactual to look at this date in TxtBoxshipactual and then take the amount of shipping days needed from TblDelivery_method and add it too that date each...

Hi my combo box populates other text boxes on my form when I click it. I have only just written this to do this and now the old records don't sho it unless I re click that combo box then all the data for the 16 colums pops into the form and populates the table What I need is for it...

HI Can you help me ? I have added a formula to a combo box to update a bunch of other txt boxes on my form how do I apply these to all records already there? The formula works fine if I re click the combo box but I have over 1000 records and I don't wat to go click all them!!!! how...

Hi how do you make it go blank if you remove the tick mark ?

Thanks Arnel Is there any way I can get my data base to you so you can have a look at a few things im trying to do ? ive been strruugling for days now and its costing me sleep!!! Regards Dan

Hi can you guys help me? See photo attached what I need to do is in the box delta ODD is look up that row of check boxes if it finds a check box then calculate the difference between those two dates. PLease help im stuck Dan

HI Gents Can you help me? I think I have been looking at this too long and this is probably an easy one for you. either that or im just not clever enough. I have a table where by parts move through the factory and when they reach that area a guy ticks the box in the data base and enters...

Think I got it give me a moment

Hi I cant get any of these to work sorry can you tell me where you add that in the query? example 10/10/16 start and 20/10/16 end shoud return 8 days as there are 2 x Thursdays and 1 Friday in there

Hi does this look at Thursday Friday as holidays? im not confident on how I use this could u explain a bit for me sorry

Hi Im not using any code at moment just date diff so it showing straight calendar days what I need is a code for Fridays sat as weekd=ends and sunday as first work day in excel this is simple now with workdays.int function

Hi All I know this is all over the place this topic however I need a solution as I cant seem to find a way to make it work. In my company our weekends are Thursday Friday. heres my issue I have a access form from a table that gives me a customer required date that a job should...

Great stuff thanks a lot guys for your help !!! love this forum

I stopped using that code completely that I showed at the start because it didn't actually appear to do any thing. It closed down the form and saved entries in my table regardless if a box had data or not. This required field I just found does the job I want but shows a message box for the...