TV Tuner in ACCESS

[dinorbaccess]

Hello guys,

I know its a hell of a challange but I want to know from you if this is possible

I searched a lot in internet but I couldn't find information about how to get images in MS ACCESS (from any TV Tuner Car) , directly. I mean if video from a TV card can be seen directly from an Access Form.
Does VBA allow this happen, or is it any way how to implement this?



Suggestions are very appreciated and many many thanx !!

[weekend00]

try the activeX controls. e.g. windowsmediaplayer

[pkstormy]

I have a couple of different setups. Hopefully one will help but none involve MSAccess itself.

1. I have a computer with a dual video card (ones an HDMI, the other a vba). One goes to the monitor, the other the TV. I can then have both the monitor and tv showing the same screen.

2. On the newer type flatscreen tv's (I love my Samsung), there's several input jack types on the back, a couple being a usb slot for thumbdrives/harddrives. I can then connect a portable harddrive to one of the usbs which will then automatically recognize any playback type videos on the TV.

I believe there are some 3rd party TV type tuners though.

Otherwise, if you have a vga output on your laptop you could also connect that to any tv and simultaneously show the picture/MSAccess app on both the laptop and TV together. You just need the vga to vga cable.

[dinorbaccess]

I have a couple of different setups. Hopefully one will help but none involve MSAccess itself.

1. I have a computer with a dual video card (ones an HDMI, the other a vba). One goes to the monitor, the other the TV. I can then have both the monitor and tv showing the same screen.

2. On the newer type flatscreen tv's (I love my Samsung), there's several input jack types on the back, a couple being a usb slot for thumbdrives/harddrives. I can then connect a portable harddrive to one of the usbs which will then automatically recognize any playback type videos on the TV.

I believe there are some 3rd party TV type tuners though.

Otherwise, if you have a vga output on your laptop you could also connect that to any tv and simultaneously show the picture/MSAccess app on both the laptop and TV together. You just need the vga to vga cable.

I think you missunderstod me. What I want is to get the output from TV to my Computer input video (Seeing TV in my computer). And there are a lots of software out there that can let you do that (If you have a TV tuner card), but what I want to do is, to connect ms access directly to the TV so I can get snapshoots from TV to my Access Database.

The reason is not to get any TV images, but it is a medical project where I have to take the outpout of an ultrasound display and link it to my access database with other informations

[pkstormy]

I'm not sure about the MSAccess directly linked and taking snapshots but my guess would be to use the software (I used something that came with my device to connect the TV and show it within the computer monitor). I could then record movies to the computer or take snapshots. I then pasted these snapshots into a field in an MSAccess table.

I'm guessing if you wanted to do this same type of thing but directly into MSAccess, you could possibly use some code to do a copy/paste. Guess I don't fully understand though - sorry.

[dinorbaccess]

I'm not sure about the MSAccess directly linked and taking snapshots but my guess would be to use the software (I used something that came with my device to connect the TV and show it within the computer monitor). I could then record movies to the computer or take snapshots. I then pasted these snapshots into a field in an MSAccess table.

I'm guessing if you wanted to do this same type of thing but directly into MSAccess, you could possibly use some code to do a copy/paste. Guess I don't fully understand though - sorry.

The issue here is how to link Tv Tunner directly to MS Access ?
Can I use the VB.net Code in VBA ?

[pkstormy]

Just a guess but I'm thinking that there might be an activeX control within MSAccess that you could use or download. Finding the right one to use would be the challenge (there's a lot of them and I rarely use any of them due to the compatibility with different work computer configurations for users). The only activeX controls I use are the common dialog and calendar control. But perhaps one of the video type activeX controls might work. I believe you can configure one of these to point to a certain output (again, just a guess).

Otherwise I'd search for one on the web (sometimes using these controls include import/utilizing a module with API calls). Some are also designed for specific MSAccess versions.

"Can I Use the VB.net Code in VBA?"

I'm "guessing" that would depend on the code. I'm not that familiar with VB.net myself but I 'think' it uses the same type of vba code that MSAccess uses. From my experience with Visual Basic itself, the code was somewhat the same with some differences. I couldn't, for example, copy code from my VB application and paste it into MSAccess unless it was standard VBA code.

Hopefully someone else will respond also and can give you more information.

[dinorbaccess]

Just a guess but I'm thinking that there might be an activeX control within MSAccess that you could use or download. Finding the right one to use would be the challenge (there's a lot of them and I rarely use any of them due to the compatibility with different work computer configurations for users). The only activeX controls I use are the common dialog and calendar control. But perhaps one of the video type activeX controls might work. I believe you can configure one of these to point to a certain output (again, just a guess).

Otherwise I'd search for one on the web (sometimes using these controls include import/utilizing a module with API calls). Some are also designed for specific MSAccess versions.

"Can I Use the VB.net Code in VBA?"

I'm "guessing" that would depend on the code. I'm not that familiar with VB.net myself but I 'think' it uses the same type of vba code that MSAccess uses. From my experience with Visual Basic itself, the code was somewhat the same with some differences. I couldn't, for example, copy code from my VB application and paste it into MSAccess unless it was standard VBA code.

Hopefully someone else will respond also and can give you more information.

Im very thankfull for your response man. Very thanks from me.

Im waiting for another sugesstions. Meantime I trying if I can modify my VB.net code in VBA code. At first seems its not working, but Im continuing to modify.

Please more response.....