Search results

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...

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...

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...

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...

HI, I have a database that will be used to generate quotation for the business that I am working for. I would like to run a report for the final Quotation with their respective fields. Within one Quotation Number there could be Parts Or Assemblies, Or both. Currently the database generated a...

Hi, I have a database that is going to be used to enter data for Quotations and generate Quotations. The function of generating new quotations is working okay, but there are other things my boss wants the database to do. There are three continuous forms that all have a look-up function, but...

Hi, I have a database that is used to generate quotations. I have a form that I want to use to Re-Quote something. By Re-Quote, I mean I want the employee to be able to go in and search for the Part desired for Re-Quoting and create a new quotation with all of the information from that part...

HI, I have a database that has a main form, and from that main form there are buttons that open their respected forms. I am curious as to how I control the size of all of my forms. They are all pop-ups at the moment. It all works fine on my monitor, but when opened on a smaller monitor it...

HI, I am working on a database to generate quotations. Within each quotation there could be a straight part, or an assembly. Within each assembly there could be a part, or a sub-assembly. Within each sub-assembly there are parts. There could be anywhere from 0 to 5 metals within each Part...

HI, I have a database that is used to create Quotations. After all of the information is entered the queries that hold the calculations must be run. I have lots of calculated that rely on other calculated fields. When I need to Sum all of the calculated fields in one field I must create a...

HI, I have been working on a database for over a month now, and my boss just threw a monkey wrench in my work. I believed that the Metal Market Prices would be entered once a week in the current DB. My boss informs me today that he wants an employee to go in every morning and enter that days...

HI, I have a very basic and general question. I have a database that has some one-to-many relationships. Is it possible for me to have no related record in the many side? I have a table "NewQuotationT" that is linked to table "NewQuotationPartT" and that table is linked to table...

HI, I have a form "NewMetalF" that has three combo boxes. The first one is used to choose "Precious Metal" or "Base Metal". The second one shows all the metals based on the first combo box. When I open the form in form view alone the combo boxes work flawlessly. I run the form "NewMetalF"...

HI, I have a form that has 3 combo boxes and a text box that I want to be a lookup. I have a little experience with DLookUp, but I do not think that will work here. The three combo boxes are linked to queries, and Tables. The first combo box is for choosing "Precious" or "Base" metals. The...

HI, This error message keeps popping up no matter what I do. "Database can't find the field 'QuotationNumber' referred to in your expression." I tried to define a text box by using a DLookUp function, however that did not work. I deleted the function, and now this error message keeps popping...

Hi, I have a form that generates a sequential number called the "QuoatationNumber". I would like this QuotationNumber to appear in a text box at the top of all of the following forms until the quotation is finished. I have tried DLookUp, but it only gets the first quotationnumber and does...

Hi, My database is using data that is entered by the employees to generate Quotations. There is one important piece of information that will not be entered by the employee. The quotes involve metals which are priced based on market price and weight. I am planning on integrating a data feed...

HI, I have a form with a subform. In the form's On Current event I have the subform's visible property set to false. There is a button that when clicked sets the subform's visible property to true. I want the subform to go to the first control in a new record which is a combo box. the...

HI, I want a combo box in a form for data entry. Is the best method in doing this creating a new combo box in the form and linking it to a table, or using a lookup field in my table? Thanks, Conner