Search results for query: *

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

How do I run this validation code only if the Subform entry is needed? -------------------- Private Sub DialUpRatePlan_Exit(Cancel As Integer) If IsNull(Me.DialUpRatePlan) Or Me.DialUpRatePlan = "" Then MsgBox "Please choose a Dial-Up Rate plan from the drop-down list", vbExclamation...

PHV, I'm sorry for not responding back on your post. I lost track of this one. I have moved forward a bit on this & my last post : http://www.tek-tips.com/viewthread.cfm?qid=1130591&page=1 gives the full details. Do you see what I'm trying to do? Use a POP-UP form with check-boxes allowing a...

Willir, Thanks so much for the detailed & insightful comments. Are you also in Telecom? I started out with alot of steam on this project & then came to a complete stand-still as I started laying out my forms. The limitations in my tables/relationships were becoming very evident to me and I can't...

How do I integrate my Form (picture #3) into my existing structure? I have tried to create a junction table but can never make it work as a subform on my 10 page tabbed form. (I created this "wizard-style" interface by setting the Tab button style to NONE.) 1) This is my original layout. 2)...