Recent content by Yippiekaiaii

  1. Y

    Create an Email

    Hello All I want to be able to click on a button on one of my forms and it create a new outlook email. I also want this email to have an attachment that is a report that I already have made. I dont really know where to start with this, can someone tell me if its possible and how to go about...
  2. Y

    Comob box filter

    That doesnt work, it gives a type mismatch. I have 2 fields in the combo so I am guessing it is looking at the wrong one with that, I dont think I can go about it that way.
  3. Y

    Comob box filter

    What kind of control is this working from? Im not familiar with the bit that says "[Screen].[ActiveControl]"?
  4. Y

    Comob box filter

    Sorry I should have said after update not on current, i already have it on the after update.
  5. Y

    Comob box filter

    I am trying to apply a filter to a datasheet subform using a combo box. This is the code I have used on the "after update" event: [Ordering - Price list items].Form.Filter = "[Secondary Category]=" & Combo72.Column(1) [Ordering - Price list items].Form.FilterOn = True When I run the query i...
  6. Y

    Using Insert SQL in VBA

    That works perfectly thanks!
  7. Y

    Using Insert SQL in VBA

    I am trying to insert a new record directly into a table using INSERT INTO sql. The field data is coming from some text boxes on an unbound form. I keep getting an error telling me "too few parameters. Expected 5" This is my code Dim db As DAO.Database Set db = DBEngine(0)(0) Text7.SetFocus...
  8. Y

    Alter selection criteria of a query from a form

    Thank you for the reply. How do i create a regular/public module?
  9. Y

    Alter selection criteria of a query from a form

    Hello All I have a form that runs off a query that displays further details of a record in a datasheet when you double click on a row. The query itself has criteria that looks at the open form and selects the correct record. My question is can you change the results of the query either using...
  10. Y

    Problem with accde file

    Hello All I have created a accde file from a database to restrict users from making changes to it. However this has had the side effect of preventing any vb code from working. For example I had a text box that had vb code attached to it, that acted as a filter based on what you typed in...
  11. Y

    Copy to clipboard

    That you, this has worked! However I have moved on slightly from this now. I need to now copy two fields to the clipboard so that when I paste them they paste as two separate columns in a table. Is there way of copying two fields at once? Or adding a second copy to the first? Basically my...
  12. Y

    Copy to clipboard

    I have a form which contains a datasheet subform. I want to be able to click a button that will copy the contents one of the fields of the currently selected record into the clipboard. This is so that i can then paste it into another program. I have tried the following code but it throws up...
  13. Y

    Datasheet help

    I tried what you suggested changing my code to this: Dim rst As DAO.Recordset Set rst = Me![Roll Out - Sign items pick list].Form.RecordsetClone Do While Not rst.EOF Me![Roll Out - Sign items added].Form!Code = rst.Fields("Item Category") rst.MoveNext Loop Set...
  14. Y

    Datasheet help

    The button is on the main form. The two sub forms are both located on the main form. In effect i have two sub form datasheets side by side on a main form that i want to copy the field from one to the other.
  15. Y

    Datasheet help

    Thank you for the reply. I am copying from one sub form to another. One is called [Roll Out - Sign items added] the other [Roll Out - Sign items pick list] The main form is called [Roll Out - Site Form] The code is on a onclick event of a button. I changed the code you suggested but this...
See more
Back
Top Bottom