Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: zyphac
  • Content: Threads
  • Order by date
  1. zyphac

    Adding value based on a cmb Box

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

    cmb Box, subform, and adding

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

    date won't save

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

    Auto Number

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

    Adding text boxes

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

    Query and a listbox

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

    listbox help

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

    Tables

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

    List box help

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

Part and Inventory Search

Back
Top