ethanhines
Last Activity: Oct 30 '07, 03:13 PM
Joined: Oct 15 '07
Location:
-
I don't know if you already downloaded the Access 2003 Database but I made some improvements to it (added more code) but I still have the same problems as before :( http://www.badongo.com/file/4944810 -
I'm still having the issues I have before,namly getting a proper subtotal and the size of check marks in combo listsLeave a comment:
-
Here is database in Access 2003 format
http://www.badongo.com/file/4929994...Leave a comment:
-
Never Mind...Figured it out Sorry........Leave a comment:
-
If I am right this code makes strvalue equal to the values that were selected in the multiselect list box right? Now how do I get that information into the right field in the right record say for example TOPPINGS...Leave a comment:
-
OK I'll re-install Office 2003 and re-post the database.Leave a comment:
-
Did you get a chance to look at those issues I have been having?
ChrisLeave a comment:
-
Leave a comment:
-
Sure here it is BTW SUB_SIZE doesn't mean Subroutine it stands for Submarine Sandwich :)
[CODE=VB]
Private Sub Frame_SUB_SIZE_ AfterUpdate()
Select Case Me![SIZE]
Case 1
Me![Order subform].Form![SIZE] = "6 inch"
Me![Order subform].Form![SUB TOTAL] = 5
Me![Order subform].Requery
Case 2
Me![Order subform].Form![SIZE] = "12 inch"
Me![Order...Leave a comment:
-
That Did it! However I should point out that I had to change:
[CODE=vb]Select Case Me!Frame_SUB_SI ZE
to
Select Case Me![SIZE][/CODE]
Don't ask me why...I wish I knew..Thanks Again!...Leave a comment:
-
nic
How do I add an activex control to access 2007?...Leave a comment:
-
Marry,
Now that I am explicitly referring to the controls on the sub form (that is to say the textbox) a strange thing is happening.....t he Buttons stay down but they only update the subform îf I press the other button. Here is the Code so far:
[CODE=vb]
Private Sub Frame_SUB_SIZE_ AfterUpdate()
Select Case Me![Order subform].Form![SIZE]
Case 1
Me![Order subform].Form![SIZE] = "6 inch"...Leave a comment:
-
That's just it Mary, there is no Afterupdate on a Toggle Button, but if I use the Code given to me, in the afterupdate of the frame, then the toggle button doesn't stay down.
To put it simply all I want to do is have a frame with toggle buttons that input data into a subform in datasheet format in real time. I donèt want to have to click on the sub form for it to update....Leave a comment:
-
AfterUpadte event is not available on the toggle button, only on the frame since I used the option control to assign numerical values values to the text values...does this make sense? Here....there database it's not large... http://www.badongo.com/file/4794919 .Leave a comment:
-
[ITEM],[SIZE], AND [SUBTOTAL] are all fields in a table (Preferably the subform, but I don't know how to reference a field in a subform, Plus I still have that pesky problem of haveing to click on the subform before it updates with the data from the main form. Sorry Guys I only wish you were here so I could explain better....can I upload the database to someone to take a look?...Leave a comment:
-
Also how do I address not having to click on the subform before in updates? If you'd like I can upload the access database on my website....Leave a comment:
-
Do you know of any tried part Active X controls off hand that allows for a bigger checkmark? Can you give me an idea where to look for them?
Thanks...Leave a comment:
-
No it's the afterupdate of Frame SUB SIZE. I used the Options group control to create toggle buttons each having a value associated with them and used the Case 1,2,3 to change the Numerical value to text, but the button doesn't stay down and I have to click on the subform before it will update ....hope this clears things up a bit....Leave a comment:
-
I think it would be easier to show you since we are dealing with a "visual" basic
Each Time I Click a Toggle Button I need my subform to update with the appropriate data, hope this help a bit...Leave a comment:
-
[CODE=vb]
Private Sub Frame_SUB_SIZE_ AfterUpdate()
Me![ITEM] = "SUB"
Select Case Me![SIZE]
Case 1
Me![SIZE] = "6 inch"
Me![SUB TOTAL] = 5
Case 2
Me![SIZE] = "12 inch"
Me![SUB TOTAL] = 7.5
Case Else
'fall through
End Select
End Sub[/CODE]Leave a comment:
No activity results to display
Leave a comment: