Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. monomax

    Bulk email from excel

    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...
  2. monomax

    Sending e-mail from access

    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...
  3. monomax

    Sending e-mail from access

    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 =...
  4. monomax

    Undeleteable records

    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...
  5. monomax

    Undeleteable records

    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...
  6. monomax

    Hyperlinks in a table

    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.
  7. monomax

    Hyperlinks in a table

    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...
  8. monomax

    Mailmerging from a query

    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...
  9. monomax

    exclusive mode

    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...
  10. monomax

    exclusive mode

    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...

Part and Inventory Search

Back
Top