Recent content by BillHesson

Thanks Pat!

I saved a copy of the table and recreated the relationships renamed original table to old and renamed new table to the original name all is working fine. Still Baffeleing how this happend or how else to fix.

I have an inventory split database. It has been working fine. I noticed when I try to enter a new record, it will not let me as it would create a duplicate record. It has actually started to use the autonumbers in the pk again reusing numbers that already exist starting at 1 and moving up...

So it was th "[" me.xxxx "[" that was messing me up I thought i tried all combos of the "'[]()"''" aint syntax a ***ch Thanks!

Thanks I will Check it out!!

This works great!! I learned about the concept of multiple keys but have not used them in so long that I had completely forgoten that they exist. I can sleep again!!

any way to automate the filling of the data when the new pay scale comes out?

try this in your criteria <=[prompt]

If I understand you correctly there would be 1 field called payID a seconfd field classstep and a third field named Pay and a record for each intersection of the original payscale table ie. 1 Class1StepA $42,547.05 2 Class1StepB $43,228.25 this sounds like it will work. It makes me think of...

Looking at your post and don't think it will work as there is no field in the payrate table called class, there is a field for each class ie 1, 2 ,3 ,4, 5... so I do not see how I would join them. also I am using a join table/subform to allow me to have multiple records in the teachertypejoin...

Thanks for getting back to me. I will look at this and see if I can do it. I posted a post in queries forum if you could look at it. Thanks!!

I am trying to make a query that will take the value in a textbox on a form to determine the field to show from the queries underlying table. for example: fields step, 1, 2, 3, 4, 5 and records a, b, c, d step 1 2 3 4 5 a b ......"x" c d I have the query set up to select the specific...

trying to make the query in the gui: all is well except for the dlookup function Expr1: DLookUp([class],"tblcontractteacherpay","Step =" & [formstep]) the class is a field in the query(this one does not work) the formstep is another field in the query(this one works) when I put the field name...

I am using the dlookup function to get data from the underlying table. the pay scale for the teachers is located in a table and depending on the teachers step and class they would get a certain pay. so what I want is if a change is made to the step or class infor the pay field would be...

Hello, I am trying to get data from a specific record in a sub form. and save a result in the same record. specifically: I am using the following fields "teacher type","Class", "Step", "Hours", "Pay" I have two teacher types, Contract and hourly. a teacher can be either of these or both...