Search results

For further clarification, I have a combo box for Product Type which then filters another combo box for a "sub type", and then a text field to enter the product name directly. It is the text field that I am trying to use as part of the criteria for filtering a subform containing the product...

I do have a combo box where the user selects the product type and that result filters the other combo. That all works fine. The problem is on the item field where I want to filter it every time the user types a new key. The code above works on some computers, but I have other computers where...

I have a form showing a list of products. There are over 10,000 items, so the user has the ability to add a product type which will filter the list. There is also a text field where the user can start to type an item name and the list will filter on each keystroke to narrow down the list. I...

Here is the sql for the query that opens the product form: SELECT tblAMPItems.lngAMPItemID, tblAMPItems.lngAMPItemType AS Category, tblAMPItems.lngItemSubTypeID AS SubCategory, tblAMPItems.strAMPItemName AS Name, tblAMPItems.strAMPDescription AS Description...

I have a query using 3 functions to calculate inventory status on 10,000 items. It originally ran very slowly and I have restructured some of the relationships to get better performance. When it was going so slowly and I was trying to figure it out, I created a temporary table and had the...

OK. You are officially a genius. I tried to take create a database with just the problem form and related tables, etc. I couldn't upload it because of a security issue? I don't know what that is about. However, in looking at the relationships, I realized that a new table I created for...

I am using Access 2010 to update a database originally created in Access 2000. The database keeps track of orders, purchase orders, inventory, etc. The original database had fields in the products table for the quantity on hand, on order, etc. Every time a product was sold or purchased or...

Thanks. It is a logon form and the main menu so I wanted the custom form to show up. I will try to work around, or give up on the pop-up idea. Thanks for your response.

I have a custom ribbon attached to my main menu. I decided to change it to a pop-up form and the custom ribbon doesn't display. Is there something special about the ribbon for pop-ups, or is it not possible to create a custom ribbon for a pop-up form. :confused:

Never Mind. I figured it out.

Anyway to keep Access from changing the format when I import all my new forms?

I might have figured it out?? I created a new database with only the tables and forms that were problematic. The new database works fine. Maybe there is corruption in the database that I am using? If I create a new database and transfer everything over, maybe that will solve the problem...

I have a form attached to a table. When I go to edit the form and try to add fields, there is one particular field that it doesn't recognize. The control is a combo box attached to a form called intShop. It has a value list with 3 items in it and the first column is the data that is saved, it...