Search results

Hi all, Not sure how to write this query and I was hoping someone would be able to help me. I have an import file that contains a primary key and 16 other fields. The fields are name PID1, PID2, PID3, ... up to PID16. What I need to do is create a file that will have an autonumber as PK, the...

Hi there, just a question for you guru's out there. I have a report that has a field on it called total_poles. What I am trying to do is create a report that has this field on it, but also has a calculated field on it called Poles_fine. The problem that I am having is that the calculated...

I am designing a small database for our company that allows the user to take the qc report from the log-yard and input the results so reports can be generated for the higher-ups. What I am looking for is for somebody to take a look at it and tell me where I am going wrong. If anybody would be...

How can I enforce/lock a table to only have one child record in another table? For example, I have a main table (tblLoad) and I only want 1 record in a child table (tbl1_Pts) that relates to the main table (tblLoad). Any ideas? Thanks, Todd :)

Thanks Thanks, I used this in the Activate properties of the subform Me.Controls!Total_Pts.Refresh and it seems to be working fine now. :)

I have a main form with 6 subforms on it all in a Tab control. The information from the first 5 subforms are tallied (via text boxes) on the 6th to give a total for all the forms. The problem is when I go back to one of the earlier subforms and change a value of a field and then move to the...

Thanks for your help N/t :)

Just a quick question for the guru's out there. I have 2 text boxes on a form and I need the second one to display 0 if the first text box - 5 is less than 0. 1st text box's (Inf_Percent) control source is: =((([Total_Pts]/2)/Forms!frmLoad!Total_pcs)*100) --this gives me a percent. 2nd text...