Search results

I have successfully added a subtotal from the subform to show the values on the parent form. My problem is I am being instructed to have a second subtotal from the subform for a different column of data on the parent form. When I add one subtotal, it works fine. Add a second, and I get a...

That worked perfectly with Nz. Thank you so much.

Hello and thanks to anyone in advance. I have a database that is used a phone log where users log their phone calls. My issue is that sometimes a user fails to log specific information in a field. Is there any way to create a query where it only returns records that are missing information...

Hello: Please see the image below. What I am trying to achieve is when the user clicks on a letter (26 labels), the subform is filtered to the field fldLETTER according to the label. I have about 19,000 records and each has a 1 letter code for sorting. So when they click on label1 (A), it...

Hello. I have a main form which has a list of vendors in a combo box. Once the user selects the vendor, and starts keying in order information in the subform, I want the combo box to be locked. I have tried using the On Got Focus with the following code, but unable to do so. The subform name...

Hello friends. Please see the image below. I have this datasheet attached to the main record by the DOCKETID. The actual record ID for the data in the datasheet is SUBDOCKETID. Whenever I add a new line into the datasheet for the given master record, it populates the data with the previous...

Hello, Would anyone know how to tab back to the first field in a subform using VBA? I would like to prevent a user from adding more than one record in a subform, yet I want them to be able to add a new record when the record doesn't exist, and at the same time be able to update information when...

Hello. I have 2 tables, one called tblDETAILS and another table called tblQUALIFY. In both tables, I have 3 fields, fldCOMP, fldQUALIFY, fldACTIONS. On my form for tblDETAILS, I have a combo box which has all three fields from tblQUALIFY. When the user selects the fldCOMP column, it has the...

I found this post from aways back, and would like to know if anyone knows a way to open the table from the combo box without having to create a "switchboard"? I appreciate any help. Thanks, Brad

If I use a composite key, how do I create a relationship between the 2 tables?

The goal of the database is to track quotes for specific OEM customers. Each year the OEM will have a new quote, and each quote may have multiple products associated with it. Per my manager, the quote number needs to be "quote type" - "year" & "increment (record id)" Since modifying the...

I created a form which allows a user to select the Year and the Quote Type, and then created an unbound text box(Text5 below) which concatenates in the control source the Quote type, year, and record ID. This field becomes a quotation number. What I would like to know is if there is anyway to...

Paul: I tried your code suggestion, and although I didn't get any errors from it, it still didn't populate. The goal I am trying to achieve is this. I am being asked to create a database where we manage sales quotes for OEMS (sub-distributors) on a yearly basis. The tree is YEAR...

I went and tried your suggestion, but the OEM combo box still doesn't populate. Do you have any suggestions?

Hello: I have created 3 cascading combo boxes, cboYEAR, cboCUSTOMER, cboOEM. The database is based off the year. The cboCUSTOMER loads just fine afterUpdate, but I need to load the cboOEM based on the cboCUSTOMER and the cboYEAR. For some reason it won't work. My code that I have for...

Hello: I am new to access and have a question to see if someone can point me in the right direction. Currently, I have created the tables and have created the relationships as shown in the picture before. The goal of the database is to create a form where the user selects a year, selects...