Search results

  1. S

    Invalid Syntax - Nz Formula

    I am receiving invalid syntax for my formula. A1, A2, and txtAmount is the name of the text box, and they are general numbers. I need to (A1*A2,"",Round(txtAmount*1200/A1/A2/0,0)) =Nz(Nz([A1,0],0)Nz([A2],0),"",Round(Nz(txtAmount],0)Nz(1200)/Nz([A1,0],0)Nz([A2],0)) Thank you
  2. S

    How to create combo a-z to sort list box?

    I would like to create a combo box that sorts a-z or z-a? How should I go about this to sort data in a list box?
  3. S

    Help with correcting calculation

    I need help incorporating another textbox thats located in a different form to include in part of the calculation. My formula is written like this, but I understand this causing the problem "[Forms]![001Form]![txtAmount]." I probably didn't right it correctly...
  4. S

    Compile Error Expected Case

    I am working on creating hidden text boxes. Based on the selection from a combo box, it will display the hidden text boxes. I didnt get a chance to finish writing my code. It is displaying Complie Error Expected Case. Private Sub Form_Current() Dim Visible As Boolean Select...
  5. S

    Creating a table similar to word in access form

    I understand when I say the word table, people immediately think I am talking about creating an access table or displaying data from table on table. I want to create a table in my form, like you would do in Microsoft Word. How would you do this?
  6. S

    Need with coding access form with vba - Will Pay

    I really need some help with vba access and I will pay you.
  7. S

    How do you create a text box to lookup values?

    I am totally new to learning vba. If someone could teach me that would be appreciated. I have a command button and text boxes. Basically, I want to enter a value in the text box, and populates the rest of the text boxes related to that value.
  8. S

    Creating a text box similar to a combo box

    Currently I have a combo box display a list of items. When you select an item it populates the other text boxes. Instead of using a combo box I would like to use a text box by typing the name of the item. How would you do this?
  9. S

    Using combo box as text box

    Is possible to use a combo as a text box as well. Say for example nothing is in the database. You manually type in the information and it outputs that information in Form 1 to Form 2 field.
  10. S

    Unsuccessful with requery from combo to text box

    I a combo with a list of names to choose from and the text suppose display appropriate title associated with the name. Private Sub cboCom1_AfterUpdate() Me!Name1.Requery Me!Name1.Value = DisplayName End Sub Everytime I select a name, I receive run-time error 3326.
Top Bottom