Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Kamille

    Do NOT allow Scrolling!!!

    I have created an EDIT Form. This Form allows users to first look-up the "project" they want to Edit using a drop-down menu. Once the "project" is selected the fields are populated with the information for that project which you can then Edit and Save. Here's the PROBLEM: When the User...
  2. Kamille

    Reports

    THANKS SO MUCH! I had "Select Field1, Field2, Field3 FROM Table1" However my Bound Column was set wrong, it was set to 1 but needed to be set to 2 so I can access Field 2. This helps so much, Thanks Again! Kamille!
  3. Kamille

    Reports

    Thanks for all the tips I appreciate it. I tried that but it is still not working the report is blank. If I add a text box instead of a combo box and type in the name of the company, it works for: [Forms]![Form Name]![text36] but for some reason if I have a combo box and I write: [Forms]![Form...
  4. Kamille

    Reports

    Thanks for the suggestion. I do have a parameter query set up as a record source for my report but I don't know how to automatically set the combo box value as the parameter without having a pop up message box appearing asking for the company name. How do I autofeed the combo box value that the...
  5. Kamille

    Reports

    Hello "Help-WORLD" Hope you can help me solve this. On a form I have a combo box containing about 100 company names. Scenario: A user opens the form selects a company name from the drop down list and then clicks a preview report command button which should then open up a report for THAT...
  6. Kamille

    Fields?

    Thanks Jim, Actually I'm just trying to merge a data set which originally sits in 2 excel files because the file was too large. So this file was split horizontally in to 2 excel files. I need to merge this info back into a single file format so I was trying to conquer this in Access, but my...
  7. Kamille

    Fields?

    Thanks so MUCH! Kamille
  8. Kamille

    Fields?

    In Access 2002 what is the maxium amount of fields which can be displayed by a query? I'm trying output data through a query and it only allows me to view it through design view and won't let me run the query. I am trying to output a queury with 324 column fields. Thanks.
  9. Kamille

    Sorting

    Thanks Randy for your tips! It works great now! Kamille.
  10. Kamille

    Sorting

    The info generated on the report looks something like this: DATE PROD1 PROD2 PROD3 ... april 20 1 5 august 15 25 12 july 5 8 18 june 9...
  11. Kamille

    Sorting

    That could be the problem because in the crosstab query used to generate the report I typed the following under "Field" : Date: Format([PrevDate],"mmmm yyyy"), where PrevDate in it's table is declared as type: Date\Time but I guess in the formatting this type gets lost and is...
  12. Kamille

    Displaying a Crosstab query on a Report

    Thanks a bunch! It works! Kamille!
  13. Kamille

    Sorting

    Hi, I have a question about sorting. I have created a report displaying a cross-tab. The ROW Headers are months of the year. In report wizard I stated to have my rows sorted. But now when I view my report the months are sorted but Alphabetically i.e April, August, July, June .... instead of...
  14. Kamille

    Displaying a Crosstab query on a Report

    Thanks Duane, but I'm still having trouble. I would like to base my report on the parameter based crosstab query. The Query when I run it asks for a Date Range (i.e jan 1 2003 to oct 31 2003...by the way Happy Halloween!)Also note: the field [prevdate] I used to capture the date I...
  15. Kamille

    Displaying a Crosstab query on a Report

    Hi, I have developed a "Crosstab Query" based on an existing query. Works great...looks like: Location Date Canada U.S. Europe Asia Jan 4 5 3 10 Feb 5 5 6 5 Mar 1 1 9 6 Now I would like to display this information(looking...

Part and Inventory Search

Back
Top