Search results

ok thanks, i thought i could put something in the table design thing so that it would do it from there. but will look at your option

i am sure i have asked this before but have looked back through my posts and can't see it.... i need the autonumber to start at 500 instead of at number 1. i am also looking at maybe preceeding this with a letter so that it would start at A500

i have a number of filling lines in the company where i work, layout a little similar to the layout below. what i need to do is to link the lines with the machinery attached to it. as you can see each line may be different, but there are also a number of lines that have the same layouts...

i can't thank you enough for your support here, but hopefully you will see what i am up against here, you should see the state of the rest of it........:D the database was originally designed by someone who had never used Access before and has now left the company, and i have been tasked with...

is that any better

i have now modified the file so hopefully u can access it, yeah sorry i keep forgetting about the workgroups

ok will sort out on my laptop then repost it cheers

cheers, but i still aint having any joy with this.. i have posted my DB so you can have a look..... i have also added my Table called dated so you can see how it is currently set up.

could this then be extended to not just show the total hours but hours and minutes ???

i totally understand what you are saying: the daycode - 3111 represents Year 03 daycode 111 hence the 3111 and it is an assumption that if the the end date will always end 24 hours after the start date

nope i still get zero

i just tried and it does what i am after except if the the 2 times are the same

it's all to do with the data entry method, i am trying to re-write the current DB that we have, and this is a major issue here. and i need to make it as quick as possible for the inputter to do, so if they can just enter a daycode then a start time and end time relevant to that daycode, i...

thanks everyone for your help..... i just found this article on the net. http://www.fabalou.com/Access/General/DatesAndTimes.asp and the following calc seems to do what i am after IIf([StartTime]<[EndTime],DateDiff("h",[StartTime],[EndTime]),24-DateDiff("h",[EndTime],[StartTime])) i now...

cheers milo, but you aint getting off that lightly :D :D this works great but as i think you have previously stated this will be ok unless the two times are the same, so i was wondering if there is a work around to this problem, if the two times match, it will always mean that this will...

right i posted this some time ago and i thought that the problem had disappeared but it has shown it's ugly head again, i think i have sorted it though but just want to see if this is possible. following through the calculation, this works a treat, but as stated above i will effectivly lose a...

ok thanks, but the reson i store the EmployeeName is because i found this search facility and i have modified it to suit my database, but part of the lookup in it refers to the following: SELECT DISTINCTROW [Tbl_EmployeeDetails].[Employee No], [Tbl_EmployeeDetails].EmployeeName FROM...

append or update ??? i have a table called "tbl_Details" it has the following fields Surname Forename EmployeeNo (PK) EmployeeName the field EmployeeName is the problem are here for me. i need the EmployeeName Field to be automatically completed upon the input of Surname and Forename, the...

yeah sorry, it didnt sound that clear when i wrote it... i wan to be able to click on the open search button.......then the button that i want to be visbible/hide will then appear. but when search option has finished the newly visible button would then hide

hi i have a search facility on my database, how it works:- i have a form called tbl_employee's on this i have a button that is called search when i click search it filters down to the single item selected. what i want is as soon as the seach button is applied i want a button to be visible...