Search results for query: *

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

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!

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

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

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

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

Thanks so MUCH! Kamille

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.

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

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

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

Thanks a bunch! It works! Kamille!

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

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

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