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 derfloh 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. EastIndian

    Report - Group By Date

    Glalsop, By following your lead, I was able to come up with individual month of year queries showing both inspections using: Month(AnnualInsp) = 1 AND Year(AnnualInsp) = 2004 OR Month(PLInsp) = 1 AND Year(PLInsp) = 2004 Any ideas how to make this one yearly report? Thanks again!
  2. EastIndian

    Report - Group By Date

    I'm not quite sure that's what I need--I'm trying to run a report for the entire year so I can see each inspection necessary in each month of the year (for planning purposes). So far, by grouping in Reports, I have to run two reports, one that groups all Annual Inspections by Month and one that...
  3. EastIndian

    Report - Group By Date

    The report wizard will only let me group by one of the two date fields. By grouping on only one field, I can not get both AnnualInsp and PLInsp included in the same month and Year. Any idea how to make both columns be grouped together?
  4. EastIndian

    Report - Group By Date

    I have a table that has three columns: ProjName, AnnualInsp, PLInsp. AnnualInsp and PLInsp are dates--they are never the same date. Annual Insp is always 10 months prior to PLInsp. I would like to create a report that will tell me what Inspections are due each month. For example, If January...
  5. EastIndian

    Run query when clicking a link?

    The files are created from a custom tag to create mailing labels (Copyright 2000-2002 Brian Ghidinelli <brian @ vfive.com>)that I got off the Macromedia site. I have a form that allows users to request a product (it happens to be a map). They enter their name, mailing address etc. Each day...
  6. EastIndian

    Run query when clicking a link?

    Great suggestion, I can do that. But, the file I am opening is named by the date and time it was created. I would like to open only the most recent file (named by date and time) Would I use CFFILE to open the file in the new template? How do I write that if the file name can not be hard...
  7. EastIndian

    Run query when clicking a link?

    Any help is appreciated: This seems really simple, but I can't seem to get it (still a beginner...) I have a link that opens an rtf file (MS Word Mailing Labels/Custom tag). I would like to run a query that updates the background database with info that the file has been opened--I only want...
  8. EastIndian

    Update combo box on form

    Your assumptions were correct and your suggestion worked like a charm! Thank you so much! [smile2]
  9. EastIndian

    Update combo box on form

    I have one form containing a combo box (frmMain). The values in the combo box can be changed/added to from another form (frmContract). Currently, I have to close and reopen frmMain after I save changes in frmContract in order to make my new changes visible in the combo box on frmMain. I know...
  10. EastIndian

    Need Form Combo Box to Populate Table

    Sorry to answer this myself--I figured out that my form combo boxes were not bound to the table--I knew it had to be something simple. Thanks anyway!
  11. EastIndian

    Need Form Combo Box to Populate Table

    Beginner Question - I know I'm missing a key step, but not sure what it is... I've got two tables. The main table contains a foreign key field called PAYMENT. The second table contains a the primary key (autonumber) for each payment type, cash or check: pkPmtType Type 1 Cash 2...
  12. EastIndian

    Form Command Button

    Unable to search by keyword to see if this has been answered in the past, sorry. I have created a form where I would like to add a command button to preview a report based on some criteria entered in my form. For example, in the form, I chose a project &quot;A&quot; which has a primary key...
  13. EastIndian

    Random Time Range

    (Forgive, I am still a beginner..) I am wanting to determine if a user's IP has accessed my site in any random time between now and the past 5 minutes. (I know cookies are the way to go for tracking, but please bear with me). I am currenly collecting the IP along with time that site was...
  14. EastIndian

    Radio Validation Help Needed

    I am trying to ensure that a radio option is selected before the form is processed. It looks like, from the error message that I am getting, that my validation is not working. Included is the portion of my page containing the validation for the radio option. The error message I am receiving...
  15. EastIndian

    Date Format

    I have a field in an Access database called BidDate in which dates are entered in the database as a short date (example) 05/30/02. When I recall the field based on a very simple query, the format of the output looks like this 2002-05-30 00:00:00. Is there a way to modify the apperance of that...
  16. EastIndian

    Automatic Opening of form when Access Database is opened

    Can someone please tell me how to make a form open automatically upon opening the entire database project? Thank you!
  17. EastIndian

    Autonumber/Number Question

    I have inherited an Access database developed by someone else. The primary key in the main table is a number field. This field should be an autonumber field. How do I change the primary key to an autonumber field starting at number 99401? I realize that I can not simply change the field...
  18. EastIndian

    Select Only the most current record (SQL &amp; ColdFusion)

    This is a fine mess I've gotten myself in--any advice is most appreciated. I am creating a type of library to be accessed over the web (Cold Fusion). I have a book number, a book type (of which there are 2) and the options of either &quot;checked in&quot; or &quot;checked out&quot; for each...

Part and Inventory Search

Back
Top