Search results

I have a form that displays the product line, model number, list price, and invoice price of a particular product, all of which can be edited on the form (see attached screenshot). However, the problem is that the only way to go from one product to another is by scrolling one by one through the...

I am attempting to show the status of an order in my report (confirmed, work in progress, waiting on finance, etc). These "status" entries are read off tblOrdersDetails, where they are listed by their StatusID- a serial number from 1 to 7. This serial number is linked to the actual status...

I am trying to create a single button that will open up a PivotTable form I have created and export it to Excel, but I don't know how to do it. I suspect a VBA command will do, or possibly a macro, but I am inexperienced with either of these and don't know where to begin. I have already...

I am trying to create a pivot table that will display and sort data from multiple tables simultaneously. I have selected all the fields that I want involved in the pivot table (really all the fields in my database), and used the wizard to create the table, but when I look at the drilldowns, they...

I am trying to add product information to an existing "OrderDetails" subform, so the user can input what products are in a particular order. However, product information is in a separate "Products" table, and there is no place in "OrderDetails" to store the data. ProductID is related to...

I have used a form to basically dump all of the data from all of my tables onto a PivotTable, but there is a problem. Even though the PivotTable has grown far beyond the size of the window, no scroll bars appear to let me look at offscreen data. I checked the format entry in the form's details...

I have created my tables and linked them to each other with relationships and made sure to check the "enforce referential integrity" button. But when I change the data in one table, it has absolutely no effect on its brother in the related table. I was under the impression that the whole point...

I am attempting to create a pivot table that will cover information across four tables, so that the information can all be sorted and moved about at will. Unfortunately, I have run into 2 problems. 1. It seems I can only put together tables that are directly related to each other. 2. It seems...

Is there any way to add calculation fields to a data display screen? I'd like to calculate the quarter from the month and the weeks extant between two dates, and then display this data with the relevant form/report/document.

I have been working on a form, but I don’t know how to produce the results that I want. What I envision is a pivot table with a lot of customer/product/promotion information, which is in turn sorted/filtered by dropdown fields for “Customer” and “Event.” Also, I would like to create...

This is my first time working with Access, and I'm finding it a little more difficult than I expected. I’m not sure what the best way is to organize these tables or even how many tables I want to make. I work for a company that sells goods to retailers, and this database is to keep track of...