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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

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

    Error viewing snapshot file using OutputTo/ cdonts

    Hello I am tryung to send a report as an attachment. I ran into trouble only at the end, when I got an error after an attempt to view the attachment. Perhaps someone can see it: Private Sub Report_Activate() DoCmd.OutputTo acOutputReport, "DateChng", acFormatSNP...

Part and Inventory Search

Back
Top