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. Brlee1crv

    Creating Quarterly reports

    Greetings, I have a report that counts and displays records using a bar graph by month. Is it possible to display a bar graph by quarter (1Q, 2Q, 3Q, 4Q)? THanks
  2. Brlee1crv

    Prior Year Ranking Report

    Greetings, I have a report that shows where a person is ranked in terms of number of jobs done for 2005. I'm trying to figure out a way to display next to this year's rankings the ranking in the prior year. How can I go about doing this? Thanks.
  3. Brlee1crv

    Checkbox on form only on specific records

    Greetings, How can I have a checkbox display on a form only when a specific record comes up. For instance if a user goes through records on a form and any John Smith record is displayed a checkbox will appear.
  4. Brlee1crv

    Access DB acting strange!!!

    I seem to have found the culprit. I can export every object in the database except for a table. This table happens to be the one that stores all the important data too. I also tried importing it into a new database but it just hangs there on the last bar. I ran a performance check on it and...
  5. Brlee1crv

    Access DB acting strange!!!

    Thanks for the tips everyone. I'll try your suggestion out AceMan1 and post the results.
  6. Brlee1crv

    Access DB acting strange!!!

    Greetings, I have a database that has been working fine up until the past few days. Now periodically I will get a message "This action will reset the current code in break mode", "Do you want to stop the running code?" If I click yes the same message keeps popping up, if I hit no I return to...
  7. Brlee1crv

    Help with bootup of Airport Express Assistant. Newbie!!

    I'm new to Macs and can't figure out this problem I am having. I recently installed Airport Express and that went fine. But everytime my powerbook boots up now the Airport Express Assistant opens automatically. How can I disable this? Thanks.
  8. Brlee1crv

    Problem with timestamp query

    Thanks Blorf...whoops I realized I typed the wrong thing. I am using Now() and not Date(). I tried using date() but everytime I used it on the form Access would enter the date that the record was created and not when Completed is selected in the combobox.
  9. Brlee1crv

    Problem with timestamp query

    That's what I'm afraid of...is there a way of timestamping a field with just the date only?
  10. Brlee1crv

    Problem with timestamp query

    Greetings, I have a field on a form (ReviewStamp) that is timestamped Date() if Completed is selected in a combo box. However when I try to query for records using this field in the table, I get no results. I've tried creating a query using Date() for the criteria under the ReviewStamp field...
  11. Brlee1crv

    Querying for records with a checkbox

    AceMan1, I am trying to create a query for dates now but I can't get results. For criteria I am used Date() under the ReviewStamp field but nothing comes up when I run it. I also tried entering a specific date such as 10/20/2004 but I don't get results either. I would like for someone to...
  12. Brlee1crv

    Querying for records with a checkbox

    Yay!! That was it. Thanks for you help. You da man.
  13. Brlee1crv

    Querying for records with a checkbox

    Thanks. I tried that but nothing happens after I select Completed.
  14. Brlee1crv

    Querying for records with a checkbox

    Thanks for all your help AceMan!!! If I want to use a combobox to timestamp the textbox field how can I go about doing this? For instance I have a combobox that has a status of Completed and Assigned. If Completed is selected the textbox will be timestamped. Thanks again for your assistance.
  15. Brlee1crv

    Sorting Access Table

    Thank you both for your replies. Unfortunately I inherited the database with this table so I'm trying to find a way to get out of this bind. I'm about 4000 records deep and all the records are in this format. The reason I would like the tables sorted is because when I run a query the results...
  16. Brlee1crv

    Sorting Access Table

    Greetings, I have a table that have entries labeled alphabetically and numerically (ie: AP04001, AP04002, AP04003). The "AP" will always stay the same, "04" is for the current year, and the last three numbers correspond to the entry number. I am having a problem when it comes to anything over...
  17. Brlee1crv

    Querying for records with a checkbox

    Thanks AceMan1!! I added the field ReviewStamp to the recordsource table and added the field to the form. I added the code in the AfterUpdate event (substituting names). However when I try the form out by clicking on the checkbox nothing appears in the ReviewStamp field. Help!!
  18. Brlee1crv

    Querying for records with a checkbox

    Greetings, I have a job form that contains a checkbox. The checkbox is for whether or not a particular job has been reviewed. Is it possible to add a textbox next the checkbox to show when the record was reviewed (timestamp)? If so how do I go about doing this? Basically I would like to be...
  19. Brlee1crv

    Printing the current record in a form

    Greetings, I have a form which displays data from a job table. If I try to print the current record I am looking at it prints all records. How can I prevent this and how can I print just the current form? Thanks.
  20. Brlee1crv

    Need help creating "Top 10" report/chart

    Thanks for the reply. I have two tables (tblClients and tblJobs). tblClients contain client info such as CliName, CliAddress, etc. tblJobs has JobNo and DueDate. The query I have for the report counts the JobNo using DueDate as a parameter. Criteria for the DueDate is: >=01/01/04 and...

Part and Inventory Search

Back
Top