Recent content by VANMAN

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

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

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

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

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

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

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.

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.

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

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

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

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

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

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

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