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 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 JSD1976

  1. JSD1976

    Relate two Adodc links

    Thanks all. Great information.
  2. JSD1976

    Report to only show current record

    Hello I have a Data report made from the designer. I'm using a Data Environment connection, linked to an Access db. On click of a button on vb form, I'm showing this report, but it displays all records. I went to the 'Advanced' tab on the Command properties and unchecked the box 'All...
  3. JSD1976

    Relate two Adodc links

    Hello, I am trying to simulate a DLookup in Visual Basic. What I have is an Adodc link to a table with part numbers in my own Access db. I need to look up values associated with each part number from a tbl on our network. I created a second Adodc connection using ODBC to the tbl I needed on...
  4. JSD1976

    Combo Box doesn't show saved value

    Hello I am working with a VB6 form linked to MS Access db via Adodc connection. I have a combo box on the form. When I pick a value from the combo box, it writes the value to my Access db. However, if I exit the VB6 project, then load it up again and try to view the same record, the value I...
  5. JSD1976

    Searching for a Record

    Hello I am working with VB6 linked to an Access database via the Data button control. I can view the records and skip through them with the arrows on the Data control, so surely there must be an easy way to search the recordset. I have tried to use this: FindPN = InputBox("Enter Part...
  6. JSD1976

    Finding a Record

    Hello I am working with VB6, which I have linked to an Acces db. I used a Data button to link to 'tblmain' in the Acces db. On the VB form, I can view records from this table (next, previous), but I am trying to find a way to find a record on one form using an unbound text box and a command...
  7. JSD1976

    VB crashes - memory could not be 'read'

    Thanks a bunch. I haven't crashed for hours. Ahhhh.........
  8. JSD1976

    Find Record

    Hello I have been all over the net trying to find a way to find a record in VB6. I am using a Data button linked to an Acces db. I want to click a button and find a record that matches a value in a text box. I'm referencing ADO. I've tried hundreds of different ways but I keep getting...
  9. JSD1976

    VB crashes - memory could not be 'read'

    Hello I am not sure. How would I know? I am going to school to become a programmer but I'm afraid I don't know much yet. Most of my experience has been in VBA. I can post the code/ modules. Module1: Option Explicit Declare Function SetTimer Lib "user32" _ (ByVal hwnd As Long, _...
  10. JSD1976

    VB crashes - memory could not be 'read'

    Hello, I have recently encountered a problem with my VB6 application I'm creating. Every 5 minutes or so I get an error message: The instruction at "0x0fc000e" referenced memory at "0x00000023." The memory could not be 'read.' Then the program crashes. I have been modifying a free module...
  11. JSD1976

    Command Button to Open Input Box, Find Record

    Hello I habe been working with VB6 for about four years, and have recently started working with VB6. I have linked VB6 to an MS Access database through a DataDataEnvironment. connection. I have a key value 'part number' with 3 other associated fields on my form in VB6. I also have cheesy...
  12. JSD1976

    Link VB6 to MS Access Database

    Hello, I have been working with MS Acces for about four years now, and have just recently entered the world of VB6. I am trying to link VB6 to one of my Access databases. I first tried to do this by adding a DataEnvironment connection. This works, but I can't change the records or add data...
  13. JSD1976

    Reading Data in Access through COM Port from weigh scale

    Hello, I am trying to send and receive data between MS Access and a weigh scale. I am using a liitle code that calls a dll file to send ASCII characters to the scale. This works fine. However, I also am trying to receive data from the scale. Sending the number one and a carriage return triggers...
  14. JSD1976

    Using Access to Send/Receive Data Through a Com Port

    Hello, I have encountered a problem. I am trying to understand how to get MS Access to send and receive data (numbers) to a weight scale. The scale has been programmed to accept ASCII codes. The scale has also been programmed to send out a count of units after a 2 second delay. I've tried...

Part and Inventory Search

Back
Top