Search results

By "Record Source" do you mean "Control Source"?

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

Thanks very much for all your help! Unfortunately, priorities have shifted at work and this has been moved to the back burner for now. I will get back on this as soon as I can.

Do you mean a status_status field in the query? If you mean a status_status field in the status table, that field is is always set, ie 1 -> Awaiting Customer Approval, 2-> Awaiting Finance approval, 7-> WIP, etc.

I have created a query, but am unsure what to do with it. So far, it seems little has changed. I imagine the next step would be to link something in the report to the query, but as I said before, I'm still a nublet when it comes to this. Attached (SS1) is a screenshot of the design view of...

I was hoping I wouldn't have to muck about with queries... I don't have much experience working with queries, so I am not sure how I would begin. Could you walk me through a simple example or link me to a resource where I could find this out? I have made a few blind attempts to build a query...

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

Yes, I am trying to have Excel open up the actual PivotTable. A lot of people are familiar with Excel and prefer to work with it instead of Access.

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

Yes, but the fields I want this form to report already exist in my Products table. Every row in OrderDetails pertains to one line in the order, to one product. I am trying to put all this information in one place so that it will be easy for the user to select which product this particular...

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

So, if I understand correctly, a table just stores raw data. The entire table structure is just big blobs of information, where a column/table may have a weak, vague relationship to another column/table, but it is certainly not explicit. There are orders, and there are customers. We know in...

I make fairly extensive use of lookup fields in my database. Is this a cause for concern? Mainly, I use it to link orders to holidays- a field in my tblOrders table is a lookup field for my tblEvents table, and when entering the relevant event for an order, I just select the value from the...

What about calculating weeks? Would I simply replace the "m" with a "w," or is there additional revising I'd have to do?

Here is my database uploaded. The problems are in frmSecondPivot, but they apply equally to all of my pivot tables.

First issue: How can I upload my db for people to see? Second issue Works like a charm. Do you have the commands for other views?

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

Thanks very much for the detailed explanations. It looks like it's about time for me to get familiar with Access's query system.

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