Search results

I could not agree more!

Absolutly correct nanscombe...i am blind :).. I am much obliged..thanks!

I have posted the same question in an other forum also because of its "emergency".. I am using below code in my new Access 2007 db. Backend on a SQL. Exactly same code runs in my previous DB with the same backend. However, the wildcard search is not executed correctly in the new DB..but works...

Ok..i have Microsoft Office 12.0 Access Database Engine Object Library installed..i will replace the DAO reference with ACEDAO and test this.. Very kind of you Bob..thanks!

Thanks boblarson, below is my part of my code, i am using Exchange and Outlook object libraries. Is there any way around not using DAO? Dim strEmail, strBody As String Dim objOutlook As Outlook.Application Dim objEmail As Outlook.MailItem Dim strAttachmentPath As String Set objOutlook =...

Hi, i am using the below sending an email strBody = DLookup("PB_TEMPLATE_BODY", "PB_TEMPLATES", "ID_TEMPLATE=" & Me.ID_TEMPLATE) .HTMLBody = Replace(strBody, "<<InsertName>>", Me.txtFIRSTNAME) How do i insert multiple replace conditions? I need to insert at elast 10 more Thanks!

Subject should readd: Insert gif (image) with VBA / Access

Hi all again, (i use Access 2007) how do i reference a gif image stored on my Cdrive image folder to be inserted in below code i use for my email template. The image is the Header of the email body.I use the exchange method. Dim strEmail, strBody As String Dim objOutlook As...

I don’t remember the name of a great American comedian that commented the ongoing debate regarding “Earth Ecological Catastrophe, global heating, etc etc” with these words.. “- The planet will take care of itself, it will survive and thrive..Mother Earth works perfectly well...The people on...

Hi all..i am trying to find a workable sollution to this for a very long time byt without success... My application is distributed to 15 users and i want the users to be able to email records directly from Access. My idea is that a set of queries will populate a “e-mail”-form and from there...

Thanks VbaInet... Amateurs, such myself, have a tendency to complicate "things"..:) Thanks!

Thanks JANR.. i got it..i am dumb. It is the combincation of the two functions..instr() identifies and Mid returns the string result.. This is very much appriciated by both of you two..thanks!

THank you vbaInet, i tried the MID function and in my specific case it would not get the job done since it depends on a starting position for the string. In my case this is a variable since i want to try to extract everything after the specific symbol @..only the domain or did i...

HI all, Not sure how this procedure is called in english, however, i will try my best to explain.. Field A: Text field that contains email addresses Example: a.a@google.com I want to update field B (text) with everything after the @ symbol in Field A, i.e google.com..how do i...

Thanks JANR, i will take a look at that..

Hi all, I am using the below code to export the query result to excel. Private Sub Excelexport_Click() DoCmd.OutputTo acQuery, "AmountReportQuery", "MicrosoftExcel(*.xls)", "c:\MyReports\Amountreport.xls", True, "" The query includes two fields. “Amount” (Column A in the spreadsheet) and...

Thanks, i will look into this sollution

Hi I am trying to figure this out Form A. Button A. Text field A. Memo field A. (Plain text format) Text in Memo field A. “Hi all, we have just spotted locomotive <>..." By clicking on Button A i want to replace “<>” with the text in the text field A. Also..does anyone have any...

Thank you, much appriciated..i iwll play around with your suggestions.

Hi all, sorry for bothering again.. I recieve a syntax error "sometimes" :) when i save the form that holds this filter )while developing) Private Sub Command80_Click() Me.Filter = "[Assigned] like '*" & "EU" & "*'" Me.FilterOn = True End Sub Why?..also..will this sub function once i...