Search results for query: *

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.

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 = "#" &...

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

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

When I try to make a control it gives me this error: &quot;Microsoft Access can't create any more controls on this form or report. If you have deleted controls from this form or report in the past, you may be able to rename the form or report and then add more controls to it.&quot; I tried to...

If my labels' names are d1, d2, d3, etc.., how should I handle this? 4th row needs to be handled differently, but how? Private Sub btnshod_Click() Dim di For di = 1 To 27 Me!d & (di + 5) &.Caption = Left(Date + di, 2) Next di End Sub

It gives me &quot;The form name you entered doesn't follow MS object-naming rules&quot; error. What is wrong with this? Me.subform2.SourceObject = &quot;SELECT TOP 10 [tien].[datums] AS Datums, [tien].[nosaukums] AS Nosaukums, [tien].[summa] AS Summa, [tien].[pieziimes] AS Piezîmes FROM tien...

In MySQL: SELECT something1,something2 from somebase WHERE this=that LIMIT 0,5 ORDER BY something1 DESC; How can I limit query in Access queries? I need just the last 5 records to show, for example. Thanks in advance!

Hi! Seems like a simple thing but I do not know, how to make it. Well, I have an index form with a set of buttons. On pressing a button I want a subform to come up with another set of buttons according to the button pressed in an index form. And I want there a subform with no buttons when an...

I need two SELECT statements in one query, because it cannot be done by one statement. Can it be done somehow? Example: SELECT Field0, Sum(Field1 * Field2) FROM Table1 WHERE Field3 <> 'text' AND Field4 >= Forms!Form1!txtbox1 and Field4 <= Forms!Form1!txtbox2 SELECT Field0, Sum(Field1 *...

I need an sql statement in my form which selects a product of two fields in a table and then counts them all together. The statement should look as follows: sum1 = &quot;SELECT Count([Field1] * [Field2]) WHERE [Field3] <> 'ml' AND [FieldDate] >= txtDate1 AND [FieldDate] <= txtDate2 sum2 =...

I have four TextBoxes. TxtBox1 for amount, TxtBox2 for unit, TxtBox3 for price. This is what I need in my TxtBox4: if TxtBox2 = 'ml' TxtBox4 = (TxtBox1 * TxtBox3)/100 else TxtBox4 = TxtBox1 * TxtBox3 What is the right code and where shoul I type it?