Search results

  1. jackie77

    emailing report as main body?

    anyone have any other suggestions, I read a bit about screenshoot, would it be possible to take a screenshoot of report then paste this into the main body of the email? Jackie
  2. jackie77

    emailing report as main body?

    Hi there, thank you both for the replies, I have seen this link before but I was not sure how to set it up for my purposes, two really stupid questions :o where should I place the code used in this example? I have placed it on the button and worked around with it but it is not working second, I...
  3. jackie77

    emailing report as main body?

    Hi all :) I know there is a number of treads on this forum devoted to emailing reports etc as the main body of an email but they are all to in-depth and I can’t manage to simplify them to get them to work for me What I basically want to do is I have a report called: report_titan I have a...
  4. jackie77

    Finding Help?

    Hi there :) Many thanks Zigzag I really appreciate it, I am really struggling with this :(, I have separated the form from the rest of the database and attached it to this post I have saved it in access 2007 and 2003. what I am looking for it to do is on the Search_Job form I want to be able to...
  5. jackie77

    Finding Help?

    Hi all:) I am looking for some advise, I work for a small service company and we our trying to computerize our service jobs through the use of access 2007, We have completed 80% of the database but are having a few problems completing, for example the search function on some forms etc, I have...
  6. jackie77

    multi criteria Form Search?

    Sorry forgot to add the code :o Option Compare Database Option Explicit Private Sub btnClear_Click() Dim intIndex As Integer ' Clear all search items Me.txtBooked_Date = "" Me.cmbEngineer = 0 End Sub Private Sub btnSearch_Click() ' Update the record source...
  7. jackie77

    multi criteria Form Search?

    Hi thanks for the reply! that sound like exactly what I want but not sure how I would go about that, I have successfully managed the first part (see code belwo) but sorry new to this how do I go about using the record I select in the subform to run a query to populate the main form? Jackie
  8. jackie77

    multi criteria Form Search?

    Hi all:) Has anyone ever come across an example of a form where you can carry out a multi criteria search which not only displays the results on a subform but when you select an item from that subform the details can be displayed in text boxes etc on the main form. I have tediously searched...
  9. jackie77

    Multiple criteria search

    many thanks again help would be great!!
  10. jackie77

    Multiple criteria search

    I'm not sure :confused:, the original code used (by Gromit) was only designed to display the results on a subform and did not have any text/display boxes on the main form, I have successfully used the code in one of my other forms to display on the subform only, its only when I tried to adapt...
  11. jackie77

    Multiple criteria search

    Hi thanks for having a look, I am very surprised it is operating error free for you, I to have removed the orphaned 'end sub' but I’m still unable to get it to operate, when I search under any of the Booked date, Job Id, House Number, Address boxes and click search nothing happens the results do...
  12. jackie77

    Multiple criteria search

    Anybody out there!
  13. jackie77

    Multiple criteria search

    Hi everyone I thought I would save it in access 2003 also, is there anyone out there with any ideas I'm getting desperate! Jackie
  14. jackie77

    Multiple criteria search

    Hi all :) I am new to access and have been working on creating a database to manage service jobs. I have adapted the search code which was very kindly placed on this forum by Grommit but am having problems getting it to work. To some of you out there this is probably really simple to fix but...
  15. jackie77

    Split form search

    anyone out there?
  16. jackie77

    Split form search

    Sorry the codes are the wrong way round! the code I am trying to adapt is on top and the orginal code by Gromit is the bottom one!
  17. jackie77

    Split form search

    Hi all :o I now finally managed, with the forums help, to successfully adapt and use (very slowly due to my lack of experience)some search code kindly placed on the forum by Gromit. What I am looking to do now is place the search in another one of my forms. I have access 2007 and the form a...
  18. jackie77

    Spreadsheet Formating/layout?

    Many many many thanks for this, its great, it would have taken me ages to get this far, so many thanks for the help it really is most appricated. :D :D your great !!! It looks like its exactly what I need, So what I do now is just paste the entire 1000 or so rows into the report query sheet...
  19. jackie77

    Search problem

    Yes its working now fine andt it is set as a general date, I am using access 2007 so I not sure if that makes a difference? Thanks again for your advise
  20. jackie77

    Search problem

    Hi Paul I got it to work :D thankfully!!! I managed to get the search to work on the engineer criteria but not the date, when I replaced the code I previously had it works ok now, can I just ask a silly question you said you would not use Like for a date can I just ask why? would you suggest I...
Back
Top Bottom