Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by pkw25

  1. pkw25

    Lock down application

    I am developing an application in Ms Access 2003. Is it possible to lock down the table and code so that users don't have access to them ? At the moment if you press the shift key the user has access to everything. regards Paraic
  2. pkw25

    Updating a Database from a Text Box

    I am new to vb2005 but from what I've read DataAdapters and Datasets look to be the better option becuase of the Disconnected layer etc. I intend to use bigger queries but also text boxes and datagrids. I have searched all over but I can't see a way of populating a textbox and then updating a...
  3. pkw25

    Updating a Database from a Text Box

    Qik3Coder, Thanks alot,that worked. this one really baffled me for a long time. I still don't understand why it worked or why the dataadapter didn't. Here is the code. Public Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load...
  4. pkw25

    Updating a Database from a textbox

    Hello I am having a problem where i cant update a database from a text Box. It works if the textbox I am up updating from (textbox3) is not a bound control. But I need to bind it because I want the control to display the current data. Is there a way of displaying without binding ? Any help...
  5. pkw25

    Updating a Database from a Text Box

    Hello I am having a problem where i cant update a database from a text Box. It works if the textbox I am up updating from textbox3 is not a bound control. But I need to bind it because I want the control to display the current data. Is there a way of displaying without binding ? Any help would...
  6. pkw25

    Can't Create Form with Header and Detail Tables

    This loads the Form: Private Sub SITD_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Me.TblDETAILTableAdapter.Fill(Me.DBPDataSet.tblDETAIL) Me.TblHEADERTableAdapter.Fill(Me.DBPDataSet.tblHEADER) End Sub I tried using a form control in the...
  7. pkw25

    Can't Create Form with Header and Detail Tables

    Hello I am new to VB2005 and have used Access in the past. In Access I have created a form and subform connected to header and detail tables respectively whereby both are linked on a common field. If the header form navigator moves to a new field the detail form displays the relavent detail...
  8. pkw25

    RunTime Error 424

    Thanks for you reply I don't think it's the connection string since it works ok using the following code. "DBPSY CBT" is a valid ODBC Connection. Private Sub Command29_Click() Dim rs As Recordset Dim strSELECT As String Set rs = CreateObject("ADODB.Recordset") rs.Open...
  9. pkw25

    RunTime Error 424

    I get a Runtime Error 424 on this piece of code when using SQL to query the database. It fails at the rs.open line. Any Ideas? For some reason SQL queries work fine on another similar databse on the same machine. Private Sub Form_Load() On Error GoTo Err_Form_Load Dim rs As Recordset...
  10. pkw25

    Unable to login to database engine. (DATABASE=CASDB, EC=-2005)

    Hello I have the same problem on ArcserveV9 Went to the CA website and it says usage is as follows dbdefrag -a -L casdb;admin;secret DBNAME where DBNAME is the name of the Database, I have tried alot of different things but to no avail. What is Casdb? the only user name and password I have is...
  11. pkw25

    Printer Installation Error

    Hi All I'm trying to install an IP configured HP 4100 Printer on a Win 98 Machine But the it's crashing with the following error on install _INS5576 caused an invalid page fault in module KERNEL32.DLL at 0167:bff7a138. Registers: EAX=0e323930 CS=0167 EIP=bff7a138 EFLGS=00010202 EBX=83652384...
  12. pkw25

    How Do You make a CD Bootable

    Hi all I have a problem with a new Compaq N800v Laptop. I cant Login. I located a program which resets the admin password but I need to load it onto a Bootable CD as the floppy is not a bootable device in the Compaq. However I haven't succeeded in making the CD bootable yet. Can anyone help...
  13. pkw25

    SYSTEM DSN ODBC Connectivity

    Hi Folks I am trying to setup a system DSN ODBC connection on a machine but it's not allowing me create the connection. The error message is 'system error 126'. It also happens on user and file DSN's How do you reinstall the ODBC part of Windows 2000 pro? Any help would be appreciated on this...
  14. pkw25

    SAFE MODE CONSTANT

    Thanks I'll try SCANREG
  15. pkw25

    SAFE MODE CONSTANT

    Hi All One of our 98 machines hung installing Mcafee AV. I CTRL-ALT and Deleted the machine. And it won't boot up fully it keeps returning to safe mode. The Virus S/w is not there so I can't see anything to Un-Install or fix. Any Ideas, your help would be appreciated. Paraic Walsh

Part and Inventory Search

Back
Top