Search results

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!

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

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

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

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

please disreguard the post - one of my tables was not populated and that was the cause for returning a null result.

Hi, Rather than have buttons to take me to different forms, I inserted 6 tabs to act as the navigation portion of my main menu. The problem that I am having is that when I view the form, it opens about 3 inches down the page rather than at the top of the form, where the tabs are. I initially...

What elements really add to the physical size of a mdb file? I am working on a pretty extensive database and the file is already up to 56 mb - and I only have 63 records in there! When I am done, I expect to have more queries than anything. I consider myself a knowledgeable newbie who has the...

Hi, I have a form that is serving as an advanced search engine for my table. Using combo boxes, I have placed value lists items like *, True, and False. A user would go to this advanced search page and select all of the criteria for their desired records. Leaving the form open - whose text...

Hi, I am trying to construct a universal equipment log for a school and their sports teams. I am having difficulty with a form handling data from two tables - essentially a #Name? error. One table holds the item descriptions for a particular team. Like: field: equipment_item_1 value: shirt...