Search results

I have a form that has a Drop-Down Menu. After making the selection from the Drop-Down, I have a macro that runs a query. The query displays the fields that I need and also the field that has the Value of the Drop-Down from the form. (The records that meet the criteria should show in a report...

My client has Customers that are taxable and other Customers are not taxable. As it stands now, I have Text Boxes that are performing my calculations: Example: Text Box - Order Total : (Displays the total amount for Orders in this Order) Text Box - Tax Amount : (Formula that calculates Order...

Thanking everyone in advance. I have a form that has 2 subforms. Both subforms perform calculations. In the footer of both subforms, I have a Text box that has the totals that I need. (So far, this is a success.) Here is my issue: If the second subform does not have a value, my Text Box Grand...

I have a form that also has a subform. I placed a (Delete) button on the form - Main form. When I press the button to delete that particular record, I get the error: The record cannot be deleted or changed because Table 'Contract Product Details' includes related records. Does anyone have a...

Thanks again for the great help. My project has really moved along much smoother and quicker since I've gotten help from the contacts in ACCESS WORLD. TO my issue now: I have a database that stores information for orders. My Order Form is performing great, (now). The data that is collected...

I have an issue with a text box. I have a Combo Box that have 4 fields. When I click the box, the correct drop down options appear. I store the Name in the combo box. Next, I have the text box below it, storing the Price of the Item: =[Combo Box Name].[Column](2). This is correct because the...

I have a question about doing a database program in relation to the internet. The following is a layout of what is required: I've been asked to do a database that takes Customer Orders. Here is my issue: After developing the database, what methods should I use to have it connect to the...

First, thank everyone for previous assistance. You all are really fantastic. Second, hope everyone has enjoyed the holidays. Peace and Love. I have a situation with a Subform that has 2 drop-down menus. The first drop-down selects a product from a list. The 2nd drop down displays a listing of...

I have an Orders Form. After making a selection from Combo Box, a Subform is correctly updated. Once entering the Subform, I select the Product and the correct items are displayed in the Drop Down Menu. (Good So Far) After selection is made, Tab goes to the Price Column with the correct price...

Hello. I really need help with this problem. I have 4 tables: 1. OrderProduct Details: OrderProduct Details ID Order ID Product ID Quantity 2. Product Info: Product ID Name Description 3. Orders: Orders ID 4. Product Cost: Product Cost ID Product ID Price Level (This states the price level -...

I want to set the number of records that can be entered into a datasheet to 3. How can this be done? Thanking you in advance.

I am working on an Order Form. My first Combo Box has a list of Members. The second Combo Box will display the list of Recipients that are associated with the Member that has been selected in the 1st Combo Box. That is working correctly. Here is the problem: Each time I move from this form but...

First, I'd like to thank those that have previously helped me in the past. This is one of the best groups to come for if a person has questions about MS Access.... I have a: Items Table Items Table has Item ID, Name, Cost, and Category. I am going to use this table when the Date Entry person...

I have an Item Table that needs to be changed and I need your assistance please. In my Item Table: Item ID Item Number Item Description Item Cost The problem arises with the Item Cost. As an example, I need to give the Data Entry person the ability to select 1 of 3 prices. Low - $60 Mid - $70...

I have an access database that records data entry. On each form, I'd like to provide HELP...giving a description of how to use that particular screen. I have HTML HELP, a button on each form that connects to this program. I want to make it context - sensitive, pulling up that particular form...

Hello. I have created a database using MS Access 2016. I have also setup HTML-Help Workshop to handle all of my Help files. I have no problem with placing a button on any form and getting the chm to display. The default topic shows when I click the button. Good so far. Once I am on a specific...

Hello. I need assistance. I am getting the error - Microsoft Security Warning - dealing with Hyperlinks. I wanted to change the settings in the registry but I don't see the options that were suggested. Is there anyone that has suggestions? Thanking you in advance.

Hello Everyone. I have form that has a combo box. (Player Name and Player Current are the values that exist) After making the selection of the player that I want, I'd like to set the value of Player Current to YES. Tried several things and nothing is working correctly. Thanking you in advance.

Hello: I have a form that has a listing of players. I also have a check box by each name. The entry person will select 4 players. I want the program to verify the number of players that were selected. If the number of players is not 4, I want to notify the entry person and retry. Thank you...

Hello; I need assistance with this situation: I have a form that I'd like to place a button. The button's sole purpose is to open a drop down (display the contents of the dropdown). Thanking you in advance.