Search results

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

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

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

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

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

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

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

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

many thanks again help would be great!!

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

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

Anybody out there!

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

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

anyone out there?

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!

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

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

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

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