Search results for query: *

Microsoft Access XP I am attempting to import an excel file into Access and I get "Microsoft Access has encountered a problem and needs to close". An associate of mine can import this file into a blank database on their desktop without any error. What could the problem be?

You Rock!

Crystal 11 Report Linked to Microsoft Access XP query In the detail section of this report I have projects listed by person. These projects roll up to a particular client. The detail look something like this Project Client Hours ABC Bank One 3 BCD Bank Two 4 CDE...

Hello SkipVought, Thank you for responding. If I put in a Pivot Table it is going to lump all the [Hours Remaining] in the week of the [Stop Date]. What I need to do is evenly distribute the [Hours Remaining] across the weeks from todays date through the week of the stop date.

Microsoft Access XP I am trying to create a query that takes [Hours remaining] on a project, looks at todays date and the project [StopDate] and evenly distributes these remaining hours into Weekly data columns. For example project ABC has 20 hours remaining and has a [StopDate] of 9/3/2006...

That's a good idea. Thank again!

Here was the problem. When I updated the drop-down list with new values I did not put any descriptions next to the values. There is an option to "Prompt by Description Only" which was set to yes.

I did use the import option from a text file. I am going to take the original file which is working and try replacing the drop down manually. I will get back to you to tell you if it works. Thanks you both for your help.

When you designed the report did you specify Static, and then insure that the default values list was populated? Yes

I converted the file to Crystal Reports 10 and I am still having the same issue. Are there any other possibilities?

The new default values are not there. The drop down for both fields are blank but when you hit the arrow for the drop down there are exactly 14 blank drop down values (which is the number of different values on the list). When I select one of the values and "submit" the value comes through...

Hello, I have a report developed in Crystal Reports XI. I just recently updated the drop down values for two parameter fields which originate in MS Access XP. When I placed this report in Crystal Enterprise 10 I see the two parameter fields but I cannot see any of the drop down values and if...

Crystal Enterprise 9 Is there any way I can download the recurring events information into an excel document? The information I need is Run Date and Time, Parameters, E-mail distribution, report format. It would take a while for me to go into the two screens for all recurring events. Thanks

Very helpful. Thanks!

In Microsoft Access XP I have a table called Assignments with fields called Project and Person. There are multiple people assigned to each project. I would like a query to roll up to one line for every Project with a field that lists all the people assigned to each project.

Is there an Invoice Number field in both tables? Is there a one record to one record relationship to these two tables? Do you want to combine the data in the two tables into one table or do you want to create a linked query that combines the data from the two seperate table. Please provide...

Thought so. Thanks.

Crystal 11 Data Source: Microsoft Access XP query I have added 36 fields in an access query to be added to a perviously existing Crystal Report. I have 4 Groups and a Grand Total section. Is there any way to select all these fields at the same time and create summaries in all groups plus the...

Is there any way to "record" my screen into a clip to use for training. For example someone would open a clip I sent them which shows my desktop screen, my mouse opening MS Access and selecting repair and compact from the menu options.

Found the problem. In the report header there was a OLE object with a company logo. Somewhere along the way this item got corrupted. When the OLE object was removed I was then able to export to Acrobat...Strange but true. I hope this problem helps someone else. Thanks for the help.