Search results

  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

    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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. Y

    Datasheet help

    I am trying loop through a datasheet so that I can copy the contents of one field into another form. I have tried using the bellow code to do this on a button click event. However when i run it I get an error telling me that the object doesn't support this property or method. Im not quite sure...
  8. Y

    Loop through records

    I have a subform for which I want to loop through all the records and then copy one of the fields for each row into another sub form. I came up with the bellow code but i get an error when I run it. The error is an "error 438". Can anyone see why? Code is at follows and I am copying the...
  9. Y

    Form doesnt open at the top of the page

    I have a main form that opens on an autoexec macro. When ever i open up the database the form opens but for some reason it always opens a little way down the page so that you cant see the top and have to scroll back up to the top. This is rather annoying because i have a tab control and it...
  10. Y

    Applying a filter to a form

    Hello All. I am having a problem with a filter that i am trying to apply to a subform. I have a buttom on the form that when clicked should filter the subform (which is in datasheet view) to the criteria i set. This criteria will eventually run from a combo box but I wanted to just get the...
Back
Top Bottom