Search results

So, I'm trying to find the best way to do this, and I've been successful to an extent. I'm trying to create a report which has a certain piece of equipment, lists a few fields for each, which are then populated according to the date. Right now, i can get this format Line 1 Date 1...

And.... I should probably just change the title of this post. So, How would I go about only showing the Append query for the given filler/date. I'm trying to make this user friendly, and if I change fillers, all values in the table are shown rather than just the fields just for that filler...

So, I've gotten that part figured out (and with multiple fillers/reasons...yay). Is there any good way to prevent duplicate "appends". I've looked around and noticed that setting the fields to unique would do so, but thats not applicable in my case. Basically, a 'duplicate' would occur if the...

You were correct. I meant should I keep it bound to the table or move it to the query.... Sorry for being slow with this. Kinda learning as I go.

So. I need to change my 'subform' to pull from the query you submitted versus mine?

Do I need to add a separate query with that code?. It looks just like the append query I have

Here's the file.... The tables I'm working with are EQ5A Reason Table EQ5A Stop Table Info Queries: EQ5A Reasons Table Query(Append) Form: EQ5A Data Entry Form Filler Select Stop Form The Filler Select Stop Form is the form I am working on, where the Date Entry form is the 'subform'

Sorry to reopen this, but i'm back to working on the database. So, I added a subform(which shows the appended query) to the form where I put in the date and equipment. The subform is not populating once the append is done (even after requery macro). The form itself does work.

Thank you.... Much much appreciated. Been banging my head on desk all day about this issue.

I completed these tasks. At what step can they enter the number of reasons now? Do i need to create another form?

I have one table that has equipment(8 unique equipment - long term I will do this for all, but for now I am just trying to figure out how to do for one) Table 1: equipments(pk) Table 2 : equipment(just one piece of equipment), Reason(pk) Table 3 : ID(pk), equipment, Reason, Entry Date, Num of...

Hello, First, I am newer to Access, and have been learning on the go/web tips/youtube. I am familiar with programming language basics, and am starting to understand VBA. I am working on a form which can populate multiple prepopulated text boxes. Basics I have a piece of equipment with...