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 strongm 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. henchcliffe

    Snapshot viewer files on Pocket PC

    nope, never did
  2. henchcliffe

    Windows CE on a PC?

    Additional: There is also "Windows Embedded" which is also referred to as "CE." That OS is used for point of sale registers, etc. I am not too familiar with that version and do not know if it is the same as "Pocket CE" but you could probably load that onto an old...
  3. henchcliffe

    Windows CE on a PC?

    I do not think that is possible. If all you want is to display CE/PocketPC on a "regular" PC you can use "Remote Display Control" which allows you to see and control your device from a desktop. It is a free download from...
  4. henchcliffe

    When Check Box is checked make text box required

    Thanks for the response. I inserted your code and when the check box is checked it moves to the text box but nothing prevents me from moving out of the field without entering anything. Here is the code i have so far: Private Sub LBL_OTHER_AfterUpdate() If LBL_OTHER Then Me.OTHER.SetFocus End...
  5. henchcliffe

    When Check Box is checked make text box required

    Hello. Is it possible to do the following: Say i have a check box and when a user checks it a text box on the same form becomes required. If the check box is NOT checked then entering data into the text box is optional. Any idea. THANKS!!
  6. henchcliffe

    OutputTo Action in a Macro

    hi, I am sending an access report to a LAN drive in snapshot format. Using the OutputTo action works great except I keep getting prompted with a message saying the file already exists, do I want to overwrite it. I always want to overwrite it when the macro is run so I am wondering if there...
  7. henchcliffe

    Snapshot viewer files on Pocket PC

    Hi, Does anyone know if it is possible to view files made with microsoft snapshot viewer (*.snp) on a pocket pc? Is there a special reader than can be used? Thanks
  8. henchcliffe

    Report grouped by name: how to email to each name in report?

    I should have mentioned, I want this to be automated so I don't have to filter from a form. In other words, the report is emailed using SendObject but the recipients will only get the portion of the report whose grouping matches their name. Hope that clarifies. THANKS! CMH
  9. henchcliffe

    Report grouped by name: how to email to each name in report?

    Hi, I have a report that is grouped by people's names; the report also has a text box with the people's name as the control source. Is it possible to send just the section of the report based on the name grouping or name text box via email? I know how to send the whole report via email but I...
  10. henchcliffe

    ACCESS 2k Linked Tables Acting Funky

    I am opening the actual tables. I have "fixed" the issue (sort of) by relinking all ODBC tables and making sure "save password" is unchecked. I am prompted for a password but I have not had any further issues. THANKS! CMH
  11. henchcliffe

    ACCESS 2k Linked Tables Acting Funky

    Hi, I have an access 2k database with several tables linked via ODBC. These tables are coming from 2 sources. My problem is that when I try to open these tables I get ramdom weird messages like "This action cannot be performed at this time" or "This table cannot be opened in...
  12. henchcliffe

    Query to retrieve yesterday's date and 4 weeks of that same day

    Excellent! I cant believe I didnt think of this before. I was trying to do something with "DateAdd" but this is much simplier. THANKS!!
  13. henchcliffe

    Query to retrieve yesterday's date and 4 weeks of that same day

    Hi, I am trying to write a query that will retrieve yesterday's date (date()-1) plus the past 4 weeks of that same day. So if today is wednesday the query will retrieve yesterday (tuesday) and the past 5 tuesdays. Any ideas? THANKS!
  14. henchcliffe

    Access Reports to PDF

    I will give that a try. THANKS!!
  15. henchcliffe

    Access Reports to PDF

    Hi, I am trying to automatically "print" reports to adobe distiller without any input. In distiller I have unchecked "Prompt for the PDF Filename" and "Ask to Replace existing PDF file." I also unchecked those boxes in the distiller printer document defaults. What...
  16. henchcliffe

    Access Query Question -- Do Not Know Where to Start

    With a little adjustments your solution worked fine. THANKS FOR YOUR PROMPT HELP!! CMH
  17. henchcliffe

    Access Query Question -- Do Not Know Where to Start

    Hi. I have a table that looks something like this: NAME Date question1 question2 question3 bob 1/1/1 1 0 1 bill 2/2/2 0 1 0 The numbers correspond to whether a question was answered correctly or not (1 is right 0...
  18. henchcliffe

    Advanced Options when Importing a table?

    I have two tables from the same Oracle datasource. Each table has a field in common but when I link them both in Access and look at the data type for the common field in each table the data types are different. In one table it is "text" and in the other it is "number." This...
  19. henchcliffe

    Zero values in a chart.

    Are you using excel? If so you can do a find and replace for all zero values. In the find window click the replace button and in the find field type in 0 (zero) and leave the replace field blank. If you want to keep the zeros in your datasource you can always copy the column first and then...
  20. henchcliffe

    Access 95 User and Group Permissions

    That worked great. THANKS!!

Part and Inventory Search

Back
Top