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

Recent content by vbajock

  1. vbajock

    Bluetooth file transfer as an object

    Has anyone manipulated Bluetooth file transfer as a programmable object where you can feed it user name and file names etc so the user doesn't have to it manually?
  2. vbajock

    Hyper-V physical server unexpectedly created a snap shot for a VM

    Hi all, I am trying to figure out why a snap shot unexpectedly showed up on one of our production servers. This caused a big performance issue and we had to reboot the physical server to deal with it, as the VM was also stuck in the "backing up" mode. Anyone else ever encounter this? I can...
  3. vbajock

    COPY TABLE1 TO TABLE2 with index, property, ecc...

    http://www.tek-tips.com/viewthread.cfm?qid=540097
  4. vbajock

    MS Access Web Browser Control using Stream of HTNL

    Slight typo: sWidth=460 should have been sWidth="460
  5. vbajock

    MS Access Web Browser Control using Stream of HTNL

    yeah, that could be a problem. For your variables, Dim sWidth sWidth=460 strHTML = "<html>" & _ "<html>" & _ "<body>" & _ "<object classid='clsid:D27CDB6E-AE6D-11cf-96B8-444553540000'" & vbCr & _ " id='player1'" & vbCr & _ " name='player1'" & vbCr & _ " width='" & sWidth &...
  6. vbajock

    Create Hyperlink on Access Form to Specific Microsoft Word Location

    http://support.microsoft.com/kb/310520 You'd then assign sDocFile to the hyperlink appending #BookMarkName to your original hyperlink
  7. vbajock

    Automation Error Overlapped I/O operation is in progress

    I would think you would get that error because you are not closing or de-referencing an object somewhere, you get it in C++ if you have unhandled return value, I would think at the VBA level it would be poorly structured exits or not closing an object used in a loop.
  8. vbajock

    Delete all rows which have data from linked Excel workbook

    Sub clearExcelContent() Rows("2:65536").Select Selection.Clear Range("A2").Select End Sub
  9. vbajock

    Different colors in Access label report

    http://msdn.microsoft.com/en-us/library/gg508986(v=office.14).aspx
  10. vbajock

    Displaying pictures to Excel file output

    If it is a SQL Server database, read this: http://support.microsoft.com/kb/258038
  11. vbajock

    Closing IE and Outlook with a button

    There is a control available where you can imbed the IE browser into an Access form, I don't know if there is anything like that available for Outlook but you can code an actual email front end into an Access form pretty easy. Google away.
  12. vbajock

    Closing IE and Outlook with a button

    When you open a program using Shell, Access simply hands control over to that program and the user has control over the events in that program, such as ending it. Doing the same thing using Access would require you to end the process on the machine, something that is usually not recommended...
  13. vbajock

    Conditional Statements in app.config

    On a network that has both 32 and 64 bit machines, I am having to edit the app.config files to deal with this: <add key="ConnAccessDir" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files (x86)\SomeDir\SomeAccessDbDir\" /> which I have to manually change to this: <add...
  14. vbajock

    The new version of Access is a PIA. Where is the Save As option ?

    Repeat of Vista, on steroids.
  15. vbajock

    The new version of Access is a PIA. Where is the Save As option ?

    strongm, thanks that worked the best altho I hate this constant obscuring of the work area just to do something simple. Just too much "tablet think".
See more

Part and Inventory Search

Back
Top