Recent content by connerlowen

I am no longer getting the error, however it is not returning the value it should be returning. Edit: I realized that my field "DateOfPrice" was actually "DateOfPrices". After adding the "s" all is working correctly. Thank you so much!!

HI, I have a form that has a field that needs to get its data from a query based on two fields in the form. The following is my DLookUp statement: DLookup("[COMEX]", "OptionMetalsListQ", "[Metals] = '" & [cboMetals].[Column](1) & "'" And "[DateOfPrice] = " & Me.txtDateOfPrice) Comex...

please see edit to my reply above. thank you.

If I do that will it still write the information into the same ONE table/query that I need? Edit: This solution will not work for my problem. the form NewMetalF is always a subform of the form NewPartF. however the form NewPartF can be a single form or a subform to the form NewAssemblyF...

HI, I have a query that is the row source for a combo box on a form "NewPartF". This form can be a subform on form "NewPartF" or it can be a sub-subform on form "NewAssemblyF". I need the combo box to be filtered whether it is a subform or a sub-subform. When on the subform Access asks me...

The subNewPartF form is the parent to the InternalProcessF form and the NewMetalF Form. The form NewPartF can be a subform to the form NewAssemblyF, but can calso be its own individual form. There is a command button on the subNewPartF form that duplicates the current record on that form and the...

It is just a computer thing. My code in Access does not have the spaces. Thank you for your Response though.

This is my code currently. The first If clause that copies the record in the subform is working fine. The next two if clauses are to copy the record in the sub-subform. none of those records are being copied at all. 'On Error GoTo Err_Handler 'Purpose: Duplicate the main form record and...

tweaking Allen Browne Duplicate the record in form and subform code HI, I am using the code from AllenBrown website to duplicate the records in my main form and subform. The code works great for this purpose. My next task is to get the code to duplicate the records in my main form, subform...

I have many queries that I use for all of the needed calculations. I start by doing all of the calculations with the Metals in one query, then I have a second query that is based off of the first that basically takes all of the calculations from the metals and sums them all up to make a query...

that is not the full table structure. there is a PartID field as a PK in the table NewPartT and a PartID field as FK in the table NewMetalT.

HI, I have a database that is used to create Quotations. I need help with a query. I have a table "NewPartT" and a table "NewMetalT". There is a one to many relationship between the two tables. NewPartT is on the one side and NewMetalT is on the many side. I would like a query that shows...

HI, I have a lookup form that has an edit button. When this button is clicked The main form is opened to the correct record. On the main form there are two subforms which are not visible or enabled, and within each subform there are more subforms. I have two buttons on the mainform that...

He is spending a little money already, but nowhere as much as he would on a professional for a job like this or even better, an existing system through a third party. He knows that I am new at this, however he underestimates the difficulty of what he wants. The fact that he continues to make...

will do. I am having a little trouble with the actual report and the things that remain constant for each quote. but I am also having to make assumptions because my boss will not tell me exactly what he wants. I have decided to provide him with something that I can accomplish as an Access novice...