Search results

I am trying to build a query that would filter record that have an quote expiration date between the current date and a date that the system prompts for. I want the system to automatically use the current date as the Start Date, and prompt for the exp date. What I am trying to do is avoid...

In searching the posts..I haven't came across a similar problem yet. I have modified the switchboard of my db wiht some graphics and buttons and such. The opening page works fine, but once I select one of the choices, the new switchboard opens with the uttons visible, but the text on them is...

I have several reports that have a unique problem. When I access the report on my system (design mod's, etc) and I go into page setup, I save the margin and paper layout settings without a problem.....but when the user I created this system for opens the report, it reverts back to 1 inch around...

Sorry for the lame question, but does Access allow you to create external functions via macros (print to file, etc)like you can in Word and other Office apps? I would like to have a report print out to a file so that I can use Adobe's distiller and create PDF's from it? Any thoughts?

I have created a report that contains a group footer WITHIN a group footer. I don't know if that is the cause, but when I trey to generate the report as a Data Access Page, I get the following error: "Database is unable to create the data access page- the file you attempted to load was not...

Here is my situation. I am designing a report that will show projected closings in a particular month. These closings are grouped by individual builder, and then group by project name within the builder group. Can a report have a group footer within a group footer? I want to use the first group...

My question is (I hope) fairly straight forward: I want lines around each field within my report. Basically I want the data to be similar to a datasheet (with the lines around each field, like a chart) That way data is more easily read accross the report? Any way to do this?

My database is fairly simple and consists of 3 forms for the entire process: 1. Client information User inputs - file # (primary key), last name, first name 2. File Sumarry - conatains all other fields, with the exception of the 3rd forms fields 3. Concessions and amounts What I thought...

I have created a sub-form bound to a separate table and joined via a record number. I have created a control button on my main form that brings up the sub-form. A user inputs specific data, saves and exits the sub-form, returning to the main form. When the user then selects to go back into the...

I have a report (based on a query) that generates status/sales reoprt. We use various descriptions in our status field and the report shows all records so we can see where our files stand in our process. Is it possible to have the report page break between each of the different status types...

I beleive I have an idea on how to do this, but I want to get some valued opinions first- I want to generate a report based on a speciic value that the user is prompted for, then have an underlying query pull all the records that match that value and generate the desired report. Should I create...

I have 2 questions..so I will divide them inot 2 separate posts: I use a query as the source for a report. This query includes a field that has multiple possibilities for the value (selected from a separate linked table). I want to count the # of instances that a specific value comes up and...

I have read through most of the posts, and I have not seen a clear answer on this one: I want to design a query (a select query I beleive) that will group records that contain a particular field. This field is a linked field to another table that provides about 15 diffeent possible entries. Can...

First off-- Thanks to everyone for their willingness to help us "scrubs" with this mind-boggling" software. My question is this: I created a query that pulls specific fields from records, groups them together then presents them (I beleive it is a select query). I want to add 2 separate columns...

I am COMPLETELY new to queries within Access. Here is my situation. I have built a database to handle specific projects. I have created tables based on each of these projects. The tables all contain the same fields, but the data is unique by project name. The question (or problem) I have is how...