Recent content by jfarrell

Due to a virus I have to fdisk and reformat my hard drive. Norton anti virus gives messages that a virus is on my harddrive. None of the executables files will open including Norton. So I will reformat. The harddrive a C: drive and a D: drive with windows 98. I want to combine the C: and D: into...

Dear Readers, can you help me change the code below into a procedure (Create or Replace Procedure) and then an anonymous block to execute it. Unfortunately I do not have the skills to do it. Thankyou very much. Jack --Force any entries from the prompt to upper case set sqlcase upper set...

Mike, can you help with one adjustment. The counts are not comming out correct. I probably have the refresh in the wrong place. i did the code using your help. It was a great help. For this I thank you. Private Sub cmdCandidate_Click() lstCandidate.AddItem txtCandidate.Text ReDim...

I have a ListBox problem I have been laboring over and cannot find the solution. I would appreciate any help given. The specs are for two List boxes. The left list box has the name of candidates. When someone clicks on a candidates name it records his vote. When a Tally Vote command button is...

Oliver, many thanks for your help. It seems to be working with your help. May You Live Long and Prosper John PS. I cannot thank you enough!

The Delete seems to work ok except the navigation buttons have trouble navigating after a delete. The insert statement does not appear to insert a record at first but after exiting out of program and reentry the record is there along with a blank record. I also tried this code: Private Sub...

Thanks for the suggestion Oliver I gave it a try but still come up with the error 'The operation requested by the application is not allowed in this context.' When I look for the record after this message its not there. If I Exit out and come back in the record is there along with a blank...

Can someone help me with this code. The sql code has bugs in it I have tried to figure out for a week without success. When I delete out a record the navigation buttons do not work right. And when I insert the record the record doesn't show up until I exit out and then come back into the...

I need help with an SQL DELETE statement using Access97, ADO and VB. I'm getting the error message 'No Value given for one or more required parameters' I have tried every which way to make it work. My code is as follows. Private Sub cmdDelete_Click() Dim strSQL As String Dim cnAP As Connection...

If anyone can help me I would appreciate it. I have a VB form connected to an Access97 table via ADO. The ADO object is adoSchool. I would like to insert records but I get error codes. My code looks like this! Private Sub cmdInsert_Click() Dim objComm As ADODB.Command Set objComm = New...

I tried changing the string to integer but that didn't fix the problem. Anyother ideas please. John

Can someone help me with this. I have a form with a find command button(cmdFind). I'm using ADO, VB and Access. It works but the VB code must be changed to Sql as a requirement of the project. The code in Vb needs to be converted to Sql is as follows. Private Sub cmdFind() Dim strLast As...

If anyone can help me with this I would appreciate it. I have a bound DataList (DataList1) Control bound to Adodc1. Data Source Adodc1 Bound Column Empid Data Field Empid List Field LName Row Source Adodc1 My code is as follows Private Sub DataList1_MouseUp(.... Adodc1.Recordset.BookMark...

If anyone can shed some light on this I would appreciate it. I'm new to ADO. I have an Access 97 Database with several tables. Student table, test table, in a one to many relationships. When I click on a DataList control that is linked up to Adodc1 with the recordsource Student, I am try...

I'm importing a large text file as a class project and the requirement is that we use ADO. I can get this code to work fine in DAO but not in ADO. If anyone can critique this code and tell me what I'm doing wrong I would appreciate it. The text file is fixed width and I'm trying to import it...