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!

Register Log in
  • Congratulations Chriss Miller 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: jaanisf
  • Order by date
  1. jaanisf

    Text box default value

    Is there a way to let a text box remember last entered value? I want the last entered value to be a default value. When I enter new value, other that default, the new value becomes a default value.
  2. jaanisf

    Default date value from a Calendar

    It seems I found it. As the Caloendar allways stays on the last chosen date, all I should do is to put [Calendar].[Value] in default value field in textt box properties. Now it works.
  3. jaanisf

    Default date value from a Calendar

    It shows the right value in properties and still there's a #Name? in text box. Maybe there is another way out? For example, can I take the last records date as a default value?
  4. jaanisf

    Default date value from a Calendar

    Then this should work: Private Sub Calendar_Click() dat = Calendar.Value Me.dat.DefaultValue = "#" & Calendar.Value & "#" Combo18.SetFocus Calendar.Visible = False End Sub But it works for the current record only. When I it jumps to next new record, it shows #Name? again.
  5. jaanisf

    Default date value from a Calendar

    I need to add many records with the same date in my form. So I put a button next to my date text box "dat", that wakes up a calendar. That looks like this: Calendar.Visible = True Calendar.SetFocus Then I put a following code: Private Sub Calendar_Click() Me!dat.DefaultValue = "#" &...
  6. jaanisf

    List Boxes Value is Null

    Thanks, this Val(listbox1.itemdata(0))+...+Val(listbox3.itemdata(0)) helped. :)
  7. jaanisf

    List Boxes Value is Null

    Erm.. I just read your second reply :) You see, I have many queries. I allways run all these queries and then write down results in excell to calculate. Now, I would like to make a form, which would calculate it fast with a single click :) It all must look like this: Listboxlabel1: 100$...
  8. jaanisf

    List Boxes Value is Null

    Actually, I made it all with listboxes. But, there I stopped, because, now I need a textbox, which sums all the values in listboxes. But the value in textbox looks like this 1178.582768.355837.45, resp, it manages listboxes values as text, not as curency. Record Source for this textbox looks...
  9. jaanisf

    List Boxes Value is Null

    Yes, the query returns a single value. At first I tried text boxes, bet they did't return any value from a query. How should I do this with text box? Example: text boxes name = tbox1 queries name = query1 queries SQL view is like this: SELECT Sum([quantity]*[price]*[multiplier]) AS Supplied...
  10. jaanisf

    List Boxes Value is Null

    I have a textbox tb_value and a listbox lb_value. Listbox is bound to a query, it shows the query result. Listbox has only one row, resp. one value. Now, when I make another textbox tb_another, I write in its Control Source: =[tb_value]. Everything's ok, the value of tb_value is shown also in...
  11. jaanisf

    Populate Forms textbox fields from query

    Well, I have another problem with this. After I made several listboxes that are bound to queries, I made one, that must sum the values of all listboxes. But it doesn't work. When I write in lb_sumall Control Source = [tb_date], it works correctly. But when I write there, form example, =[lb_sum]...
  12. jaanisf

    Populate Forms textbox fields from query

    I managed with the requery. No need to answer, thanks :)
  13. jaanisf

    Populate Forms textbox fields from query

    Hm.. another problem. It works nice with a default date set in a textbox tb_date. But when I change the date, listbox lb_sum stays the same. How can I refresh it?
  14. jaanisf

    Populate Forms textbox fields from query

    Yes, that is what I wanted. Well, I tried this with listboxes and it works nice, but not with textboxes. I must hold on to listboxes then, it seems.. Thanks for help :)
  15. jaanisf

    Populate Forms textbox fields from query

    It's sintax error. And when I put the statement like this: =(SELECT Sum([daudz]*[cena]*[reizinatajs]) AS Summa FROM tpnos LEFT JOIN tap ON tpnos.npk = tap.nos WHERE (((tap.dat)>=#" & tb_date & "# And (tap.dat)<=#" & tb_date & "#))) it gives no error, but it also gives no result. Textbox tb_sum...
  16. jaanisf

    Populate Forms textbox fields from query

    Erm... well, at first.. what is a recordsource property of tb_sum? I find only Control Source property. And, this SQL statement is taken from query's SQL view. It works fine. Query's name is bq_ap. As far as I understand, I need to put this statement in a tb_sum Control Source? But it gives me...
  17. jaanisf

    Populate Forms textbox fields from query

    I have a query like this: SELECT Sum([daudz]*[cena]*[reizinatajs]) AS Summa FROM tpnos LEFT JOIN tap ON tpnos.npk = tap.nos WHERE (((tap.dat)>=[apd1] And (tap.dat)<=[apd2])); It runs nice, asking me apd1 and apd1, which is two dates. All I want is, to create a form, where is a textbox with a...
  18. jaanisf

    Cant create any more controls

    I have only 25 rooms ;)) But, when it goes to dates.. ;) Yes, I know, it works well, when I have it for two weeks. But, let's close this. The answer to all this, is to use a spreadsheet control inside of a form ;)
  19. jaanisf

    Cant create any more controls

    But it's not what I want. I want this: |A|B|C|D|E|F|G|H|I|J|K|.. |1|_|_|_|_|_|_|_|_|_|_|.. |2|_|_|_|_|_|_|_|_|_|_|.. |3|_|_|_|_|_|_|_|_|_|_|.. |4|_|_|_|_|_|_|_|_|_|_|.. |5|_|_|_|_|_|_|_|_|_|_|.. |6|_|_|_|_|_|_|_|_|_|_|.. .. B,C,D,.. goes for dates 1,2,3,.. goes for room numbers. If room 4 is...
  20. jaanisf

    Cant create any more controls

    Can't follow what you mean..? ;)

Part and Inventory Search

Back
Top