Search results

  1. M

    print 2 pages on one page??

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

    print 2 pages on one page??

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

    print 2 pages on one page??

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

    Plese help! I'm at my last straw!

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

    Plese help! I'm at my last straw!

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

    Please help!

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

    Help formatting report?

    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!
  8. M

    Columns won't total-use NZ?

    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?
  9. M

    Columns won't total-use NZ?

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

    FILTERING

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

    AUTO SAVING

    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"...
  12. M

    FILTERING

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

    Using one Combo Box to control Another

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

    Basic-Synchronizing Combo Boxes

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

    Basic-Synchronizing Combo Boxes

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

    SEARCH FORM

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

    SEARCH FORM

    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?
Back
Top Bottom