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!

  • Congratulations strongm 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. Erbium

    Display Record Selection Criteria on Report

    Yes, if you input parameters then use them in the formula, you simply print them on the report, typically header or footer area. If you are hard coding the date, STOP THAT!
  2. Erbium

    Parsing Complex Addresses

    If you use address scrubber databases you can standardize them but more importantly you can append lat lon info at street level. this would let you group addresses nearby. the software is expensive but any bulk mailing company will typically scrub the files for you and return them in identical...
  3. Erbium

    Can I link use two linked fields to link two tables?

    When test data works OK but live tables take a real long time or 'forever', often the problem is no index the join can use. The result is that the whole joined table is scanned for each record. Test files can do this for a few records but large files may hang forever. Use a tool that shows...
  4. Erbium

    Powerpoint web page not work 'on the web'

    I got it working! but only on a different web site I have that is windoze hosted. I can't think of any dif except file name upper and lower case is not the same on linux as it is on windoze file system. Thanks for your suggestions!
  5. Erbium

    Powerpoint web page not work 'on the web'

    One more thing: I checked the web server logs and it gives 404 errors (file missing) for '../notes_flag.gif' and '../embed'. I swear I copied the whole folder up there but I'll check when I get home, see if that fixes it.
  6. Erbium

    Powerpoint web page not work 'on the web'

    Yes, powerpoint creates a web page save in a new folder. I copied the entire folder, and I can see the jpegs and png's, the same ones in the presentation up on the website, so that shouldn't be the problem. and it creates a start page one level down. copied that too. Could this somehow be a...
  7. Erbium

    Powerpoint web page not work 'on the web'

    Hi everyone I have a powerpoint slide show with 56 slides. I exported it to 'web page' by 'save as'. This shows an index of your slides on left of web frame, and the slide picture in the middle. Works great! and the slide show feature also works. However I wanted to share this with the...
  8. Erbium

    Deleting an output field

    You get duplicate records either because the records are actually in the database or its joined wrong. you can do a group by the field if it turns out the data is repeated in the database and you don't need to show them all. you can show either one figure or total the repeated recs if needed...
  9. Erbium

    Crystal Reports 8.5

    CR85User is right. there had to have been in place some sort of connection, probably ODBC on old computer. Just because you don't know about it doesn't mean it wasn't there. You can go into the windoze menus and check it, test it.
  10. Erbium

    Can I export to .xls with formulas?

    I have a sales report showing GL sales allocations by customer broken down by cost center. One of our account reps wants to take the exported spreadsheet for this customer, delete some lines / columns and have it automatically re-calculate the grand totals (which I currently provide as a value...
  11. Erbium

    .rar file?

    I reran this report and it ran OK. User complained was taking a while but it has subreports, took 20 minutes. They only run this once a year. The .rar file seems to indicate an error, I'm guessing that maybe PC was flaky - low on memory, etc; She only reboots 2x a week or so. So end result...
  12. Erbium

    .rar file?

    no, just display on screen so user can print this. the .rar file just shows up after taking long time to run. I just looked and .rpt had not been modified for almost a year. I tried running it and the parameters box doesn't go away after hitting 'ok'. the bottom part says 'accessing...
  13. Erbium

    .rar file?

    Hi everyone We have some production reports that I developed, haven't touched in a while. User today complained that running slow, didn't come up with any records at the end, and it produced a file with the report name and '.rar' in the directory the report is in. Does this indicate an error...
  14. Erbium

    Informatica Certification

    You can join their developer network, $500/year. you can then get doc and tutorials online. Brainbench has an informatica test. ($) ITToolbox also has informatica thread you can follow. See if you can understand the questions and answers, could help.
  15. Erbium

    Rotate pix in VB2005?

    I'll try these. Parts of VB still confuse me so may be a while before I get it working, and I'm just finishing up other parts of the prog. Thanks both!
  16. Erbium

    Rotate pix in VB2005?

    Hi everyone I have a picturebox and wondering if it would be real easy to add a button to rotate right or left. I need to be able to save the rotated picture out to disk also, to the same or possibly a new file name. I'm scrolling pictures thru the screen from a directory and need users...
  17. Erbium

    Problem with UPDATE sql command not changing values on VB form

    I'll try the trim. Was inputting from text box so didn't even think might be interpreted as a number. Only nodeid is a key, no other fields even indexed. Still haven't figured out why update not working or throwing an error when it fails to update the values. However I substituted a delete...
  18. Erbium

    Problem with UPDATE sql command not changing values on VB form

    Hi all I've got a vb 2005 form with textboxes for data from fields and buttons: read, write, update, del I've got it querying an access database, and grabbing data from a table. Read works, if record already present, does a SELECT write works, if record NOT present, does an INSERT del works...
  19. Erbium

    problem using UPDATE sql command

    Hi all I've got a vb 2005 form with textboxes for data from fields and buttons: read, write, update, del I've got it querying an access database, and grabbing data from a table. Read works, if record already present, does a SELECT write works, if record NOT present, does an INSERT del works...
  20. Erbium

    How to clear a picturebox?

    Thanks, that worked!

Part and Inventory Search

Back
Top