Search results

  1. J

    Can't create any more controls

    When I try to make a control it gives me this error: "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." I tried to rename the...
  2. J

    For i = 1 to 100 Next i problem

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

    Drop-down menus

    Is there any way to replace the default access "File", "Edit", "View",.. drop-down menus with my own?
  4. J

    current record control

    How can I get a current record showed in a textbox? I know, it's kinda simple: txtbox1 = Me.CurrentRecord But, where should I put the code, so that it would update on every buttons press, on every TAB press etc?
  5. J

    Open subform with a button

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

    Two SELECT statements in one query

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

    SELECT a product of twho fields

    multiplication in SELECT statements 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 = "SELECT Count([Field1] * [Field2]) WHERE [Field3] <> 'ml' AND [FieldDate] >= txtDate1 AND...
  8. J

    SELECT in Text Box

    Cannot solve this. Imagine two tables [Table1] and [Table2]. [Table1] has three fields: Name, Birthdate and Occupation. [Table2] has two fields: Name and Birthdate. [Table2] is already filled up with meny records. Now, I have a form for editing [Table1] records with a ComboBox called "Name" and...
  9. J

    values from previous record in a current record

    Hi, a have a problem i cannot resolve. Imagine a have a table with fields [name] and [surname]. Now, in form view, when I want to edit or add new records I have two text boxes named "name" and "surname". The problem is, I need another one text box, wich shows, for example, a [name] value for a...
Back
Top Bottom