Recent content by ltiner

I have a form that uses a query for the record source. On this form I have a subform. Within the subform I need to use some of the main form query fields (there is no reason to display these fields on the main form)to perform various calculations. I know I can have bound text boxes...

I think you're right. Thanks Larry

I'm not at the computer that has the DB in question, so let me try to explain: 1. I have a table "employee Info". 2. I have a table "Earnings History" in which each weeks earnings is contained in a record. 3. I have a totals query that is based on the "Earnings History" table (2 above), that...

Worked prefectly! Now..... I'm getting greedy. Can this query be "tweaked" to allow for adding records (to the employee info table)? Thx Larry

Here's the deal... Developing a payroll system. I have 3 tables: One for employee information. One for archiving current years earnings (each record = 1 week) One for current earnings. (Identical to the archive table). On the form for entering current earnings, I need the employees totals from...

I am developing an application that has several default values; company information, tax rates, etc. These values need to be available whenever the program is open. What is the best (correct) way to do this (hidden form, dlookup(), or what)? Thanks

I am dealing with the save issues and I like Russ's solution, but I can't get it to work. In which control do you set the after update event. I tried it in the textbox that does the calculation, but it doesn't seem to "fire". I put it in the before update event of the form and it worked, but...

In brief: Main form containing a Subform Text box on main form with the following control: =[frmFC3Child].[Form]![txtSGallons]+[tbxfcojmovfc3-1]+[tbxfcojmovfc3-2]+[tbxfcojmovfc3-3]+[tbxfcojmovfc3-4]+[tbxfcojmovfc3-5]+[tbxfcojmovfc3-6] One number comes from the sub form, all the others (6)...

I think your problem is that the word "key" is a reserved word in Access. http://support.microsoft.com/default.aspx?scid=kb;EN-US;q109312