Search results

I have reports which all rely on one query. The query looks something like this: ID VolumeA VolumeB VolumeC VolumeD Now, I have four separate reports. ReportA is filtered to bring back all lines that VolumeA <> 0. ReportB is filtered to bring back all lines...

Problem: I have a table with records that I would like my form to navigate through by date. My table looks like this: 1. 7/2006 2. 4/2006 3. 11/2006 4. 1/2006 When I open my form, it starts at 7/2006 and if I click "Next Record", it goes to 4/2006, and then 11/2006, and then 1/2006. I would...

I have Acrobat PDFMaker. In Access' file menu, there is a menu called Adobe PDF and under it, it allows you to merge multiple reports into a single PDF file. How can I create a button that can do this? Thanks in advance.

Okay, I have a datasheet form. The source is TableData. I want it to be filtered by date. The date is found on a separate form in txtDate. So here is what the "Filter" property looks like: ((TableData.Quarter=([Forms]![frmWhatever]![txtDate]))) Now here's the odd part. When I initially...

So my database is nearing completion, and things are looking great. Tables, queries, forms.. But I've got a weird problem for my reports. To make my reports easier to read, I drew lines to create a grid. The lines are hairline and are gray. When I print my reports to the color printer at my...

How to force someone to use a value in listbox in datasheet view? [NEW Problem] This question seems so simple, I feel like the answer is right in front of me. However, I have no idea how to solve this problem. Essentially, I have a field in a table (or data entry form in datasheet view) that...

Here's the situation. For data entry purposes, instead of typing out every single record, the user wants to copy and paste from Excel. This is, of course, possible by copying from Excel and using Paste Append in Access. HOWEVER, the average user will not know what Paste Append is and will...

I am creating a form that also contains a couple of subforms. However, when I view it outside of Design View, all the other controls adjacent to the subform part of the main form are pushed down and displayed below the subform. I want the subform and the main form's controls to be displayed...

Okay, here's the query as simplified as possible: Month - Days - PreviousMonth Month and Days are pulled from a table called Calendar. How do I get PreviousMonth to display the Month from the previous record? I was looking at a ranking formula, and it seems like it compares the field to...

Okay, for simplicity's sake, I have a data entry form. It is bound to tableData. Inputs are: ProductID Customer Name ProductID is a combo box on the form. There is another table called tableProduct. In this table, is ProductID and ProductName. For convenience sake, when a user chooses a...

Okay, for simplicity's sake, I have a data entry form. It is bound to tableData. Inputs are: ProductID Customer Name ProductID is a combo box. There is another table called tableProduct. In this table, is ProductID and ProductName. For convenience sake, when a user chooses a ProductID...

Say I have a form with three blank textboxes: Name Date Description And I have a table with those same fields: Name, Date, Description How can I code a button to add a new row (record) from the form using the textboxes after they have been filled in? I am familiar with the basic data entry...

I have a query that draws from two tables, and the field in question looks like this: X: [TableData]![FieldA]*[TableNumbers]![A]+[TableData]![FieldB]*[TableNumbers]![B] It all works fine and dandy, but once I set it to sort by this field and run the query, it gives me the parameter prompt...

I am basically making a form to streamline the processes and functionality of my database project, so basically it's just a form that runs queries. However, whenever it runs an action query, it always brings up a yes or no prompt for whatever action it is doing. Is there any way to disable...

Okay, I have two questions. First, if I have a table, and I want to combine two records together, how would I accomplish this? For example, say I have the following table. NAME SALES Bill 2000 Jim 500 Ted 1000 And by some miracle of science, Bill and Jim are able to fuse...