Search results for query: *

Need to set up an ASP that accepts bids, records ID of bidder and shows the latest bid on 4 identified parking places. Have no idea how to proceed.

I have a database ["schedtable"] that updates during the night. It is linked to two other databases ["passport" and "refuel"] that personnel access. (They do not directly access the linked database "schedtable.") Occasionally someone leaves "passport" or "refuel" open at the end of their...

I have a request to create a series of forms in Access that provide succeeding bits of information back to a main table. Each row of the main table describes a preventive maintenance activity from request to scheduling. The first form (InputForm) would include three lookup fields (dept, ext...

I have a request to create a series of forms in Access that provide succeeding bits of information back to a main table. Each row of the main table describes a preventive maintenance activity from request to scheduling. The first form (InputForm) would include three lookup fields (dept, ext...

PHV Thanks for your reply. I was using a combo box initially. What I needed was some way to send the other three fields to the "InputTable". I did find a fix through a question posed for inserting the results of four combo box selections into a table. I adapted it to my problem and "UPDATE...

I have a large table with nine consecutive access forms: Requestor, Scope Review and 7 different approval forms. The table must contain Requestor's name, dept, Ext and Pager. My requestors want automatic population of dept, ext and pager. There are 586 possible requestors so "dept", "ext" and...

I'm not sure that there is a code to force a form to fit each user's screen (here user's do not conform. If there is, I would very much appreciate learning it. Thanx, Imjay

I need to set up my form so that the Work Order and Work Request fields can be linked back to Passport (yucky database). In Passport these fields contain 8 digits. If the work order or work request is initiated from a standing preventive maintenance requirement, there are eight effective...

Thanks, folks. I will put your advice to work for me. I agree that the use of autonum as the index key is problematic; however, the only other appropriate field may or may not be populated well into the process. The logical field to combine the tables is the work order number (WO.) At the...

This was one one the responses to a question that I also need answered. I would make a control array and then check to see if any of the required fields are blank and if one is prompt the user with a message box saying that it is a required field and then set focus to the textbox. How do I...

I need to set a database timeout on a form if keys are idle for 10 minutes, and remove all fields in the current entry if it is incomplete, including the AUTONUM. Entry would be incomplete if SAVE button was not activated. I made it an autonum because it is the index key that connects the...

I have eight tables, all but two of which must be connected by the ID# (in this case called "TrackingNo") by "qryEmergent." On the Input Form, I have been asked to do two things with the entries that I have no idea how to accomplish. 1) Timeout if keys idle for 10 minutes and remove all fields...