Search results for query: *

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.

Ladies & Gents: I am running a query that calculates actual production quantity against a set order quantity. I am running append & delete queries to separate pending and completed orders into two tables. Does anyone know how to keep the append query from entering duplicate records into the...

I'd like to delete all information associated with the completed order. For now, I've conditionally formatted a form based onthe query to highlight these fields in green when the order is complete. Thanks again & again.

Thank you thank you thank you. That is the answer I needed. Is there any way that I can have any record that hits "Complete" delete automatically? Thanks again.

Golom, Thanks for the help. I am still a novice in this program, and was wondering where I would need to insert this code. Thanks again.

No problem Golom. Orders Due Table Date Product Quantity (on order placed) 9/11/03 Wheels 5000 9/12/03 Chairs 400 Production Table Date Product Quantity (produced) 9/11/03 Wheels 2500 9/13/03 Wheels 1500 9/13/03 Chairs 400 I have the query set...