Search results

Hi I have kind of made a rod for my own back here with my data base in the table I have 4 fields Start date Start time Finish date Finish time I want to find out using a query how many hours there are between the Start date and time and Finish date and time. Simple enough id imagine with...

Guys im having a moment here I have a query which looks at various parts in production areas I have a check box that's returning yes there is a part ther or no there isn't all I want to do is count the yes ! surely im missing something here PLease help Dan

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

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

Hi Guys Seen a few posts on this and yet still cant make it work for me I need in my form which has 10 different combo boxes or txtboxes to be filled out before the will allow you to save it ! Ive been close with this module but all it does when I hit save is shut form down and saves even...

Hi Guys im really sorry to be posting this because I see so many people asking the same question! I haven't been able to use all your excellent advise and adapt to my DB how ever on this occasion so its prompted me to post my first thread so please bare with me. OK so I have a...

Hi guys im Dan ex pat living in UAE im struggling with building my database and found you all a lot of help so thanks Dan