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 Chris Miller 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. miracleblake

    Form - Format Based on Option Box

    THe Expression Is: [Forms]![Customers]![txtCountry]=2 Worked, Thank you so very, very, very much !!!
  2. miracleblake

    Form - Format Based on Option Box

    Conditional formatting will not work in this case because I am trying to base the formatting off of the selection from another box.
  3. miracleblake

    Form - Format Based on Option Box

    I am attempting to format a text box (continuous) based on an option box. The problem that I keep running into is that there are 90 records. When running the form and making a selection for one record, the color changes for every record. I have the following Case statement. Select Case...
  4. miracleblake

    Access Report #Error

    Table name is ComputerInformation serialNumber - Number CLN - Number StockNumber - Number Item - Text Type - Text (row source is pc;notebook;blackberry;copier) Weight - Number DVD - Text (row source is reader;writer)
  5. miracleblake

    Access Report #Error

    Can you tell me what I would need to do to normalize my table?
  6. miracleblake

    Access Report #Error

    Thank you so much for your help. My control is called txtBlackberry. The control source is =sum(abs([type] = "Blackberry")) In order to add a field, you would have to go to computersInformation table go to design mode, in the type field text and add "PDA" as a rowsource.
  7. miracleblake

    Access Report #Error

    I have a frm called frmReports. frmReports has the following types of reports: blackberry, router, cell phone, pc, notebook, router, hub. When the user clicks blackberry, I have the following code on the on click: Private Sub cmdBlackberry_Click() 'Filter database for all Blackberries 'Provide...
  8. miracleblake

    Access Report #Error

    I tried it and it still did not work. The zero does show. However, when I created 1 blackberry type in the table, the number did not change (it remained at 0). Thank you again for your assistance.
  9. miracleblake

    Access Report #Error

    I still continue to have problems. Let me see if I can explain and maybe you can give me possibly a better way to go. I have a report that has as a footer. All, PC's, Notebooks, blackberry, cell phone, copier, router, (these are just summing the amount of records of a particular type)(the code...
  10. miracleblake

    Access Report #Error

    I continue to experience this problem and can't find a work around my solution. I have a text box "txtBlackberry". I run a report to print the total number of blackberries, everything works fine until there are no blackberries. I then encounter "#error" on my report. Any help would be greatly...

Part and Inventory Search

Back
Top