Search results for query: *

I have a button on a form which opens an email using DoCmd.SendObject, it was working fine then suddenly started to produce an error message "Microsoft Office Access can't send this email message" I've tried creating a new database from scratch with a second form which has a button that opens a...

I just had a bizarre conversation with a car salesman (nothing new there) he asked my preferred colour, I said that I quite liked the "Bronzy" coloured one. After a long discussion we established that the official colour was "Galaxy Grey" (ummm, it's brown with sparkly bits). He then said...

I've just had an email from Fechheimer Uniforms: UPS Returns Label Delivery This notice tells you that a UPS shipper has sent you an electronic UPS Returns Label. You can print and use this label to include in your outbound shipment, or send it to the consignee. The label will be available...

Coming soon see: http://news.bbc.co.uk/1/hi/england/oxfordshire/8136122.stm I want... Rosie "It doesn't matter how beautiful your theory is, it doesn't matter how smart you are. If it doesn't agree with experiment, it's wrong." Richard Feynman

In the UK news recently... A quorder is an order given in the form of a question. Eg "Are you going to empty the litter tray?" (I think the formal term is an interrogative imperative, though I expect to be corrected [smile]) Any suggestions for the following: "The litter tray needs...

I have an Access 2002 database containing linked tables to an Oracle 9 database. I'm hitting a problem with tables containing "memo" type fields, which I think are Oracle Long data type fields - I get the message: "the width of a Unicode text column must be an even number of bytes" And the...

TTUK has great pleasure in inviting all Making an Impression Forum members to our Grand Summer Beery Meet in central London on Saturday 22nd July. We'd be particularly pleased to see any TT members who are visiting the UK. Any UK members who aren't already TTUK members will, of course, be very...

I just had to offer this one up. Heard on a reasonably serious BBC (Radio 4, I think) programme "In an increasingly global world..." Umm, just how much more global can the world get? Rosie "Don't try to improve one thing by 100%, try to improve 100 things by 1%

I’m doing a project to crossmatch addresses from various internal and external systems. I have two tables containing addresses, each address has an ID and a grid reference - two fields, Easting and Northing (these represent the distance in metres from a zero point). A third table holds the...

I want to open a form to find addresses based on grid references within a range. I have 3 unbound text boxes, all with a general number format txtEastSrch, txtNorthSrch and txtENRange. My code is stLinkCriteria = "[Easting]>" & (Me![txtEastSrch] - Me![txtENRange]) & "and [Easting]<" &...

Hi I need to concatenate 9 fields in a query with a space between each item. However for any row, most of the fields contain a single space. I want to avoid excess spaces. I know I could do this with a lot of IIFs, but that seems untidy. & vs + won't help because of the embedded spaces, and...

I've put a control in the header of a sub-form which gives a count of the number of records and use this for some calculations on my main form. However, where there are no records, I cannot get this to return a zero. Initially I assumed the value in the control was null, but I've tried...

I have a user who has severe problems seeing the cursor in WORD and wants it set up to be wide. Using the Accessibility options in Control Panel (Win XP)I can set a wide cursor, this works great in every application I've tested, EXCEPT WORD. I've looked everwhere I can think of, but can't find...

I've just been introduced to a new concept by my staff/colleagues "yoinking", broadly speaking "acquiring by not totally officially authorised means, but for work-related purposes" eg, the removal from stock of 4 PCs to create a test network. I discovered this term when one of the PC's was...

I'd like to be able to display the full path of linked tables on a form, can anyone tell me where this information is buried? And how I could display it. I know I can get it from the Linked Table Manager, but the box isn't sizable so I often can't see the full path. Rosie "Never express...

I want to set up a button on a menu that opens one form if the result of a query is null, but opens a different form if the query returns any records. Can someone please get me started on the If statement? Rosie "Never express yourself more clearly than you think" (Niels Bohr)

I recently received this.... "Sophos provides protection against software (viruses, Trojan horses, and worms) which behaves maliciously. There is a category of application known as "adware" which although sometimes annoying cannot be described as malicious. The programs are normally up front...

I'm comparing two dates and I know I'm getting a mismatch between UK and US date formats - it works fine after the 12th of the month! I can't work out the syntax to force the format varX = DLookup("[HolDate]", "PublicHolidays", "[HolDate] = #" & strDate1 & "#") strDate1 is in "yyyy-mm-dd"...

I’m trying to insert data into a table based on a date range given in two unbound text boxes, the data varies dependent on the day of the week. All well and good, I can manage that. BUT, if the day is a public holiday I want to treat it as a Sunday. I have a separate table of public holidays...

I have a form with a continuous sub-form containing contacts, including their email addresses. I want to set up a button on the main form which opens an email (Outlook) with all of the email addresses in the To: field. I can work out how to send an email to a single address, but I'm stuck on...