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 Rhinorhino 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. 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

    Brilliant! Thanks very much - that worked a treat. Now i am being slightly more ambitious, how can i embed a jpeg in one of the fields? I can do it successfully from a form, but how would i do it in this context? The only thing i've seen is as below (given that i have a field called Jpeg which...
  3. 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 =...
  4. RobWalls

    Sun to PC serial cable pinouts.

    I've found the answer now. It was in a book called "RS-232 Made Easy (2nd Edition)" by Martin D. Seyer. It contains pinouts for all sorts of connections between PCs, terminals, printers, modems etc. etc. Very useful book! Thanks for your help anyway, Rob
  5. RobWalls

    Sun to PC serial cable pinouts.

    I know which pins do what, but i need to know which pins on the Sun port connect to which pins on the PC. For example, i know that GND goes to GND, and TXD goes to RXD in each direction, but what about the others? What does DSR connect to etc? Thanks, Rob.
  6. RobWalls

    Sun to PC serial cable pinouts.

    I need to connect the following inputs/outputs etc (the pin numbers for the sun side are given on the left hand side): 7 Ground (GND) 2 Transmit Data (TXD) 3 Receive Data (RXD) 20 Data Terminal Ready (DTR) 5 Clear To Send (CTS) 6 Data Set Ready (DSR) 4 Request To Send (RTS) 8 Data...
  7. 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...
  8. RobWalls

    Progress bars for opening big forms - HOW?!

    Thanks, i'll try those two out tomorrow. The resolution thing sounds like it could be useful in other bits of my database - how do you change the resolution?! Sorry if i sound like a retard, but i don't work with pictures much. Thanks again, Rob.
  9. 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.
  10. 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...
  11. RobWalls

    Inserting Word documents as OLE objects.

    That would be nice, but i only have Access 97, and the power-up is for 2000. Surely there must be some way round it, even if it does take up a bit more space? Anyone?
  12. 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.
  13. 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...
  14. RobWalls

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

    Thankyou all! I'm not sure what the heck happened, but through some combination of checkboxes, rebooting, typing ".Value" and generally hitting the PC, it now seems to work! Rob.
  15. 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