I have charts in Excel 2007 and on the x axis I have text. Due to space I would like the text to word wrap to make it look cleaner, save space and keep everything legible. Any thoughts? Thanks in advance.
I have a spreadsheet I converted from 2003 to 2007. When I am in page break preview I am not able to select the breaks to manually move them. I only get the big fat white crosshairs, not the arrows when hovering over the break. I have manually moved my page breaks without a problem in the...
I am creating a Crystal Report (10) on an Excel file. The Excel file has a particular field formatted as Text (includes both numbers or character records). Although, when Crystal links to the file it bring this field in as a number and eliminates all character records in the field.
Any...
I have a report that is showing me a report of records with a RecordID(number field). I am having an issue when I try to limit that list to one RecordID. The RecordID does exist in the original report. I create a condition that where the RecordID equal the number I want to see. When done...
Is there a software or something that will allow me to schedule a copy of files from my hard drive to a network location? Due to speed and some other issues, I would like to be able to use my files on my hard drive and then every evening have them automatically copy to a network location as a...
I have a formula that converts a date string to a date field.
If isnull(datestring)
Then
(I want the formula to show a null value)
Else
cdate(datestring)
Thanks in advance.
I have a Crystal Report that has dates and formulas based on dates. The formula includes string converted to dates(cdate()). When I run the report it shows perfect on the screen (Page 1). Although, when I try to see page 2, it takes me to the formula editor of one of my date formulas. I...
Is it possible in a Crystal Report to have every other line highligted. I like to do this in my reports to help seperate each record. It seems like there should be a way but I can't figure it out.
Thanks.
In a query I am adding four fields together in a new field. I am doing the calculation in build. It looks like this...
NewField: Field1 + Field2 + Field3 + Field4
This works fine as long as a have a number entered into every field. Although, if one field is blank, it does not add the others...
I am paste linking tables in Excel to Word. Is it possible to change a link to include an extra column while in Word? For instance if my linked table includes columns A,B and C. Later I add a Column D to the table. Can I change something in Word so that it picks up that extra column?
Thanks...
I have a form set up to accept a number. Currently it rounds the number automatically (1.5 = 2). I want it to accept a 1.5 or 1.75, etc. I have changed the format to standard and the decimals to "2" in both the table and the form properties, but it is still rounding the entry when it loses...
I am linking tables from MS Excel into a Word Document. I do this, center the table on the document and save. When I reopen the document the tables are aligned left instead of centered like they were when I saved the document.
Any ideas on what I could be doing wrong or need to do...
I have several number where I want to follow the number with an asterik or a symbol to callout a footnote. I know this can be done with text, but is there away to follow a number with a symbol without putting it in the next cell. That will not work in this case. I thought there must be an...
I have a database that appears to be corrupted. I can not even get to the tables before I am shut out. There appears to be no way to recover the data. Although, I was wondering if there was any software that you can download that repairs databases. Does there happen to be any freeware that...
I have a database that appears to be corrupted. I can not even get to the tables before I am shut out. There appears to be no way to recover the data. Although, I was wondering if there was any software that you can download that repairs databases. Does there happen to be any freeware that...
I got the error "Could not find 'Tempfield*0'" when trying to save a table after changing file names. Any idea what could be going on? I can not save the table at all.
I have set up a data entry form with a sub form. Although, the sub form does not fit all on one screen and as you tab from box to box it does not automatically move the screen down when you tab to the boxes that are not in view. Also, the scroll bar for the subform appears greyed out on the...
I have forms set up and when they open, the first record in the table shows up in the entry fields. Is there a way to get be blank or to even show a dummy record, instead of showing the data for the first record in the table?
Thanks for your help!
I have a sub form inside a main form. When I print, I am getting a empty page with just a page header after each record. My margins, height and widths appear to be fine. Any ideas on why it would be forcing a blank page after every record?
I am really perplexed on this and can't figure it...
I have a data entry form that is not only used as a means to enter data, but also a document that needs to be printed off. In my form view, the client is selected and only data for that client shows up on the form. Although, I will only want to print off the client in my database that is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.