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!

Search results for query: *

  • Users: obli
  • Order by date
  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

    I hav 10 forms and how can i add them into a

    Interested also.
  4. 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.
  5. obli

    tracking data entry date

    Try looking at the AuditTrail database sample at http://www.rogersaccesslibrary.com/
  6. 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(*)))...
  7. 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
  8. obli

    Command on form to print only the displayed record

    Another solution which I have used with success can be found at thread702-1099854
  9. 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
  10. 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.
  11. 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
  12. 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...
  13. 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
  14. obli

    Exporting Outlook info into Access

    I must be a slow typist.
  15. obli

    Exporting Outlook info into Access

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

    Linking Outlook (Global Address List) to Access

    Hi, In the Database Window select Tables in the Objects Column, click New then select Link Table, click OK, select Files of Type: Outlook. Then in the Link Exchang/Outlook Wizard hunt for the Global Address List and select it. It seems almost too easy to be true.
  17. obli

    Shortcut to web based Outlook

    Franklin: Thanks for the response but these users do not have Internet access. They can see a "crippled" version of the company homepage but not surf. I should have mentioned that. CharlieJax: Thanks. I will discuss your suggestion with the I.T. dept.
  18. obli

    Shortcut to web based Outlook

    For reasons too complicated to explain, our company IT department has devised a web based Outlook interface (for lack of a better word) wherein users are supposed to open Internet Explorer and type in "https://exchange-server/exchange/" to access their email over our intranet. Unfortunately...
  19. obli

    Viewing Access report

    This is a simple solution I came up with for distributing a current employee phone list. On the form's Save button I attached the following code and created shortcuts on the users' desktops which point to the snapshot. Whenever the personnel clerk updates the phone list and saves it, an...
  20. obli

    newb. need to have two list boxes on a form and controls

    I found this in a search and didn't have time to read it thoroughly and I have to leave work in just a minute but this might be what you're looking for. thread702-946254

Part and Inventory Search

Back
Top