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: *

  • Users: Newbie456
  • Content: Threads
  • Order by date
  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

    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...
  3. 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...
  4. 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!
  5. 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...
  6. 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...
  7. Newbie456

    Query doesn't show null values

    I am trying to create a query that takes data from several tables. I have a series of combo boxes on my form that populate based on selections from other combo boxes. Some of these remain empty, if the field doesn't pertain to a previous selection. When I try and run the query, it doesn't...
  8. Newbie456

    Combo box data disappears

    I've searched and seen threads that refer to this problem, but I can't seem to figure out the reason for it. I have a series of combo boxes which populate based on the selection in the previous combo box. My problem is that if you select data, then move to another record, and go back to the...
  9. Newbie456

    Subform display based on Combo Box Selection

    I was wondering if anyone has written code for this before, and could direct me to that. I would like to display a subform on my main form, based on a selection in a combo box on the main form. I haven't taken the time to learn to write my own code yet, and thought I would see if it's already...
  10. Newbie456

    Autoformatting data on x-axis as a date - incorrectly!

    Ugh. I have a chart with the x-axis labels as intervals with the values "0-10, 10-20, 20-30, etc." The only problem is that Access is autoformatting the "10-20" field as "20 Oct" on my chart. How do I get it to stop doing this?? It should read 10-20, not 20 Oct, which doesn't make any...
  11. Newbie456

    Printing report based on query in switchboard- user friendly

    Hi - I have a report based on a query that prints box labels. Basically, it looks in the database and prints all items in each storage box. It's based on a query where I input the specific box number I want in the criteria. Simple. What I would like to do is build a function in my...
  12. Newbie456

    Pictures in form - not loading depending how file is opened

    Hi - I posted this earlier, but I still haven't figured out the problem. Please be specific. I am relatively new to access. I've designed a database to be used to keep track of fossils in a lab, and I have pictures embedded in the form to display for each record. It works perfectly, as long as...
  13. Newbie456

    Relative path/embedded pics trouble

    I have a database with the picture files referenced by relative path, for example, JPG/imagename.jpg It works fine, as long as I open the file from access. If I try and open the file by going to My Computer, then opening the database file from the drive, my pictures won't show (can't follow...
  14. Newbie456

    A report or a query? Help!

    I created the earlier thread "How lookup fields stem from one another" and this question is related to that. I have a database of fossils from a particular location. I have the tables tblFossilCat (my main table) tblFormations (geologic formation) tblMember (specific member of particular...
  15. Newbie456

    Creating lookup fields that stem from one another

    I am creating a database for fossil collections. I have a lot of info that needs to go with each fossil. What I want to do is have several lookup fields with values that depend on a selection in another lookup field, but I have no idea how to accomplish this. I'm also relatively new in...

Part and Inventory Search

Back
Top