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 Rhinorhino 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. tigercrap

    Multiple Headers on Access Crosstab Qry or Report

    Hi, I am having a little trouble creating a qry or report with more than one header, but i'm not sure if it is possible. I have a query with the following fields: Location Position PStatus ("open" or "filled" entered) What i am trying to do is count the number of open and filled records by...
  2. tigercrap

    Non-blank data within a Sum If function for Excel

    Thanks All, I spent all day trying to figure out how to use SumIf with non-blank cells.
  3. tigercrap

    Multiple List Boxes as Selection Criteria for Report

    The Msgbox returned: (BaghdadMaint.DateIn Between #1/1/2004# AND #1/1/2004 23:59:59#). But when I use the Doc.OpenReport...BuildWhere(Me," AND ") I still get the rt error 3075, missing operator. Thanks! Tim in Iraq
  4. tigercrap

    Multiple List Boxes as Selection Criteria for Report

    How minor! Thank you very much! Now I get a rt error 3075 missing operator in query expression. I tried: DoCmd.OpenReport....BuildWhere(Me, " AND "). No luck. Not sure what I have wrong. I will be in a couple of hours as it is 2100 over here. Thanks again for you help! Tim in Iraq
  5. tigercrap

    Multiple List Boxes as Selection Criteria for Report

    Recopied the edited code from the FAQ and got rt error 2465 "MS Acces can't find the field 'StartDate_EndR' referred to in expression."
  6. tigercrap

    Multiple List Boxes as Selection Criteria for Report

    Thanks FancyPrairie! I started out with one list box and the date range. When the report opens, the list box filters perfect except the date range. I checked that the range boxes had _BeginR and _EndR and the BeginR box has the following tag: Where=BaghdadMaint.DateIn,Date; Any suggestions...
  7. tigercrap

    Multiple List Boxes as Selection Criteria for Report

    Hi, I have been stuck on this for a few days and can not seem to get any where. I have a Criteria Selection form with 4 list boxes and date range text boxes that are used to open up a report. It works great when using only one list box and the date range, but not more than one. I followed...
  8. tigercrap

    Copying and Pasting Cells

    Great...I'll try that. I was going to try also: Application.CopyObjectsWithCells = False I appreciate your help! Tim in Iraq
  9. tigercrap

    Copying and Pasting Cells

    Well the unprotected cells are for data entry, so I am trying to prevent someone from copying any cells over those unprotected data entry cells. Thanks for replying! Tim in Iraq
  10. tigercrap

    Remove all Hyperlinks in Word Doc

    One way is, go to Format tab and select Styles and Formatting. The Styles and Formatting window will show on the right side, under "Pick formatting to apply" select something for example HTML Variable. That will remove the hyperlinks, then scroll down and select Normal. That should work. Tim
  11. tigercrap

    Copying and Pasting Cells

    I have a protected workbook that i sent out to other personnel and all they have to do is data entry. How can i prevent someone from copying cells and pasting them over other cells on the same worksheet or workbook? Thanks Tim in Iraq
  12. tigercrap

    MS Powerpoint 2003

    I've ran into that problem before and i ended up re-installing PP and haven't had a problem after. You might want to try that!
  13. tigercrap

    Excel Validation, 2 drop lists??

    THANK YOU SO MUCH!!! That really helped...exactly what i was looking for! Thanks again!
  14. tigercrap

    Excel Validation, 2 drop lists??

    Hey Ken...Well i tried the VLookup that you had and it partly worked but i could not get it to list all the items i wanted in the second column. It would only show the value from the second column on that same row. Is the expression you suggested supposed to be in the cell or as a validation...
  15. tigercrap

    Excel Validation, 2 drop lists??

    Hello all, I'm not sure if this is possible either in code or formatting, but I need A1 to be a drop list, then A2 to be a drop list but A2 will list items dependant on what is selected is A1. ie. If "DS" is selected from the drop down in A1, then A2 will list DS1,DS2,DS3. If "BS" is...
  16. tigercrap

    Security Permissions and Subforms

    I finally got it! I found the WIF information i wrote down, but i lacked the users PID's etc. Thanks Again for your help!
  17. tigercrap

    Security Permissions and Subforms

    Thanks so much! That was it, just needed some data in there. I have another huge problem and very dumb of me. I allowed other people to access the file on my computer, well the Secured work group information file was deleted and now i am completely locked out. Any ideas. Thanks
  18. tigercrap

    Security Permissions and Subforms

    Thanks for the reply! The rectangle is the same colour as the background, as if the sub form is not there. The subforms will be used to input data. Thanks again for your help! Tim
  19. tigercrap

    Security Permissions and Subforms

    Hi All, I am currently assigning read only permissions to users in the database and when the users login the subforms are not shown. I set the applicable tables to Read and the subforms to Open/Run. When i change the permissions to Insert or Update the subforms start showing again. Any help...

Part and Inventory Search

Back
Top