Search results

  1. P

    Change Row Color every 'x' rows in Report Footer

    Have been searching a while on this and other forums for a solution to this problem: I have a report that shows 79 rows of ranked data, only it all appears in the GroupFooter section. (Got rid of the Detail Section, for various reasons). I've been exploring forums to try and find a way and/or...
  2. P

    Urgent Required Field Advice Needed

    I'm looking for advice on the best method to accomplish the following from the esteemed members of this Forum (You all have provided excellent advice in the past to this Access Dummy, with my thanks), (I've also searched the forums without result): I would like to make several fields "required"...
  3. P

    Query to return record set where 1 column is greater than another

    Creating a query in Design View, how does one create a query in the "Condition" field that tells the Access to return the record set where the contents of one column is greater than the other? Table Name=SURVEY_RAW_DATA Column Name=TOTAL_EXP Column Name=TOTAL_NX There are obviously many more...
  4. P

    Getting rid of the Autoformatting on a Form

    Am I missing something here, or is it impossible to remove the auto formatting on a form, like the "blueprint", "sumi painting" etc.?? I can't seem to just change the background to a solid color. How does one do this? Thanks in advance. P.S. I may just be thick, it's probably something...
  5. P

    Any Ideas on Exporting Reports to PowerPoint?

    I have a database that contains about 20 reports that I have designed. Here is the problem. How to export these report's pages onto PowerPoint slides? Any ideas? I've used the built in Tools/Office Links/Publish it with Word, and Publish it with Excel to no avail. What I'm looking for is to...
  6. P

    How to run a subtotal and ranking query

    Have a table containing a column called "BOC" (Budget Object Code) that contains approximately 85 different 4 digit codes, with one selected for each row. (See sample below). Table has 30,000 rows of data. What I need to do is run a query that will give me a subtotal dollar amount for each...
  7. P

    Create a Table Listing

    Does anyone know a way that I can create a simple listing of all the tables in a database? I don't need details of each table, just a listing of all the tables names in a database, preferably in a format that I can export to an Excel spreadsheet so I can save and print/manipulate/email them...
Back
Top Bottom