Recent content by oihjk

Thanks Boyd, that is what I needed to know. I appreciate your clear and concise answer. Eric

Simple question (I realize the answer may not be). Is there a way to open an .ade saved from 2010 using MS Access 2007? I have commercial software written in Access 2007, I am testing the possibility of upgrading to 2010. All of our clients run 2007. When I save it as an ade file after...

Hello Everyone, It has been a while since I have posted here. I am working on a query to show information from various tables. It's purpose is to show the costs for each job. I am using an sql backend for an Access Data Project. I need to have parameters that point to a control on a form to...

Figured it out... This is what I did for those interested. if Me.NewRecord then if Me.RecordsetClone.RecordCount > 2 then MsgBox "Only three entries allowed." Me.Recordset.MoveFirst endif endif I someone has a better option, please suggest it. Thanks, Eric

Is there a way to limit the amount of entries in a subform to a certain number? I currently am trying to do it using the allowadditions property combined with onCurrent, but I need something to fire when I leave a record so that it sets allowadditions back to true. Is there an event that is the...

Hey Checker, Thanks for the reply. I have been working on this for so long I need some "outside insight." That gets me going in a good direction. On the same note, once I have that set. I will need to be able to determine at which point in the day(also week) an employee reaches overtime. So in...

Just to show you, this is part of one of the queries: strSQL = "SELECT qryListHoursTime.LaborDetailsID, IIf([ContractTypeID]='PT08',IIf([Hours]>8,8,IIf(([RunningSum2]-[Hours])>=8,0,[Hours])),IIf((SELECT Sum([Hours]) FROM [qryListHoursTime] AS [qryListHoursTime_1] WHERE...

This should be a piece of cake for someone with a few experience years on me. I have a client for which I am building a custom database. They use this for various reasons. One main reason is to track man hours, cost, billing information on a per job/customer basis. Each of their customers has a...

I have an apparently unique challenge that I thought would be pretty common. I have a payroll system that tracks payroll per job. The entries are on a time range basis. So on job 2, if an employee (0520) works from 9:00 to 9:15 and then goes to job 3 from 9:15 to 9:30 then returns to work on job...

Hey Linq! Chill out... :) Truth is I am not even an employee here. I am just doing some database consulting and design work. I've hit a road block here and was looking for some insight. Actually I just got screwed by this same company. I plan to finish this project, but after that I have a...

I have inherited a database. There is one portion relating to payroll, hours, jobs, and time sheets that I need help with. On each time sheet there are multiple employees. For each employee there will be multiple time sheets (even possibly for each day), Employees' time sheets will exist...

The real issue Pat and Brian, Thanks for replying to my post. I did take your advice and changed the PK to VarianceID instead of a multi PK. Joins are much easier this way. I've also changed all of the relationships in the database that referenced this, accordingly. In reference to the field...

I did it this way so that I can have more than one Code of Account entered against each variance. ~edit~I do believe you are correct though. I should have used the PK from the CoA table as FK in the Variance table. ~edit~ So that the Variance Table Structure won't look like this...

I created a subtotal of Dollars on the "CodeofAccounts" subform called "COATotals" and put it in the Footer. When trying to reference this field from the "Variance" subform using =Forms!CodeofAccounts.COATotal I get #Name in the text box. In case I wasn't clear in the previous post the...

The layout of the tables are as such: _______________________ Code of Accounts table: Proj#/Var#/CodeofAccount/ManPower/Hours/Dollars Variance table: Proj#/Var#/MaterialCost/EquipCost/ConstructCost/StaffCost (+ Many others not related to this issue) ________________________ The Variance table...