Search results for query: *

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

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

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

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!

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

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

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

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

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

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

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

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

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

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

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