Recent content by shiner

While I am thinking about it... is it possible to send mail to the results of a query? I would like to send out mail in bulk to personnel matching certain criteria.

Rob, I am getting errors in the macro - it states that it can not find the address in the TO field. The form containing the address field is open... so any tips?

Can the to field in a SendObject macro be a variable? I would like to place this address in a table of user preferences. This would allow for the address to change in the future without having to re-code the macro. Thanks!

Thanks guys! First, Fornation - what do you mean by split the front and back end? I assume you are speaking of the tables as the back end? How does one do that? I compress the db on close, and only have 3 graphics in the entire db. Second, Rich - when the form is loading, I see the word...

I have several reports in my db that take close to 30 seconds to open. At first I thought it was my machine, a PIII 450 - so I changed machines to an 850 (I know, still really old, but the best my office has) - still it takes just as long to load. However, it is only on the first time that the...

Ok, The KEEP TOGETHER property is what needed to change next. This fixed my problem. Thanks for tipping me off to groupings!

Dennis, Thanks for pointing me towards grouping. After I posted, I attempted to mess with a sub report, linked to the header data - but no luck there. After your suggestion, I grouped the info based on personnel_ID - and now I am closer. I am having trouble with where in the report to set the...

My report lists equipment that is checked out by individuals belonging to athletic teams. I am trying to print a report for an entire team. When I run the query, the results are correct, but the report shows them all on one page rather than each person having their own page. The individual's...

Hi, I have a link off of my personnel details page to issue that person equipment. The link opens another form, and the filter essentially grabs anything from my equipment issue table that is from the referenced personnel_id. Here is the VB script that access came up with for this button...

I will read up on continuous forms. Thanks!

thanks for the tip! After compacting it, we went from 50+mb to 7.5mb! That is much better, but still larger than I ever anticipated for a virtually empty db.

Hi, In my preferences table, coaches have the option for setting the primary gender for their team. In forms throughout the database, I would like the default value of gender boxes to use this preference setting. I have a link to ADD NEW EQUIPMENT ITEM and I want to form to open to a new...

I would like to make the subform continuous - complete with scroll bars. I am just unsure how to get the desired display. If I printed a report of all of the equipment items, it would list them down the page - that is what I am looking for here, but in the form--just unsure how to do it.

The more I think on this issue, the more I see that my envisioned layout for this is all wrong. If any of you who have experience with items like this have any suggestions for possible layouts, please let me know. I am not set on this format, it is just what came to me based on my old layout.

Hello, I am currently making a database to track what equipment athletes have checked out from their school. After getting some suggestions from fellow forum members, I have moved away from my static, flat db and am going for a relational database that will be dynamic. I wasted a lot of time...