I have a combo box with 3 values(rock, sand, Dirt). I have a tons box in which to input tonage. At the bottom of the form I have the totals boxes(sand, rock, dirt). I forgot to mention the combo box is in a sub form in datasheet view. I can get it to add every thing in the tons text box, but I...
I have a form with 2 subforms. The first sub form is datasheet view, and one of my boxes is a cmb box. It selects type of rock: sand, rock, asphalt. Then my next subform is the totals. sand rock asphalt. I can't get them to add up say the total sand, aspfalt, rock. The subform in datasheet views...
I have a text box that is set for the current date. when I type data in my sub form it will not post the date in my table, all the other data I type in is saved. It may do it once, but that is all. any Ideas on this
zypha
Is there a way to set an auto number to say this expression? ex:
year starting with t 2003 = T, 2004 = U etc. (by the time it gets to z my dad will be retired)
month Jan = F, Feb = G, Mar = H, Apr = J, May = K Jun = M
July = N, Aug = Q, Sept = U, Oct = V, Nov = X, Dec = Z
then -100 this...
I have several boxes in which I will be placing a value. Then the total text box. EX:
=([amnt]+[amnt1]+[amnt2]+[amnt3]+[amnt4]+[amnt5]+[amnt6])
Here is the problem: I will not always be entering values in all of them. This only work if I enter a value in all of the boxes. How can I rework this...
Hello all. I have a listbox and a query that lists the last 18 days. What I need it to do is type in a date range for the query then populate my listbox with that data. I have tried several ways, but no luck. Could any one enlighten me on this subject. Many thanks!
zypha
ok here is the code: then I tell the problem
Private Sub contractdata_AfterUpdate()
Dim lst As ListBox
Dim intI As Integer, intJ As Integer
Set lst = Me!contractdata
' Print value of each column for each row.
For intI = 0 To lst.ListCount - 1
For intJ = 0 To...
Hello again, here is a question dealing with tables. I have a form that has A buyer annd a seller text boxes, along with their address. (and few other ones) Here what trying to do I need the buyer and seller saved in my tblmain, i don't want the address there, but I need for them to come back...
How are we all today, Good I hope. Here is what I am working with, ,I have a listbox, that uses a query to get said data, it is a multi select listbox. when I select the data it puts them in a textbox below. So as I can use it in a report.There ar 4 column is the list box, here is the problem, I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.