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?

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

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

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

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.

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.

Report Version Crystal 11 Enterprise Version 9 and 10 Data Source MS Access XP Because of issues with Crystal Enterprise 10 we are temporarily running our Crystal Reports on Crystal Enterprise 9 (which was the original version we used). An associate of mine copied a report from Enterprise...

I have a Crystal Report in version 11 that shows projects grouped by Client then by Status which has three possible values (pipeline, signed, and losses). If any of the three Status have no records my boss would like a blank row in the group by to show up anyway. Any ideas on how to do this?

Hello, We recently switched from Crystal Enterprise 9 to 10. A report which was designed to either Print in Legal size landscape or somehow automatically fit to regular landscape in spite of going out to the margin width of 13.5 no longer fits on one page of an Acrobat file. What could be...

How do I reproduce exactly the column heading alignment that I get when I choose Export Data in Excel "Typical" in Crystal Reports XI when I am scheduling reports in Crystal Enterprise 9? For some reason the ordering is different.

Hello, I have never created an array before but I know enough to know that I probably need to create one now. Unfortunately the problem I have does not seem like a beginner array problem. Access XP I have fields on a form called txtpast01, txtjan200601, ...txtdec200701, txtfuture01 to...

Hello, I am a self trained Microsoft Access programmer. Though I have learned a lot of different techniques through doing, I would like a more foundational understanding of the languages that makes products such as Access, and SQL server work so that I can become a better programmer. Could...

I am looking at a form in MS AccessXP. The scroll bars are set to Both yet when the form is opened in form view the scroll bars go away. Where can I find this setting which is repressing the scroll bar so I can shut it off?

I have a series of text fields in an MS Access XP form. They represent number values as shown below. I do not want to convert these values into numbers but on the form I want to make sure that the text field values entered if they were numbered equals 100. Any ideas? Field1 = "000" Field2 =...

I have fields named after the month and year for the next two years (Jan2006 to Dec2007) with a field called "past" for values before Jan2006 and "future" for fields after Dec2007. The field names have a number value after them from (01-08) which relates to another particular field value in a...

In a Microsoft Access XP query how do I remove the last 8 characters of the Field record values. Example: Field 1 Monday Forecast Tuesday Forecast Change to Field 1 Monday Tuesday

Please Help I have a module in MS Access XP which is downloading and saving fields from an external source to a table. The code is taking the external field names and making each one a record. If the field names are Red, Blue, Green Field1 in the table would have three records with the value...

Hello, In a Microsoft XP module I currently have two procedures that are adding values to a table called "Project Function". The way these two procedures are currently designed two seperate records are being created to enter all field data into the table when I want these two functions to put...