Search results

Hi ByteMyzer, I use The DoCmd.SendObject command: DoCmd.SendObject , , , strEmail, , , "Security Report " & Forms!IncidentView!IncNo & ":" & Forms!IncidentView!LogReport, Messagestr, False strEmail is the recipient IncNo & Forms!IncidentView!LogReport forms the Email subject Messagestr is...

Hi, Is it possible to browse and attach pictures to an email generated from Access XP VB? I already produce the emails but would like the the attachment option. Dave

I didn't split them - they were never together :-) They are separate fields in their own right. One derived from Date() and one from Now()... It was just the way I designed it...it works well and I can't any problem with it...it's been working nicely for 4 years without a hitch... Can you...

Thanks namliam, I wouldn't have got there in a month of Sundays... The reason I have a separate time and date is that it's a security event records system ands needs to show the day, date and time in one row of a multirow subform...It seemed the most convenient way. It also makes reports from...

Hi All, I want to build a query to select records based on time. My table contains the records - LogDate LogTime (Short Time format) I want the query to pull all the records for 24hrs back from now... I've tried Between LogDate AND LogDate-1 AND Between LogTime And LogTime-24 But it...

Hi all, I am running a 2003 database in 2007 and have come unstuck with an unexpected error message - Runtime Error 2282 The format in which you are attempting to output the current object is not available. This involves sending a report in the Snapshot Format - DoCmd.OpenReport "Incident...

Thanks Col/Gary, It was my error of using Chr$(10) instead of Chr(10). I have tried Chr(13) & Chr(10) and it works fine. Thanks for your help Dave

Thanks Col/Gary, It was my error of using Chr$(10) instead of Chr(10). I have tried Chr(13) & Chr(10) and it works fine. Thanks for your help Dave

No. The field is not one that is used for anything other than recording who's been emailed. The problem I have is similar to when I use Chr$(10) in MsgBox statements like - MsgBox "You are about to delete this record" & Chr$(10) & "Are you sure?",vbexclamation Putting one Chr$(10) has no...

Hi Col, The memo field is part of a table for records relating to reports. The memo field stores a list of names that have been sent the report. It seemed a logical place to store the list. Dave

This isn't a question of whether to steer a person in the right direction it's more a case of how to steer a person in the right direction... To say - "You could do what you're asking by.....but another way would be...." Is better than saying, "Why are doing it like that? that's not a good...

Hi All, I am trying to use a memo field to record a list of names. I don't want to use another table. The form I am using can send emails to people selected by the user. The form then finds the valid email address and sends the email recording the addressee to the memo field list. The problem...

Thanks RG. Is that a Doom guy you're using? Dave

Is it possible to remove/hide the combo on the forms' Main Menu toolbar which says - 'Type a question for help'? Dave

Thanks Col, I'm afraid it was me...locked into the idea that August to February was 6 months and not 7 as calculated by DateDiff. Dave Eyley

Using Date1 and Date2 as user inputs I use DateDiff() to give me the months difference... Me!TM=DateDiff("m",Date1,Date2) But the results are not quite what I expect... If I enter Date1 as 01/08/2004 (dd/mm/yyyy) and enter Date2 as 31/07/2005 (dd/mm/yyyy) I get a count of 11 months, not 12...

Thanks for that. I'll give it a try.. dave

Hi All, I have a report with a sub report. I want to number the records in the subreport from 1 to n so that the subreport will show a numbered list and the main form to show the total items in the subreport. The numbering is to aid the layout of the report only and has no bearing on the report...

I have done this with a large database that is used for an Estates Facilities Office. There are, potentially, up to 35 users and they all have varying access rights to various facilities of the db. I used a GetUser() function to get the Windows login name of the user and compared that with a...

I've not heard of smart tags and can't find any reference to smart tags in the MS help files...can you give me a little more? I would like the command/statement Access uses to open Outlook and insert an email address into the To: field... Dave Eyley