Search results

Good News, I was able to make it work! Its funny, I searched all over the place for a solution and couldn't find anything, then as soon as you said DCount I was able to find all kinds of examples. It was basically the same as checking for duplicate records. Thanks for the help Wayne! Here is...

The form the button is on is not the form with the query. ie.. On form A there is button 1, button 1 opens form B. I want button 1 text to change color if form B will show any records. If I can get a query in DCount I think it will work, at least I am heading somewhere now. I can't believe I...

Wayne, I follow you but can DCount be used against a query? Your example shows a field in a table, I need it to go against a query. Plus the query isn't a database object, it is the record source for the form. The just of what I am attmpting to do is have the button show if there will be any...

I have a database to track parts through a repair cycle. I need to show if a part has been in the shop before based on it's serial number. I have a button that opens a form based on a query that shows records that match the current record serial and part numbers (both have to match). I would...

I found another way to make this work and it will work correctly everytime. I created a subform to show the current status. It is a top value that only shows records for the current workorderID and has a hidden field for StatusID. I used <> to statusID as part of my criteria to replace the...

I have solved my original issue, I used an update query as MSTEF suggested. However, now I have another problem to solve! Here is what I used: DoCmd.RunSQL "UPDATE TBLStatus Set [End] = Now() WHERE IsNull([End]) AND...

I tried an update query but I have the database normalized and all of the statuses are in the status table. I tried to create the update query with three fields: -Status ID (Autonumber for each status primary key) -Workorder ID (Autonumber for the workorder table primary key) Foriegn key for...

I have a subform that is in single form view; it updates a table that shows workorder statuses. Each record has the status, a start date, and an end date. The way I would like it to work is the user selects a status, then the start date is set to Now(), and the end date is left blank until the...

fibayne, sorry it took me so long to respond; I didn't get an e-mail saying another person had replied. I couldn't get it to total each status in the footer; I could only get a total for all statuses together. I did find a way to make it work though; I created a subform for each status by...

I have tried putting it in the footer, that is where my overall total is now. The problem is I can't get the sub total of each status.

Thanks but the DateDiff will only get me the number of days for each status which is what I already have. I could have been more clear in ewhat I was asking though. I have two subform fields that I am concerned with; Status & Days. Lets say I have the following: Status Days A 2...

I have a subform that contains a history of workorder statuses. It shows evertime the status changes and I want to create a summary of how long each workorder was in each status. For instance a workorder might go from "Awaiting Maintenance" for 3 days to "Awaiting Part" for 2 days and back to...

Well I tried searching for Error Trapping and read everything I thought looked relevant, but couldn't find anything I could make work. I am self taught and there are a lot of holes in my Access knowledge so I might have looked right at it and didn't know it! I think I might need more of a...

I have a main form with two seperate subforms. On subform1 I have a control with an after update event to update one field on the first record on subform2. The issue I am having is that subform2 is a continuous form that doesn't allow additions and sometimes there are no records present. So...

I have a form/subform to input students into classes based on the student employee number. The control is a combo box that actually passes the StudentID and on the NotInList event I have code to open a form and allow input of a new student if a StudentID with a matching employee number is not...

I have a form with two subforms on it and I am having problems with the SQL record source for the second subform. In the first subform I have SQL that selects the top value in field2 that also matches the value in field1. In the second subform I need to select all of the remaining records. So...

I have been told that all forms should be based on a query even if you are using all of the fields and not using any criteria. I would like to know what the advantages & disadvantages of this are. Could someone please explain this to me?

Thanks, that works great! Now I see why you were asking about SQL statements. Is this the best way to accomplish this, or should I be doing something different? Do you have to type out that SQL statement manually or is there a way to do it automatically? Sorry for all the questions, that...

I haven't decided yet, I originally had it active and all but I couldn't get the false part of the IIf to work with both the 0 and -1 values for the criteria. I would like to try to get active and all just to learn how to do that.

Here is a copy of the database, I had to strip it down to make it small enough. Thanks again