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 gkittelson 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. 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".
  16. vbajock

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

    I program for all versions, I don't use the user interface much in what I do, on large corporate networks we really just want Access to program the user interface forms and reports for quick frontend apps where data and queries are all handled on SQL Server via Access VBA using ADO , when you...
  17. vbajock

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

    Great idea, add more work to do something simple, and hide the entire screen to do it. Seems to be what Windows 8 is all about. This entire environment is going to be the new "Vista", I predict a short life for Windows 8.
  18. vbajock

    New version of Access, where is the Save As option?

    vbajock (Programmer) 17 Apr 13 16:05 Access 2013, talk about screwing up a good thing, you just can't find anything. Same with Windows 8. I have a query open and I want to save it under another name so I don't wipe out my original query, and I can't find the stupid Save As button for the...
  19. vbajock

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

    Access 2013, talk about screwing up a good thing, you just can't find anything. Same with Windows 8. I have a query open and I want to save it under another name so I don't wipe out my original query, and I can't find the stupid Save As button for the life of me. Anyone know where it is?
  20. vbajock

    Runtime error 3129 invalid operation on delete query

    Use either technique (CurrentDb.Execute strSQL executes the query via DAO, currentproject.connection.execute strSQL executes via ADO) to execute 'action' queries, recordsets are only for SELECTS. I usually don't do INSERT queries using these methods, tho. Do INSERT by calling a saved query via...

Part and Inventory Search

Back
Top