Search results for query: *

I'm going to have to give up on this one. I'm trying to create a program (and am actually pleased with the progress) but there are a few things that are beyond me, I've gotton some great tips from this forum and that has allowed me to progress as far as I have. But I realize how difficult it is...

I think we're getting there!!! When I run with your latest code the record deletes then moves to the last record. If I try to delete the last record I get the same old errors but if I move to record 1 I can delete that just fine. So it seems all I need is to add a GoTo FirstRecord as the final...

Record 1 deletes fine. Then, if I try to delete record 2 a MsgBox says "Multiple-Step Operation Generated Errors. Check Each Status Value" I click OK to close this box then try to move to the next record and get "Run time error 2147217885 (800040e23) Row Handle Referred To A...

That worked like a charm, Thanks. But:-) If I try to delete two records in succsession I get a multi step error that refers me to this code: Private Sub datPrimaryRS_MoveComplete(ByVal adReason As ADODB.EventReasonEnum, ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, ByVal...

Hi, I have the following code to delete a record from my database, but I want a Message box with yes no options before the record is deleted. I keep coming up with run time errors because I'm putting something in the place. (Can you tell I'm a newbie yet?):-) Can someone help? Thanks MickJ...

Thanks for the reply. This problem occurs even if I copy and paste the Adodc control, doesn't seem to matter which connection I use it always appears dimmed.

I've put an Adodc control on my form (I have two others working perfectly) when I run the project the control appears dimmed and doesn't work. The other Adodc controls I have are using Provider=Microsoft.Jet.OLEDB.4.0 connected to a table and PROVIDER=MSDataShape;Data PROVIDER connected to an...

Hi, I'm new to VB too, the most helpful book I've found is Visual Basic for Dummies. I also cheat a lot:-) try www.infragistics.com and www.fpoint.com hope I'm not corrupting you! Good Luck. MickJ

Eureeka!! Works like a charm, but..... I need to hide one column and resize the other 3 at design time so that my beloved users can't mess it up. Can this be done? Thanks

Thank you both for responding. I'll give your code a whirl tonebone and let you know how I get on. Might take me a couple of days I'm a part timer. Thanks again MickJ

I think I'm doing something really dumb. I have an Access table (tblVehicles) where the ID field needs to correspond to the Counter field of tblRepairs. My DataGrid is showing all the records of tblRepairs and I only want it to show the records relevant to the current vehicle. When I move to the...

Thanks, I'll get one of 'em to work:-) Regards Mick

Thanks for the response. Do I put this on each txt box or is there a global way of doing it?

How do i get the Enter key to move from txt box to txt box on my form instead of using the tab key? It must be possible...right?

Thanks for the reply. The record is displyed, what I want the grid to do is show the relevant maintenance for the current record. In Access is was something like where RecordID=MantenanceID but I can't seem to figure it out in VB.

I've set up a grid which is supposed to show maintenance work performed on vehicles. The main part of the form is linked to an Access DB which displays the vehicles, the grid is showing maintenance work for all vehicles instead of just the current vehicle. What did I do/not do?? Thanks Mick

Go to www.infragistics.com and download a demo copy of UltraSuite it's on sale for $495.00 and is the best thing since sliced bread. I'm new to VB but have created an outlook interface with virtually no programming. The tool you want is either the OutlookBar or the DataExplorer. Check them both...

Same thing happened to me. Create a new Acess 2000 mdb. Import yoyur tables queries etc into it. Then rename it to the name of your original mdb... save the old one as something else just in case. This worked for me. Good luck

I am trying to Auto Fill Address, City, State And Zip fields on a VB form that reads an Access DB. Choosing a name from a combo or list box would automatically fill in the other fields. (that's my theory anyway). Any suggestions would be helpfull, writing the code for me would be better:-) Thanks.

I'm looking for a "Find" tool, hopefully similar to the one used in MS Access. I need to search a database to locate a particular record based on the contents of various fields, e.g. Last Name, Stock # etc. Thanks