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 TouchToneTommy 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: *

  • Users: RobWalls
  • Content: Threads
  • Order by date
  1. RobWalls

    Embedding OLE object in a table using VBA

    I am trying to embed an OLE object in one of the fields of a table using code in a module. I have done this from a form before, but don't know how to do it in this context. The only thing i've found is shown below (given that i have a field called Jpeg which takes OLE objects); Dim rstMain...
  2. RobWalls

    Type Mismatch in Recordset assignment

    I need to add data to a table using a function in a module. I have tried defining the table as a Recordset as follows: Dim rstMain As Recordset Set rstMain = CurrentDb.OpenRecordset("tblMain") With rstMain .AddNew !Field1 = "New Data" !Field2 =...
  3. RobWalls

    Sun to PC serial cable pinouts.

    Hi, I need to communicate between a Sun server and a PC via a serial cable. I think i've got the programming done for each end, but i've got to make a serial cable to join them. The Sun serial port has a 25-pin D-connector and the PC has a 9-pin D-connector (only about 8 of them need to be...
  4. RobWalls

    Progress bars for opening big forms - HOW?!

    I have a form with several pictures on it which takes a while to load up. How can i make a progress bar pop up so that the user doesn't think the database has crashed or something? Also, do they disappear automatically or do i need to tell it to? Thanks for your time, Rob.
  5. RobWalls

    Word -> Access: I'm still stuck!

    I posted a problem a couple of days ago which hasn't been resolved. Please can you help, because i can't continue with my project until it's solved. The problem is this: How can i insert a Word97 document into an Access97 bound OLE object and have it display the WHOLE document. At present, it...
  6. RobWalls

    Inserted Word97 Document only has one page!

    I have inserted some word97 documents to appear in a bound OLE box on a form. They all appear and behave themselves, except for the fact that only the first page of every document appears. How can i make the rest appear? Thankyou for your time, Rob.
  7. RobWalls

    Inserting Word documents as OLE objects.

    I've inserted a bunch of Word 97 documents as bound OLE objects, but when viewed in my database, only the first page comes up for each entry. I have the display property set to Clip (as opposed to Zoom or Stretch), but there is plenty of room for the whole document to fit in the frame without...
  8. RobWalls

    The Left Function - why doesn't it work?!

    I've been trying to use the Left function to return a single character from the start of a combo-box text bit, but it keeps coming up with an error saying "Unknown class module" or something similar. The syntax i'm using is: Left(string, n) My code looks like this: If...

Part and Inventory Search

Back
Top