I can't upload this ..to big...please help..

[f_disk]

The original file is about 7.5 megs I did the compact and it brought it
to about 7.2...I then zipped it and got it to around 2.2 megs...
The upload here is 363kb ? Theres no way I can get it that small.
Any suggestions ?

I posted it at savefile.com
it is 2.23 megs...sorry couldn't make it any smaller...

1. ) I am trying to get the clear button to clear the subform at the same time it clears the listbox, toner box and the paste box...currently it clears everything but the subform...
I would also like the subform to show up blank when the program is first run.

2.) How do I base a list box on the query that fills in the subform ?
The subform has the ability for the user to input data into the "input"
field then it does a calculation and gives the results in the "results" box.
I would like a report to be run and able to print when this is completed

The file is accessible at this link just click download.
http://www.savefile.com/files/94838

Wow...I know thats a lot to ask but, i'm stuck and can't figure it out...
New at this access stuff...

Thanks !

 

[Uncle Gizmo]

>>> I would also like the subform to show up blank when the program is first run <<<

Change the subform record source to ""

 

[f_disk]

don't think I can

The subform is the result of a query that is run at program start up
and during program use...

 

[Uncle Gizmo]

Set the window control the subform is in, visible property to false.

 

[f_disk]

any chance

any chance you could download the database and take
a look at it...It might save a ton of frustration..?

 

[f_disk]

got the clear button figured out...a little

My clear button will now clear all the areas I want it to...
The only problem with it now is the subform shows the
following when I clear it..even at start up.
toner, input, paste and results are suppose to show up.
The items below them are not after clearing...

toner input paste results
=Name? #Name? #Name? #Name?


toner is the name of the product (mt20 ) input is the weight you need to innput ( 20 ) paste is the name of a paste (x-2356) results is input *hidden percentage)

Here is the code I used to get the clear button to clear all the fields including the subform where the above now shows up...

Private Sub btnClear_Click()
Dim intIndex As Integer

' Clear all search items
Me.txtFirstName = ""
Me.txtLastName = ""
Me.frmsubClients.Form.RecordSource = ""

' De-select each item in Color List (multiselect list)
For intIndex = 0 To Me.lstFavColor.ListCount - 1
Me.lstFavColor.Selected(intIndex) = False
Next

End Sub