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!

Register Log in
  • Congratulations wOOdy-Soft 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 NickBlake

  1. NickBlake

    Unable to commit transaction to access database

    I hope someone can help. I am writing a call logging database with a VB front end that saves the information entered into an access database. I am connecting to the access database via a data control. The program was working up until yesterday however for some reason it has stopped saving the...
  2. NickBlake

    Unable to Connect to Data Environment and commands

    Yes I have read the FAQ thanks. I did get my problem fixed I copied my project files over to a different network drive and tried to run it from there but the data environment wasn't picking up the commands. I had to delete the data environment and then clicked on add file to insert it back in to...
  3. NickBlake

    Unable to Connect to Data Environment and commands

    I have created a program with Data environments and commands in it on my pc. However when I open and run my program on any other pc on the network, other than my PC which I wrote it on, I lose the connection to my data environment and all the commands associated to it. Does anyone know the...
  4. NickBlake

    Losing my Data Environment and Commands

    Whenever I open and run my VB project on any other pc on the network other than the one I wrote the project on I lose the connection to my data environment and all the commands associated to it. Does anyone know the reason for this and how I can get around it. Thanks
  5. NickBlake

    How to access a

    Hi What I need to know is if there is a way I can access the information gathered by a data control in 1 form on a different form. The code I am using below lets me access the database using data2 from form1 so that I can find a particular record and display all the information in the fields...
  6. NickBlake

    Searching an access db connected by a data control, on the Primary Key

    Hi I am creating an application to log calls and require a user to be able to retrieve any call by entering the unique reference number. I have connected my application to an Access DB via a data control. To search for the reference number entered by a user I have used the code below that...
  7. NickBlake

    Connecting a textbox to a data field at run time using code

    Sorry for the confusion CCLINT. This is the code I am using maybe this will help Private Sub form_load() Data2.Refresh Data2.Recordset.AddNew Data3.Refresh temp = (CInt(txtBssRef)) ref = (temp + 1) lblBssRef.Caption = ref txtBssRef.Text = ref...
  8. NickBlake

    Connecting a textbox to a data field at run time using code

    Thanks for the reply that works but not for what I want to do. What I am doing is creating a fault logging database whereby a new unique reference number is created every time a fault is logged. I am doing this by connecting a data control to a table to obtain a number and then adding 1 to...
  9. NickBlake

    Connecting a textbox to a data field at run time using code

    Can anyone tell me how I can connect a textbox to a datafield using code whilst my program is running in VB6.
  10. NickBlake

    Move to new record in recordset on form load

    Can anyone tell me the code to create a new record in a recordset whilst loading a form. I have tried the code "Data2.Recordset.addnew" but it gives me a run time 91 error object variable or with block variable not set. Cheers Nick
See more

Part and Inventory Search

Back
Top