Search results

  1. K

    Unbound text box problem on report

    I have an unbound text box on several of my reports. It is there to prompt people to enter the "project name" because it is unique for each different report. When they type it in the dialog box that pops up it should place whatever they type on the report. It was working fine. Then all of a...
  2. K

    Keyboard Shortcut for Sort

    Does anyone know a keyboard shortcut for sort. Something like "cntrl S". Thanks to any replies.
  3. K

    Can't enter data into blank field on "one" side of outer join

    I have two tables. They are linked by one field. I would like to use a form to enter data records. The problem is that I have fields from both tables, and I can only enter data into the fields that come from one of the tables. For example, there's a job description in both tables. However...
  4. K

    Can you change the default options in the find dialog box?

    When I am in my form and want to find a specific record, I simply click on the find button to do it. Is it possible to change the default options in the find dialog box. For instance, instead of it checking the "Whole Field" can it start off with "Any Part Of Field" in the option group first...
  5. K

    Print only the records starting with A in a list

    I have a report that will print out 50+ pages. When I add one record that starts with A in my alphabetically listed report I would like to only print the records that start with A, in order to save pages. Is this possible. Thanks to all.
  6. K

    #error in a report

    I'm trying to group different section of a report header by the week ending date. I have tried putting =DateAdd("d",6-Weekday(Now()),Now()) in. It works, but it gives me the same week ending in every group, nothing unique to every group. If I drag my date field in the header it gives me the...
  7. K

    Showing on One record in a list of several of the same things

    I have a list of times in a record that show up several times one after the other. If in one record, there are several different listings of the same time, can I make it only show that time once in a report. I want to do this so I can print out 50 pages instead of 200.
  8. K

    Calculating Difference between Times

    I am creating a database that logs all the internet usage in the company. One field shows the time that the people are on each site. I need to perform a calculation that will take earliest time and the latest time and then tell me how long they were on. I need this because people can be on...
  9. K

    Week Ending in Report

    I need the option of putting a week ending and a week starting date on a report. I want this date to automatically update itself every time you open the report up. No matter what I try I can't figure out how to do it. Please give suggestions. Thank you.
  10. K

    Calculation in a form

    I have a calculation in one of my fields in a form. What is does is pulls two different currency numbers from two different fields, and then puts the percentage of difference in the calculated field. It works fine, but I need the option of putting text in the one field. When I do this I get...
Top Bottom