Search results

I figured out the problem. In case anyone was wondering I'll let you know if it happens to anyone else. I created these reports, but I didn't have any data in them. I was testing the text boxes with no data for it to show. As soon as I put some data in table/form for the query to pull out...

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

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

Carol, Thanks for your suggestion. It worked. I was unaware of that property.

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

Thanks, never thought of that!!

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

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.

Pat, Can you do the same type of thing in a form? Thanks. Kris [This message has been edited by kkulick (edited 07-21-2000).]

thanks again, but that still didn't work. I don't know what to do with this.

Pat, I've tried that also. I can get it to group by the week, but when I put the equation in that I mentioned earlier, it does not update for each group like the date does. Have an idea? Thanks.

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

That does help, but where the duplicates are not shown there are a lot of blank spaces. I need to compress the area that is blank and I don't know how to do that. Thanks

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.

The problem is that the times are all in one field. So I can't use [Field1]-[Field2]. Is there a way to do this in one field?

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

Eric, First I'd like to thank you for your help. What you sent me fixed all of my problems but one. Hopefully you can help me with this one also. I have one report that shows the whole month but has to be grouped by the week. There may be only be 2 or three different entries in a week, but...

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.

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