Recent content by Newbie456

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

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

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?

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

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

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

An easy fix! Worked great, thanks!

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

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

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

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

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

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