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...
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...
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 =...
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
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.
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...
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...
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.
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.
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...
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?
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.
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...
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.
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.