Search results

Thanks for the suggestion ridders, but this has already been tried and discussed and it's a no go. No attachments. I've started looking into mail merge which may be a solution worth looking into. The report called "rptCompanyNotes" is being generated from a query. There maybe a way to use...

I'm actually doing both. One button outputs to a .RTF and another button to .html for Outlook. I've been trying different ways to get a properly formatted Rich Text memo field to anything that isn't an attachment. Originally, I would output to an .rtf and then just copy and paste the info...

Because the recipients of the report want to be able to copy and paste parts of the email to other emails of their own. And senior management does not like to open attachments on their phones...

I tried to send it out as an email but it still shows up in Outlook without any formatting. Are you saying that there IS as way of sending an Access 2010 report to Outlook 2013 and still keep all the formatting? Like the bullets, highlights, indents, bold, underlines, etc... ? Here's my...

My company provides employees with Access 2010. I've been requesting that our IT dept do not remove Access 2003 till now. But I decided to try and update my database so that I can use the Rich Text feature. After converting the fields, forms and reports to use Rich Text, I was very...

You are absolutely right and one day I'll have to go back and re-structure the table so that the calculation is done on-demand just on the forms. The reason it I'm doing it this way for now is because the DST is a field in a table. And it will add or remove one hour for DST depending on a...

The error was the same as the title of this post. I'm guessing that Access doesn't like to see any quotes in the update query. At least I haven't been able to get them to work unless I build the string outside like I did in this case. Could be wrong...

Thanks Minty for finding that error, but fixing the TYPO didn't help either. I did however manage to get it to work. To get it working, I left the working update query as is and then created a button on the form to run the update query. Private Sub cmdUpdateDST_Click() On Error GoTo...

Thanks Colin, but the code is still not working. As you correctly observed, the code did come originally from an update Query. Here is the original code which does work. UPDATE tblCountry INNER JOIN Query1 ON tblCountry.CountryID=Query1.CountryID SET tblCountry.ChkDST = Query1.Active; The...

Would someone please let me know what I'm doing wrong in this code? I'm trying to do an update query and suppress the warnings that show up when you run the code. The code works fine on it's own without the SQL string. Thanks for your support. Dim strSQL As String strSQL = "UPDATE...

One more thing before I implement this, I forgot that I'll need to have an update query or some way to update all the ChkDST checkboxes in the table. Otherwise, the user will have to update each record one at a time. This is what I've got so far using the query that is in the attached...

Thanks Mark. That works as well and seems to be a better way of doing it. The only thing I don't like is that the record goes into edit mode as soon as the form opens. I think this is because of the on current event and one of the reasons I didn't use that trigger. Both seem to work though...

Actually, I found another way of doing this instead of using the IsDst function. Basically, I created a checkbox in the table called ChkDST. Then I used an after update VBA to change the state of the checkbox depending on the values in the DSTStart and DSTEnd fields. This is what I came up...

I get a Run-time error '13' type mismatch. It's just one table, one module with the function and a form.The module hasPublic Function IsDST(ByVal d0 As Date) As Boolean IsDST = d0 >= NextSun("DSTSTART " & Year(d0)) And d0 < NextSun("DSTEND " & Year(d0)) End Function Private Function...

I'm trying to use this code on a form where I'd like to display if the local time in that country is in DST or not. I have 2 text boxes and an unbound check box DSTSTART - bound to a DSTSTART field in a table DSTEND - bound to a DSTEND field in a table DST Check box - Unbound The idea is to...

Actually - forget about this. I tried it and it seems that you do need to convert both front and back ends to get the Rich Text Field to work. But then I've encountered so many errors in the first 5 minutes that I decided to just live with the formatting issue instead of trying to fix who...

I have an Access Application Version 2003 with the tables in an Access 2000 back end. All is good. But I’m having a little difficulty with the formatting of some memo fields that I’m outputting to Outlook emails. The VBA works but the formatting and output isn’t as nice as I’d like to have...

But the file you provided is an .xls file. I'm using Excel 2013, so for me a template gets saved as an .xltx file. This is probably why my Access 2003 isn't liking that file format. So to get this to work, I'm using two files. One called Update.xls and another called UpdateTEMP.xls. The...

Hi Ridders I only saw your response after I sent mine. But after looking at what this is doing, it seems to be almost exactly what I'm doing now. But instead of saving the template to a new name, I've just linked the template to a formatted spreadsheet. Thanks again!!

Thanks for all the suggestions. I tried the clearcontents and it seems to work. But for some reason, it crashes my Excel if I do it a few times consecutively. Then I have to use the task manager to stop Excel and then it works again. Can't figure out why it hangs sometimes. So instead of...