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 Mike Lewis 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. VANMAN

    wrong character gets printed from Crystal Viewer

    I have a number of reports that run through the crystal viewer that appear ok but when I try to print directly from the viewer to a minolta printer some of the character are wrong. Like dev will be aev. If I export to word it prints to the printer just fine. This happens to another printer as...
  2. VANMAN

    Linking to mdb causes Jet error

    I have an Access.MDE application that runs on several desktops and links the database on another PC. When trying to link to the db I am getting an error "Jet database engine could not find the object MSysIMEXColumns" I have check the application and the permissions are wide open. I...
  3. VANMAN

    Access Denied for Crystal Sample reports

    Just to let everyone know I have solved this problem. The Crystal Article ID is c2007312, the problem was the system environment variables. Once I changed these and rebooted the server the problem was fixed. Thanks
  4. VANMAN

    Access Denied for Crystal Sample reports

    Thanks I checked both the security permissions at the rpt level and web sharing on the folders and they are set for ADMIN and users. van
  5. VANMAN

    Access Denied for Crystal Sample reports

    I have just install the crystal 8 web server components on an NT 4 server and when I try to access the samples that use the ASP pages Active X viewer I get an error "Access Denied". When I check the ASP page it appears that the session object is the problem. The SelectionFormula.htm...
  6. VANMAN

    Docmd.close asks for Listbox parameters

    I have run in to a problem with Windows XP and Access 2000. My application with a form that has 2 list boxs on it, the second list box has a criteria set that gets its value from the first list box. So when an item in the first is clicked it does a requery on the second. When I close the form it...
  7. VANMAN

    Updating Field Size through SQL

    Well BOB'S YOUR UNCLE that worked like a hot dam, I used db.execute to do run it. I missed the ALTER COLUMN in my original execute. Thanks a bunch I will remember that.
  8. VANMAN

    Updating Field Size through SQL

    I am lazy and I was hoping I could do this with one command not 3, but I guess I spent more time trying to avoid the work than just getting it done. Thanks for your time I will do it that way.
  9. VANMAN

    Updating Field Size through SQL

    Sorry this will only create a new field not modify the size of an existing one.
  10. VANMAN

    Updating Field Size through SQL

    I have an Access DB that I am updating using VB and I want to increase the field Size of a TEXT field from 50 to 200. Can anyone tell me how this is done I was trying to use EXECUTE to do this but I can't find the correct command. Thanks
  11. VANMAN

    Report not maintaining Format

    yea. I didn't make this rpt myself and looking at the other sections and controls I noticed that the CANGROW was set to yes on some of them. I beleive that the cheque portion on the bottom is not the problem because the spacing seems to be intact just shifed down. This would lead me to guess...
  12. VANMAN

    Report not maintaining Format

    Thanks pdldavis This seems to work ok. I'll send a new executable to the customer and see if it fixes the problem.
  13. VANMAN

    Report not maintaining Format

    I have a report that has a detail section and several footers. One of the footers is the page footer that has Cheque information and has a preset size of 7.8 cm. This prints on a preprinted form. The size is set in the rpt page footer properties. When I run the report on my system the cheque...
  14. VANMAN

    Set the DefaultValue to the system date() for an Access Table

    Thanks, this works great. I thought I has already tested this but I must have missed it.
  15. VANMAN

    Set the DefaultValue to the system date() for an Access Table

    I am updating several hundred customers with some new tables for thier Access Database. I have created a table from SQL code and I am trying to set the tabledef Field.DEFAULTVALUE to the system date. Using the DATE() function. I am using the tabledef object and this code works for everything...
  16. VANMAN

    Unrecognized DB Format when running the MDE

    Thanks I was hopping it was something stupid I was doing.
  17. VANMAN

    Unrecognized DB Format when running the MDE

    I have the developer kit with both the Min and Full versions of the runtime files. According to MS these are free for distribution with your application if you have the Developer version. We currently bundle the Min runtime, database and the MDE together for installation on the customer system...
  18. VANMAN

    Unrecognized DB Format when running the MDE

    I have an Access2000 MDE that is packaged with the Access 2000 (min) runtime files and sent to customers. After installation the applicaion will work for several days but will then come up with an "Unrecognized Database format" error and the MDE will not open again. I send the customer...
  19. VANMAN

    SQL Processor usage

    Thanks alot for the info. This will help stream line the application we are using as well as server performance.
  20. VANMAN

    SQL Processor usage

    The current server has 256meg of ram and runs two mirrored drives one 4 gig and the other 6 gig. Both drives are having space problem some times running under 100meg of free space. I can see that this is a major problem as we still have our email, file and web server on the same machine.

Part and Inventory Search

Back
Top