Search results

Wonder if anyone could help me with this one? I have to extract from a regular text file update the Post Code, the text file comes in the following format ie: AB101BD199512394208062000QA28011791SN9S00 called [F1]in my table / query. The only data I need is the first 7/8 chr ie AB101BD BUT for...

Thanks again for all the help but still not working: Ive been searching and came across the following code to remove spaces: Public Function RemoveSpace(ByVal strData As String) As String Dim strText As String Dim intCounter As Integer For intCounter = 1 To Len(strData) If...

Many thanks for your reply, I have tried your suggestion but to no avail all I get is the first 3 chr of the [postalcode] into me new field: TempPCS: Left([PostalCode],3) & Mid([PostalCode],5,1) am I misunderstanding the use of your suggestion? regards

I have an enormous Post Code Table 1.7 million records, which I must update every month into usable sectors for our carrier cross refs, the UK postcode is in the format CB6 3HQ, CB6 3HR, CB6 3HS, CB6 3HT, CB6 3HW etc I need to be able to remove the space then only use the first 4 chrs ie CB63...

Hi, it just errors now at Set myItem = OL.CreateObject("OutLook.mailitem") when this line is taken out its at. myItem.HTMLBody = strHTML and then it errors as the object not set etc. Al I want is to send a report via the text of an email body, rather than as an attachment. I had found this...

Again thanks I have been going through it again and recompiled it and guess what it now goes almost to the end but stops with a "The operation Failed" error.

Mail Problem Many thanks for you taking the time and trouble to respond but still getting "Object variable or with block not set". and I I clearly dont understand VB I,m at a loss. Steve

Thanks for the sppedy reply, I am sending a new mail and have as suggested added the NEW I now get "Invalid Use of New Keyword" It will be me being thick but your help appriciated. =========================================== Function email2delivery_email() On Error GoTo...

Hi I,m trying to utilise some code below which was posted here in 2002 which if I can get it to work will do just what I want, my problem is that when I run it the first part works fine, creates the report but when running on fails with "Object variable or with block not set" Dont know why...

Ok folks I have found the basic code to be able to name the report as below Option Compare Database Function delivery_email() DoCmd.OutputTo acOutputReport, "Trailers Arrival", acFormatRTF, "C:\TEMP\Pre-Alert-" & Format(Now(), "dd-mm-yy-hh-nn-ss" & ".rtf"), acPreview, False End Function Any...

Outlook Express I have found that in internet expolrer set the default email to Outlook Express and your send object will send out via that email client.

Many thanks for your reply, I think we are at cross purposses. What I need to do is to be able to name the attachment, currently the name will be the report name that is generated into the rtf file. ie Access Report = GateLog when exported as ane email attachment the attachmnet will be...

I have several reports that are generated at points during the day. These reports are generated as rtf files and are sent as email attachments. The attachment is therefore the "report name".rtf. Is there a simple way I can add to the name either a unique number or even just a time stamp? I have...

IIF Problem Thanks very much that has resolved the IFF issue. My only other problem is with the Authorsed Name field, all the data in the tables are imported from our main unix server the field if not containg data should be empty but in many of them there are spaces this causes "" or is null...

IIf Problem Thanks for the reply, I tried it and result = too many arguments, I played around with it but still to no avail. thanks anyway

Just wonder if anyone could give me some help on an IIF function used in my query: I have a table which has numerous “W” codes, the charging for an order does not occur if it has a W12 or a W14 code and has no “[Authorising Name]” BUT does however charge if the weight of the order is over 100kg...

have a DB which is working fine on most PCs (approx 15 users) I do however have a problem sending emails from some machines (using a macro to do the send object as example below) The mail program used is Outlook 2000 / 2003 DoCmd.SendObject acReport, "Returns Notice", "SnapshotFormat(*.snp)"...

I have two reports which are run via a macro one produces a .snp file the other an excel file (both of the same data based the same query). I use the send object to send these files as attachments to several people. This produces two emails with one attachment in each. My question is how can I...

Report size Dont know if this will help but I have found that the default paper size in the printer properties does affect / overide some of access settings. I tend to set my reports onto A4 but most printers are defaulted to letter setting them to A4 in all the options has solved my problems

Import Error Thanks for the reply, Warnings are not turned off, no import error table is created and in the tables there are no validation or filter rules. If I copy the row from my excel table and paste it directly into the table there are no errors and he record is saved an normal. The...