Search results for query: *

Are you testing if column PartNo has the same value as in NoSale for the same row? If you are then try this on your loop. Do While Not rsSel.EOF strPart = !PartNo strTemp = !NoSale if strTemp = strPart then rsSel.Delete...

How about this replace your code "If rs(PasswordFiled).Value = Trim(txtPassword.Text)" try this "If rs.Fields("PasswordFiled").Value = Trim(txtPassword.Text)" This should work if "PasswordFiled" is a field name in your Employees table. If that doesn't...

I also would likt to know how to get into SAP programming or development. I know it's tough to get a company to hire and train a newbie on SAP. I figure if I read the concept, at least I have the basic foundation to get my foot in the door. Any suggestion, reading materials? My local...

Hi, I have been beating my brains on this query and can't get it to work. tblItem has the field with id as the primary key id name 1 A 2 B 3 C tblCustom has the field (both field are foreign keys) itemid sideid 1 15 1 17 2 15 3 16 tblSide has...

From what I read on java.sun.com the exam hasn't changed since October 2001. The exam is still based on Java 2 because it covers mostly basic stuff. Each newer version applies to the more advance stuff in java. The only times that the newer versions may have an impact on the Java Exams are...

Hi, I just set up IIS on a win2k server. I have a router which has nat. I got that to work, logging in is fine. When I upload something to FTP server from a client PC, I get an error "Error opening data socket"... "Can't send command" I use CuteFTP to log in from the...

Hi I am trying to get my DataGrid column to display vertically instead of (default) horizontally. Does anyone know how to do this or know of another control I can use. Thanks in advance

Can you set the ID as a primary key with autonumber in the database?

I have a VB project using an MS Access DB of about 75 MB, and with a dozen or so tables. I installed the projects' exe file on Windows 98 se machines, and the db on a Win2K Advanced Server. When I run the progam, the I get an error immediately as I try to open the DB's ADO Active Connection...

OMG! I didn't realize until I read your last response that I had been putting TRUE at the end of the filename instead of the parameter. All that work and it never occured to me. It was right in front of my face all this time. Aughhhhhhh! I feel so.. duh Thank you so much Mr. Hamady, you...

Thank you for your response Mr. Hamady After I rebooted, I still got error 20544 from the application. :-( I have tried to open the report and save it under another name and created a fresh report (after I read your suggestions) but I still got the error. So I figured it can't be a crystal...

Hi, I have a vbproject which let me open around 20 reports. After that, I haven't been able to open another report. I got error 20554. I checked out seagate support and they say you can open the report as a temporary copy (unlimited). Here's my post on tek-tip with the link. I haven't...

Hi, I am using Crystal Reports 8.0 which directly connects to Access 2000. I am opening the report through visual basic 6.0, Crystal Reports Control(crystl32.ocx). The program I am working on requires multiple of reports with different ranges. In the begining the report preview worked fine...

I appreciate your help and response. I can't believe it was that simple. I was reading the Crystal report 8 complete reference and didn't even notice the "true" or "false". #-)

Thank you for your response to my question. I apologize if I wasn't clear. Your FAQ was helpful on clarifying my question. Here are some more info... The version of Crystal Reports I am using is 8.0. It connects to an access 2000 database through database files. My visual basic project...

Does anyone know how I can stop the parameter prompt from appearing through Visual Basic? I am passing parameter values through the paramter fields but don't want the parameter prompt to appear. Thanks in advance.

Which part of your code didn't work? You should be able to save a maskedbox to your table assuming it is in a recordset the same way as a textbox. Did you check the datatype the field you are saving to? If the user didn't didn't put a date in the format (mm/yy) the maskedit will try to save...

I know it's late but here's a site for the SCJD http://www.geocities.com/developergrp/ good luck

Awesome.. exactly what I was looking for! Thanks a million.

Hi, I am trying to quit a newly created word document after setting the document to print. Problem is that I get a error message that the print will cancel if I close the word document. How do I code it where I can close the word document after the print end? Here's a sample of my code...