Search results

I've chosen the columns setting and my columns fit, but at the bottom off that box you can chose whether your columns go accross then down or down then accross. I have chosen down then accross. My first 6 columns go accross the page fine, with everything correctly aligned under them, then my...

I have set my grouping property in the Sorting and grouping window to "Whole Group" so that it would keep it on one page, but it doesn't. Maybe this has something to do with it. I have 6 columns going down then accross. I want them to go down and accross then, starting halfway down the page go...

I have a report with multiple sorting and grouping. It also has multiple columns. Each new column is a new day with multiple jobs listed down. When this report prints, it only prints one row of days on each page. My question is: How can I get 2 rows to print on 1 page? I'm wondering if I...

Thanks for all of the suggestions. I have used them and my report looks very close to what I need. It's not perfect yet, but close.

I have been working on a project for a while. I have gotten to the point of making my reports. My table has jobs by date. My first problem is that in order to get everything I need on one page, I need to get the font smaller. Can it go below 8 points? My next problem, and this is making...

I have a form and a subform. My 2 forms are linked by a bid number. I also want 3 other fields to show up on my subform that are from the original table (main form). I want to be able to update these fields, if needed, for the 2nd table (subform) without changing them in the original table...

I have a report that is sorted by dates and grouped by weeks, but our users want to see this information in calendar form. I've searched for solutions without any luck. Any suggestions would be greatly appreciated!

Thank you! It worked. But I forgot to put the 0 at the end and it still worked. Should I go back and put it in or will that matter?

I have two columns of amounts in my report that I get totals on. The columns don't always show a total and it happends when one of the totals contains all null values. How can I get those columns to total? I have been reading about the Nz function. Should I use that? I've been expiramenting...

I will try that, but where do I go to put the SQL statement. I haven't had much luck when writing SQL. Thanks!

I have a form that I have automated with macros to automatically save a filter by form. However, when I come to the save message box my macro stops and will not save automatically. I don't want the user to have to save this. Is there some way to do this. I have tried using the "Set Warnings"...

When I filter records on a form, does it filter the actual Record source (table or query)? I need to display all fields of the filtered records only. Thanks in advance.

That is something I have been working on too. Microsoft Article ID: Q97624 gives an example and explanation on this. I hope it helps you more than it did me.

Thank you! These fields are related, but I'm not sure if it's what you mean. All of these fields are in one table. I have several fields on one table including: State,Drafter, and Job Type which are all related to the Job number(primary key). So if I had 3 combo boxes(State, Drafter, and...

I have been trying and trying to synchronize 2 combo boxes that are for 2 fields from the same table. I don't know if that's even possible. Eventually I would like to do more than 2 combo boxes and have any one of them synchronize with another one (whichever 2 the user wants). Right now I...

I am not very familiar with visual basic. I have been using Access for a little over 1 year so I'm still learning. I'm pretty good at writing macros with the drop down lists. I've tried a few things that won't work so I was hoping for some other ideas.

I AM DESIGNING A DATABASE FOR MY COMPANY. I HAVE BEEN TRYING TO MAKE A FORM SO THAT PEOPLE CAN SEARCH ALL RECORDS BY ANY FIELD WITHOUT USING ANY VISUAL BASIC. THERE ARE ABOUT 20 FIELDS WE NEED TO BE ABLE TO SEARCH. ANY IDEAS?