Search results for query: *

I want to send a bulk email from Excel 2000 to a list of advertisers telling them that their advertising copy is overdue. I have found some VBA code on Ron de Bruin’s website (http://www.rondebruin.nl/mail/folder3/message.htm) which seems to fit the bill. Here’s the code: '***begin code Sub...

Thanks Eupher, I note your comments about the variable declaration. That was also picked up on the closed thread 702-396121 but nathan1967(Technical User) said "My intent was not to declare Variants. I guess I didn't catch it since everyting worked." It's worked for me too and, to be honest, I...

I was looking at a closed thread 702-396121 and am trying to send an email from my database using the following code as a template: Private Sub Command10_Click() Dim email, ref, origin, destination, notes As String '***set references from your form email = Me!email ref = Me!ref origin =...

Thanks Bob, I exported all the tables as .xls files, deleted the 'rogue' records and then re-imported them into an empty database. I had a few problems exporting, which I suspect is to do with the hyperlink field. I have had problems exporting hyperlink fields before. It says 'invalid...

I have a table containing information about london restaurants and there are a handful of records which I cannot delete. If I try to delete from the table, I get an error message 'The search key was not found in any records', these items have a minus sign infront of their ID number. In addition...

Thanks, willir. I tried what you suggested but couldn't find a way of selecting individual fields (ie File>Get External Data>Import). What I've done is to link the table which works OK but it doesn't solve the issue of the hyperlinks.

I am trying to export a table to another mdb but keep getting an 'invalid argument' error message. I've figured it must be the 'website' field for which the datatype is set to 'hyperlink'. I wanted to copy the table and then delete the website field, but it comes up with the same error message...

I have a restaurant database query which lists restaurants sorted by three fields: Location field (numeric) Cuisine type field (numeric) Sort by name field (alphabetical) I have records sorted by these three fields and then closed the database. But when I mail merge into a word document - some...

the database has been running successfully and I have no problem running a query from the facts & figures table. It's only when I import another file from excel into the database that I get the problem. I link that to the facts & figures table with a one-to-one relationship and when I try to run...

I am running a restaurant database for an annual restaurant guide with two tables. One table has the facts & figures (ie tel no, address, prices etc), the other has the 2004 reviews, which have been imported from word/exel. The tables are linked in a one-to-one relationship by ID numbers...