Recent content by UberZoot

Ladies and Gents, I have created my own menu (switchboard) form for my dbase. I had the "On Open" event set to a macro with the command Maximize listed. This maxed the form on initial opening of the base. However, as I open forms from this menu's selections, the menu form itself "sizes down"...

Ladies and Gents, I have a system that tracks individual's records in several areas, and each of these areas has a source table. When this person leaves the organization, I have append queries that archive his/her records into corresponding separate tables. How can I set up a Delete query to...

Ladies and Gents, I have a subform built form a query that calculates a person's score (a text box named SCORE) and this is linked to a mainform by SSN/Test Date. There is a button on this subform that opens another form to record details about the score. In this subform, if the value in SCORE...

Ladies and Gents, I have a query that calculates age by subtracting Date of Birth from Date(). The result appears in days and I divide this by 365.25 to calc years (accounting for leap year with the .25). This number needs to appear sans decimals, but it gets rounded up once the person hits...

Ladies and Gents, I have a Main Menu form that I use a Maximize macro "On Open" that I have keyed in my Start-Upo properties. When I select one of the command buttons from this form to open another form, the menu sizes down to a window mode. I want it to stay max at all times. Also- I have a...

Bob, How exactly can I convert numbers entered (EG 1.04/1.21) to numbers required (EG 1.00/1.25)? Thanks again. UZ

Ladies and Gents, Is there a way to format a table so that any number entered would appear rounded appropriately to .00, .25, .5, or .75? EG 1.19 = 1.25. Please help! UberZoot

Ladies and Gentlemen, I have been dodging the subject for months, but cannot get around it any longer. I have researched the subject in manuals, but it does not make sense to me. How can I build a form that utilizes combo, list, check, or text boxes to select the criteria for a report? For...

Thanks Golom. You're always hooking me up. JB

Golom, Is there any way to tag this under the Criteria section in the design view. I've attached a few other tbls under this qry and I'm still a beginner w/the SQL. Thanks. JB

Ladies and Gents, I have a Table that tracks 20-50 individuals' performance reports over time (quarterly). How can I have a query pull up the most recent evaluations (date) of each individual form this history? Thank you in advance, JB

Ladies and Gents, How can I have a music file on my computer automatically open with a switchboard or other form to give a fun atmosphere to some dry number crunching? Thanks for any and all help. JB "UberZoot

I am running a SQL query (thanks to Golom) that tracks scheduled vs. actual production in real time updates. I am appending this info to a table so that I can sort completed vs. pending orders with further append/delete queries. I have autonumber (indexed) assigning a designation to each...

I have a query that records data from a form that automatically posts the present date. For some reason, it stopped posting the new dates in chronological order as of 9/27/03 and started posting the new entries after 9/15/03. Can I fix this?

I guess the shortest way to say it would be this: How can I delete the "extra" records so that only the originals (unique by a two/three field combo) stay on the tables? Thanks again.