Search results

Thank you! Dave, it is a report I am doing the printing from. I followed your directions and it is working even better than I dreamed! Thank you! I will do a search for that and see what I can come up with. Thank you, Doug

Howdy all, I am doing a database dealing with types of woods and other materials. I have a form that will print out the data for the different woods/materials in small boxes. What I would like to do is have more than one box per page, but have each box be a different wood/material. I have it...

Ok, I hope this makes some kind of sense. I would like to have a report that when selected will ask the user which one item they would like to see. example. My database is on different types of materials used in my work. I would like to be able to print out a material "card" every now and...

must be gremlins I went out to his store and took a look at it. It worked just fine for me. I didn't reopen it, or anything. I just tried entering in a new entry and it worked. I have no idea why, except that it is those pesky little computer demons. Thanks for taking a look at this, and if...

HELP, Database wont let any more entries into it Howdy all, I need some real help on this one. I redid a database for a friend of mine, and everything "seemed" to be just find, but now it won't let him input anymore entries into it. It got to 233 entries and now won't do anything else. What...

I think I got it Hot diggied I think I figured it out. In the query the items sold table was shown, but I didn't have anything refering to it in the query. I removed the table from showing and now everything seems to be working! I can't tell you how much this forum and its members have helped...

Just one more question and I have it! Hey all, I fixed all the problems listed above. HOT DAMN! I went and deleted the floating table, move the volunter field to the consignor information table (it just seemed to go there more) and got everything working. One last problem remains (its a...

Good New, and one more question HEY!!! I figured out most of the problems (who would have thought it) Just had to get rid of all the distractions, and sit down and start tearing it apart, and digging. figured out the selecting certain items from a field set with the YES/No data source, had to...

more questions Ok, In looking at the query what I would like to do is set it up so that it shows only those volunteers who have a Yes (checked check box) in the Items Sold table (this field is set to Yes/No for Data Type). how would I do this? I see how I can set the query up to use those...

Any idea how I can create a report that just shows: Those consignors who are volunteers (taken from table Items Sold, field Volunteer (Y/N). Consignor number, First name, Last Name (taken from table Consignor Information).

addition to previous message In digging into why this floating table is out there (volunteer table) They have a Query set that reads from this table and also the Items sold table, Question, If I have it set so that they have the check boxes on the items sold table saying if they are a...

Pat, sorry about the different threads, I have been trying to work on different problems with this database, and it seems as if they are all combined. The volunteer field is part of a table not by itself. It is located on a table called Items sold. What happens is that someone buys an item and...

working on it..thanks! one more question I was able to set it up the way your 1st said on the form that reads directly from the table with the volunteer field. Now I have a problem with my other from, it reads all of it's information from a table called Consignor Information. What I would...

I have a table that one field is set for either N or Y (i.e. No or Yes) to tell if the person listed is a volunteer or not. I have 2 forms I would like to put a check box on, where you could change this field in the table . 1 form is item sold entry form, the other is a form listing...

Need some more help For error 1: The table has 2 fields ( I did not name them, just trying to fix the problem) the fields are: Autonumber Volunteer the error I get says: there is no unique index for the referenced field of the primary table. Since auto number is set as the primary key, is...

Hi, I have a command button set to automatically print a report when clicked. What I was wondering is there anyway to make the command print out multipule copies of the same report? (i.e. you click the button and 3 copies of the report print out) Thanks for all the help! Doug

I have a table where I have the field date added. Is there anyway to have it automatically fill in the current date, when a new record is added? I see where you can set the input mask for a date, but now where you can make it automatic. Thanks! Doug

Hi, I am helping a friend reconfigure his database, and we would like to setup a way to delete records from the database once they are no longer needed. The database is currently setup with 3 tables (at least for this part). Table 1 Items Sold Contains fields Autonumber (primary key)...

sounds good, can you give me a bit more info?

I am helping out a friend with a database he has been using for years, and wants to make a couple of changes to it. 1. Right now he has a form that shows the people he has entered into it (#, First Name, Last Name) this is tied to a table with that same information, on another table is all the...