Search results

vb6 connecting via ADO to a DNS reference to a MS Access 2003 database Private Sub cboCategory_Click() ' With pobjADOtable .MoveFirst .Find ("CategoryName=" & cboCategory.Text) If .EOF Then MsgText = "Error on Database Table" & vbCrLf _...

Without knowing your connection type etc, would something like the following work ado.field("fieldname") = value update filename Top of the head stuff hope it helps. ADO if positioned to the record you want to update doesn't require the rest of the fields to be acknowledged in anyway. Yes I...

Mike Oldfield, theme for the movie The Exorcist No one has mention Led Zep yet:eek: Put me down for Midnight Oil btw, and also Black Sabbath. Listen to most anything at the moment having a run on Everything But The Girl, they have some class numbers.

Q. Why did the chicken cross the playground ? A. To get to the other slide :o

But you get to have lots of meetings with yourself. Currently have about ten requests for friggin data extraction, there goes my net surfing :o If wanting to be a DBA, then you really will have to look at one of the big iron commercial databases, Oracle for example.

Surjer thanks for the reply. Am using an ADO connection to a defined Windows DNS source. Have checked the source a number of times and simply cannot see anything wrong with it. Stepping through I'm not getting any errors, the data simply doesn't want to show. Guess I should Msgbox some of the...

Have a project that basically uses some SQL to extract data from an Access 2003 db file and then present it in a vb6 from. Everything works fine except for a memo field which refuses to show anything? Anyone know of any gotchas with access memo fields? Am trying to load the memo data into a...

Yeap, didn't know about that hold the shift key down :p A whole bunch of stuff fires when you open the db otherwise.

Anyone know of a quick way to determine which version an individual PC is running? Have decided this is an issue with one of our apps that works on one PC but not on another.

Good points Bob :) Generally I only ever create ActiveX if I really really need something outside of the box, as surprisingly VB can do most things. Of course, as you say, this opens a Pandoras box in terms of dll hell etc. Did a combined project over the net with developers in three separate...

Oops forget this one. It's a linked db from another place on the shared drive. Frack!!!!! Really wish people would document around this company. This could be a long day as I attempt to get this working locally. :( Word to anyone just starting their I.T career, document everything ;)

Okay trying to get at an mdb that I have copied from the live network drive onto my own machine. Each time I try and look at a table in design or data mode it keeps trying to locate the table on the network drive. How do I tell access to look at the copy on local drive? Using version 2003, and...

Strange, I used to swear at Paradox. :p Quite liked Delphi, but Borland have bollocked it up in the last few releases imho. Anyways since I'm at work, back to trying to work out how come I can't go into design mode with Access 2003. Been given an existing app to work on, and it has one nasty...

There was a dbIII clone, but completely forget the name of it. Something to do with ships from memory name wise (Clipper or something). Had the advantage over dbIII that you could compile, of course you then had to .... take a seat kids this gets nasty .... link everything together :) Guess no...

Thanks guys exactly what I needed.

Edit: Sorry my bad, thanks Dennis that did the trick :)

Thanks for the answer Rabbie. Nope vanilla machine with Office 2003 installed sans Access. Installed Access post receiving the lappie via an upgrade version. Weirdly it now no longer issues the error message but things aren't firing in the various options. Still working out how to open the...

RSW this is kind of left field but what sort of connection are you using? My ISP switched us from ADSL to ADSL 2 a couple of months back and I was having similar issues. Turned out my old ADSL modem was doing something funky. Other than that really sounds like you may have picked up a virus...

Bob, not to step on any toes here, but you could also find a replacement activeX control to use instead of the default button. Okay this might get me into some trouble as I have no idea on posting links but anyways www.planetsourcecode.com has a number of activex controls freely available for...

Vaguely remember in vb5 you had something like "app.path" which gave you the location of the vb program, is there something similar available in MS Access to locate the mdb from the current position? Hope that makes some sort of sense.