Search results

Hello All, I have had a request from mgmt and I don't even know if it is possible. We have the following objects in our database Table-Non Production ([Work Date], [Department], [Task], [Quantity]) Table-Tasks ([Task], [Prod or non]) Form-Non Production Entry Form ([Work Date], [Department]...

I have been reading through similar problems and can't figure out how to make any of the solutions work for me. I have a form (Production Form) with the following fields: [DateReceived] (the date the job request is received) [DutyType] (Combo box that includes two columns, in the first column...

Dear Boblarson, I just figured it out. The solution to put in the default value is =[Forms]![Production Switchboard].[Form]![NavigationSubform].[Form].[Batch #] I was close so many times, but close doesn't count at all in Access. I was just trying different things again and was about to give...

Hello again, I've worked on this on and off for a couple weeks and am just lost. So I have deleted most everything including most of the fields and attached it as "Prod Problem". All that remains are two tables (Production and PWD) and three forms (Production Entry, PWD and Production...

Hi Boblarson, I've tried that many times. It is the fact that it is in the Navigation Form that confuses the matter. =[Forms]![Production Switchboard]![NavigationControl0].[NavigationParent]![Batch #] is the latest that I tried, but it still doesn't work. I should clarify some things. I'm not...

Hello all, In Access 2010, I have a form called "Production" and a subform called "PWD" that only gets called for special forms in "Production." Before I put the forms in a Navigation Form, I had a field in "PWD" with a default value from an auto number in the "Production" form. In the...

Good morning Beetle Bailey, You have a good memory. The way I solved the problem of the earlier thread was to break out the hours, minutes and seconds into separate fields in the data entry form. Then I made an non visible field where I multiplied the hours by 3600, minutes by 60 and added all...

Hello, I am making a report that takes total seconds that it takes to do something and converts it to hh:nn:ss. In a different report I use =Format(Int(Sum([IT Total Seconds])/3600),"00") & ":" & Format(Int((Sum([IT Total Seconds])-(Int(Sum([IT Total Seconds])/3600)*3600))/60),"00") & ":" &...

Thank you, that helps:)

Hello, I have a database that collects data on the length of calls in hh:nn:ss format. I need to be able to add these together in different queries giving me monthly and ytd totals but Access doesn't go past 24 hours. Does anyone know how I can get accurate totals? gg

I'm not a programmer, but have had the opportunity to set up a couple of Access dbs over the years. Now I am on a project where I am putting together an elaborate database for a business, so I will have many questions. Thanks for this resource. gg.