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

    Photos in a Form

    I've looked but haven't found an answer to this particular question yet: I have a form which currently displays one linked photo based on a report number (Report number 3 finds 3.jpg) There is the potential, however, for more than one photo to be associated with a report. Is there anyway to...
  2. bill1856

    Display Record Selected from ListBox

    Thanks to both of you. TheAceMan1, your code works perfectly - I put it in the 'on double click' event of my list box.
  3. bill1856

    Display Record Selected from ListBox

    I have a form in which a user enters a name, address, dob, etc. into textboxes. Upon completion of one record, the user clicks a button which saves the info, populates a listbox on the same form with the just the name and dob, and then goes to a new record. What I want to know if there is...
  4. bill1856

    Can't See Embeded Image

    This works. The only change I made was: instead of Me.SN, I used Me!SN Thanks for the code enuf4u!!!
  5. bill1856

    Problem opening database

    I have an Access 2000 program that I can not open. Each time I try to open it, I get: "Could not save; curently locked by another user." The program is on one computer and is not shared. Any thoughts?
  6. bill1856

    Adding counts?

    I have a report which shows employee hiring status. In the header I have a =Count(*) textbox to count the total number of applicants. The body of the report (run from a query) is two textboxes: =Count([Status]) and a box to show the status. I have about 20 status categories. Half of them...
  7. bill1856

    Change textbox background color based on combobox selection

    Sorry to bother you again. Is there anyway to do something similar on a report?
  8. bill1856

    Change textbox background color based on combobox selection

    Perfect! Thank you!!!
  9. bill1856

    Change textbox background color based on combobox selection

    I have an employee tracking program in which I would like to have the background of the 'Name' textbox turn to yellow if the employee is under 18. I have a combobox where the user selects "18+" or "Under 18". I also need to (I think) requery on record change, so that when the user cycles...
  10. bill1856

    Sub Report Query Criteria

    Maybe I'm going about this the wrong way. I have the following four tables: Incident, Theft, MVC, and MVI. These tables hold data entered by users writing reports. I want to be able to run a summary of all reports for a date entered by a user with a report that looks like this: Incident...
  11. bill1856

    Sub Report Query Criteria

    I have a report that contains 4 sub-reports. The sub-reports are a based on four seperate queries that rely on user input for the criteria - [Enter Date]. When I open the report, I have to enter the date I'm searching for four times. Is there any way to just enter it once?
  12. bill1856

    Omit page from a report

    page breaks.
  13. bill1856

    Omit page from a report

    I have a report that is four pages long. One of the pages (page 3 of 4) is only for 'Additional Info'. 90% of the time there is no additional info. Is there any way to not print that page unless there is data in the 'additional info' text box on the page?
  14. bill1856

    "File format no longer supported"????

    I have a module that controls the 'mouse pointer to hand over an object' control. This is called during the 'On Mouse Move' event for a label on one of my forms. It has been working fine but all of a sudden, when I move the mouse over the label, I get a "File format no longer supported' error...
  15. bill1856

    Printing a report from a form

    Perfect! Thank you very much.
  16. bill1856

    Printing a report from a form

    I know how to print a report from a form but here's my question: My report runs on a query. The only criteria field prompts the used to enter an 'incident number'. Is there any way to automaticly pull the 'incident number' from the current open form to satisfy that criteria?
  17. bill1856

    Need more space in report Detail

    I figured it out. Had some large fields I shrunk down and used the Can Grow property. Sorry.
  18. bill1856

    Need more space in report Detail

    I'm building a report from a query with a lot of fields. I've put most of them into the deatil section of the report, but I've run out of room due to the 22" maximum detail height. Anyway around this? Can I add another detail to the same report?

Part and Inventory Search

Back
Top