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!

  • Congratulations wOOdy-Soft 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 obli

  1. obli

    disable mousewheel

    Linq is probably on the right trail. I've used Stephan's code several times and continue to forget the modMouseHook. Here is where blRet is used straight from Stephan's code: Private Sub Form_Load() ' Turn the MouseWheel Off Dim blRet As Boolean blRet = MouseWheelOFF End Sub
  2. obli

    How to bring Content of word tables into access tables

    I have not tried it but a quick search came up with this: http://support.microsoft.com/kb/243275
  3. obli

    Form will not open on one client PC

    Without much information to go on, try uninstalling and re-installing the default printer and make certain it is selected as default before attempting to open the db. Oddly this has been the fix for several somewhat similar problems with access db's here at work.
  4. obli

    tracking data entry date

    Try looking at the AuditTrail database sample at http://www.rogersaccesslibrary.com/
  5. obli

    counter on form

    If you don't like the built in navigation tool with record indicator, you can make your own navigation buttons then put an unbound text box next to them using the following as the Control Source: =IIf([CurrentRecord]>Count(*),"New Record",("Record " & [CurrentRecord] & " of " & Count(*)))...
  6. obli

    Command on form to print only the displayed record

    or this... Private Sub Command26_Click() Dim strCriteria As String strCriteria = "[mytable]![ID]=[Forms]![myform]![ID]" DoCmd.OpenReport "myreport", acPreview, , strCriteria DoCmd.PrintOut acPages, 1, 1, , 1 End Sub
  7. obli

    Command on form to print only the displayed record

    Another solution which I have used with success can be found at thread702-1099854
  8. obli

    Any thoughts or idea's as to why?

    There is no mention of Microsoft Access supporting .png at the following site: http://www.libpng.org/pub/png/pngapof.html
  9. obli

    Email Screen Shot of Form

    Also Check out MS Knowledgebase article 293508 to find out how to deal with checkboxes on an RTF document.
  10. obli

    Email Screen Shot of Form

    I've not much time to explain but... check out sendobject - here's a snippit of code from one onclick event I use to do what you are talking about. DoCmd.SendObject acReport, stDocName, acFormatRTF, "recipient@emailaddress", , , stDocName & " " & stDate, "Here is your list for today.", False
  11. obli

    Buttons for date ranges

    I have used a date range input form for a couple years now with pre-set range buttons. I wish I could remember where I got the code so I could give proper credit. 'Year to date button Private Sub cmdCalYearToDate_Click() txtFrom = "1/1/" & DatePart("yyyy", DATE) txtTo = DATE End Sub...
  12. obli

    How to audit changes to Access Table Data?

    I'm not shilling for this author but from what I've seen of his example here, I am impressed. Maybe it can show you how to do what you need done. http://www.rogersaccesslibrary.com/download3.asp?SampleName=AuditTrail.mdb
  13. obli

    Exporting Outlook info into Access

    I must be a slow typist.
  14. obli

    Exporting Outlook info into Access

    With Outlook open, on the menu click File then select Import and Export and just follow the wizard.

Part and Inventory Search

Back
Top