Recent content by PercyPercy

Guilty as Well I've been following this thread closely -- at first out of interest in the topic. However, as the thread progressed, I was amazed at the changing tone of the responses. It has been suggested that novices should perform extensive searches prior to posting a question here. I agree...

Inserting OLE Objects I'm not an expert, but while you're waiting for the experts to reply, you could try this. This is how I've done it and it seems to work for me. First thing though -- make sure you have a place to keep the graphics files on your server so the data base can "fetch" them...

First of all, let me say that I was a graphic designer in a former life, then a forms designer, and now a data base designer. For data base work, I find my forms design career much more helpful than anything I learned as a graphic designer. The same design standards and logic used to create a...

Thanks! Thanks all of you -- I NEVER thought of that...

It sorts correctly, but the "new" row is at the end... I had it sorted this way -- and yes, it does bring the most recent dates to the top... but the "add" record still is at the bottom. I was hoping that this could be at the top of the datasheet if at all possible -- so if you have any...

I'm not sure it's a good idea Unless there's some kind of security reason, I would tend to avoid using textures in the background of forms or reports. For the same reasons that we avoid backgrounds on forms and reports in the older world of printed documents, the same ideas should be applied to...

I have a subform that I would like to have people use for data entry. It's in a data sheet view and sorts by date (the most current date at the top). This works fine -- when there are only a few entries. But as time goes on and the list grows, it means the users will have to scroll to the...

I'm such a novice, I'm not quite understanding what you mean by: SELECT [Product ID], Sum([Transaction Quantity]) FROM tablename GROUP BY [Product ID]; So do I use the SUM function -- so the "group by" appears on the "Total" row? I guess I just don't know what to type -- and where it should...

For some reason I can't write the proper query to get a simple total from a single table. Here is the basic table design: Transaction ID___Product ID___ Transaction Date____Transaction Quantity 1______________Product A____6/12/2006__________200 2______________Product B____6/12/2006__________500...