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 Mike Lewis 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. OBarry

    Clickable Fields in Database Results Page

    Hi All, I'm hoping someone will be able to help me with this. I am using Frontpage 2000 and an Access 97 database. What I've done so far is create a search page (asp) to query the database (by author, title, etc) and this works great. What I need to do now is on the results page I need to...
  2. OBarry

    Returning Read Receipts using Outlook 2000

    Thank-you for your response. I found the tracking options right where you said they would be, but the options to send/not send read receipts is grayed out. Is this taking the default settings of the Exchange Server I connect to, or is there a registry hack (NT 4 Workstation) that can be used...
  3. OBarry

    Returning Read Receipts using Outlook 2000

    Hi All! Does anyone know how to make Outlook 2000 ask you if you want to send a read receipt back to the sender like it does using Outlook Express 6? Thanks in advance for any help!
  4. OBarry

    Is There A Way To Turn Delete File Confirmation On?

    Using Office Professional 97 In either Word or Excel (not sure about Access and Powerpoint, but I think it would do the same thing) from the pulldown menu if you use File - Open and in the Open File window if you highlite a file and press the Delete key it deletes the file without asking if you...
  5. OBarry

    Access 97 Query Question

    Hi Joe, I really appreciate your help!! Scenario 2 is what we usually get, the teacher will always give us the two classes they want (always two different classes and never the same class) so we need to find the first day both classes are available at the two different times, and it doesn't...
  6. OBarry

    Access 97 Query Question

    Hi Joe, All 6 classes are available at 09:45am and 11:15am, every Tuesday through Friday. The two classes a teacher might ask for could be a combination of any of the ClassCodes. Example: Say a teacher asks for classes A and B, if class A is already booked for 09:45am but is available at...
  7. OBarry

    Access 97 Query Question

    I'm not sure if this is going to make sense but I'm going to ask anyway... I have a table with the following fields: Date, Time1, Time2, ClassCodeA, ClassCodeB, ClassCodeC, ClassCodeD, ClassCodeE, ClassCodeF The classes (each ClassCode field) can be scheduled at either 09:45am (Time1 field)...
  8. OBarry

    Forms - Day of Week

    Thanks for these suggestions but I couldn't get either one to work, I'm sure that they will work but I just didn't know how to make them work. Just FYI in case someone else has the need to do this... This is what I ended up using. Use two fields [DOW] and [Date], in the [Date] field put in an...
  9. OBarry

    Forms - Day of Week

    On a form using Access 97 is there a way to create an unbound field to show the day of the week based on the date entered in the date field on the same form? The function DatePart() does not work to show the days of the week and using the Long Date format (with the Control Panel's Regional...
  10. OBarry

    Report Viewing Size

    Paul, Thank you very much!! This is exactly what I needed.
  11. OBarry

    Report Viewing Size

    I have a user that wants to open her reports in a maximized report window with the viewing size of 75%. I can get the report window to maximize using On Open - Event Procedure - DoCmd.Maximize. Is it possible to tell it somewhere that you always want to view the reports 75% instead of 100%...
  12. OBarry

    Select Query Question - Date Range

    Thanks for your response, both work great but I ended up using... Between Date() And DateAdd("d",30,Date()) accidently ran across this in the Access help file when I was looking for help for something else.
  13. OBarry

    Select Query Question - Date Range

    Can anyone tell me what criteria I can use in a select query to specify the date range as Today's Date plus Thirty days? Thanks for anyone's help or advice in advance!
  14. OBarry

    Counting Records

    I am trying to create a query for a report that shows the total number of hours a volunteer has for specific classes, and between two given dates. The query uses a table named "Schedule" that contains the Volunteer's ID Number, the Class Code, and the Date of the classes. (There are...
  15. OBarry

    Problem with Reports and Forms

    Thanks for the help!! I will try these out.
  16. OBarry

    Problem with Reports and Forms

    I am having problems with my reports and forms that I created using Access 97. These reports and forms work fine on my PC at home that I created them on but when I try to use these reports and forms on my PC at work they don't. Wherever I use =Date I get #Name? instead of the date and wherever...

Part and Inventory Search

Back
Top