Recent content by clearwave

philhege, thanks for the post.. To view my images and maybe a clearer explanation of what I need.. Please see my post: http://forums.adobe.com/message/5819995#5819995

For now I have the form laid out using a table like this: <p>Choose Week <select name="Choose Week" id="ChooseWeek"> </select> </p> <table> <thead> <tr> <th>Payroll Item</th> <th>Mon<br> 11/04</th> <th>Tue<br>...

I currently have a ColdFusion form & need to add a "Week Selector" drop-down above my table so that: - when the week is chosen from the drop-down, (how do I generate these drop-down values?) - the correct dates are added to the date fields in the form.. (how do I populate the text boxes?) - Once...

Pampers, I have posted my updated database using your suggestions on both the Receipts & Sales tables & forms. I took all of my Categories from Receipts & Sales & added them to the corresponding tblReceipts & tblSales. I then fixed my frmROC Tab4 to reflect all of the Categories as you had...

Pampers, Thanks for a workable solution. I originally thought of doing it that way, but I kept hearing the voice that says, "break up the data into separate tables". So I broke it down & made the tblReceiptCatgs. One question: How would you deal with categories that are discontinued? Add a...

Thanks again guys, ... Pampers, I don't see any changes to the file or code? Sorry if I missed your changes. cw

VicRauch & Pampers, Thanks for the response. Disregard the way my Receipts & Sales subforms display as continous forms. (I was trying to list all items.) And you are right to say that the DATA ENTRY is always based on a DAY/DATE. But I'm still lost on how to: 1) List all items down the subform...

They are a chain of gas stations & retail stores & the owners have no plans to computerize the sites. Each day the manager prints off a cash register tape, transfers the values to a closing paper sheet & sends this End-of-Day sheet to the main office. The secretary inputs the data into this...

Pampers, I finally got back to this & changed the code to this: --------------------------------------- Private Sub Form_Open(Cancel As Integer) Dim sql As String sql = "INSERT INTO tblReceiptDetails (rec_catg_id, rec_total) " & _ "VALUES (1,0);" CurrentDb.Execute (sql) sql = "INSERT INTO...

Pampers, In regards to "you may run into problems if more records in the subform are entered..." I plan to give them a button on the Form that says "Add New Category?" which when clicked will open up the frmCategories, allow them to Add or Check one as discontinued & then close the...

Thanks again, I'll start looking into this later this evening. I have attached a copy of my database thus far for reference. [download http://cerberus.clearwave.com/jerry/ROC_beta.zip] Thanks, cw

Pampers, Thanks for the response. & disregard my "programmer" status. How do I change that thing to "Technical User"? anyway... I have never used the Insert command to auto-populate my subforms. I guess it's about time to learn a new technique. I appreciate your patience as I would really...

Thanks for the input guys, While I'm not fond of this layout either, this is what the client wants. They use to have an old DOS application that has all of the Receipt categories displayed down the right column, & the user inputs the Total Dollars & hits Enter or Tab untill all have been...

I have a Continuous Subform on my Main Tabbed form.(See image below) [image http://cerberus.clearwave.com/jerry/frmRoc.gif] [image http://cerberus.clearwave.com/jerry/frmRoc2.gif] When the user clicks this Tab, I need the subform to open and automatically display a row for each of the values in...

Ace, Moving the code from the EXIT to the BeforeUpdate does allow the user to pass by the other subforms & their associated fields, but.. 1) Now, It doesn't stop & prompt the User at each field entry. 2) When I had the code in the EXIT event & Focus set to the first field, Access would require...