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!

Recent content by Newbie456

  1. Newbie456

    A read-only database?

    Hello, I have a Access database with a complete data set - nothing should be added or changed at this point. We want to include a copy of this database to clients which allows them to search data, query data, create reports, but not to change any of the data! How would one go about doing...
  2. Newbie456

    Change legend values in chart

    Here's a simpler answer to my own problem, in case anyone else is interested: Date: October 2nd, 2007 Blogger: Mary Ann Richardson Category: Microsoft Office, Access, Tips Tags: Microsoft Access, Insurance, Life Insurance, Mary Ann Richardson 1 comment(s) Email Save Print Digg This...
  3. Newbie456

    Change legend values in chart

    That give me the error "Circular reference caused by alias 'battering' in query definition's select list" Perhaps if I knew where this logic is headed.. don't I need to input somewhere what I would like it to say?
  4. Newbie456

    Change legend values in chart

    My Row Source is: SELECT [Battering],Sum([SumOfCount]) AS [SumOfSumOfCount] FROM [mano material types] GROUP BY [Battering]; Battering is the yes/no field (either battered or not).
  5. Newbie456

    Change legend values in chart

    I apologize if this has already been addressed - I need things spelled out a little more obviously. I'm a paleontologist, not a programmer! I posted this thread awhile ago, didn't understand the answer, and just got back to it... I have a pie chart based on a yes/no value. When I build the...
  6. Newbie456

    Can grow fields with line divider

    Yes, that's exactly what I did. Do a keyword search for old threads on vertical lines which can grow if you need more details. I found the answer on here somewhere. :-)
  7. Newbie456

    Can grow fields with line divider

    An easy fix! Worked great, thanks!
  8. Newbie456

    Can grow fields with line divider

    I have a report in which there are lines between the fields and a horizontal line between each record. The vertical lines work fine, but the horizontal line (which I drew with the line tool) doesn't move down when fields grow - meaning sometimes it's in the middle of a field. The weird part...
  9. Newbie456

    Change legend values in Chart

    I have a pie chart based on a yes/no field. The legend reads -1 and 0. How do I change this text to meaningful values? I'm sure this is a simple answer. Thanks!
  10. Newbie456

    Can I use Access for library-type system?

    I suppose I was trying to avoid the extra work of labelling every piece of field equipment - with shovels it is easy, but when it comes to things like buckets (100s can go out at a time)it can be unreasonable.
  11. Newbie456

    Can I use Access for library-type system?

    I would like to use Access to keep track of equipment as it is checked in and out of a lab. This would be similar to tracking books checked out in a library - in that I would like to display if equipment is "in" or "out" The equipment wouldn't have a specific name, so that is where the...
  12. Newbie456

    Autolookup on two combo boxes

    Yes, that one worked much better. Also had to set it to the first column (easy mistake). Thanks!
  13. Newbie456

    Autolookup on two combo boxes

    Good idea. I have this as my code, but it doesn't seem to do anything. What am I missing? Private Sub cboCName_AfterUpdate() cboSName = Forms!frmArchaeoCat!cboCName.Column(1) End Sub Private Sub cboSName_AfterUpdate() cboCName = Forms!frmArchaeoCat!cboSName.Column(1) End Sub
  14. Newbie456

    Autolookup on two combo boxes

    Sorry if this answer has been posted already - I haven't been able to find it. I have a table with Scientific Names and Common Names listed for a variety of animal species. Each is unique. I'd like to create two combo boxes on the form that behave as such: If Scientific Name is selected in...
  15. Newbie456

    Query doesn't show null values

    Yes, thank you for forcing me to figure out what that means. Simple solution. Thanks!
See more

Part and Inventory Search

Back
Top