Search results

  1. A

    How to link additional data source to a form

    How to link additional data source to a form Hi All, I have a db with three linked (related) tables. I have a form that has, at present, only one of these tables as a data source. Now I want to bring a couple of fields from another table into that form. I know how to link a table to two...
  2. A

    Searching all fields in a table

    Hi Rod, Thank you for that. Adrian
  3. A

    How to link additional data source to a form

    Hi All, I have a db with three linked (related) tables. I have a form that has, at present, only one of these tables as a data source. Now I want to bring a couple of fields from another table into that form. I know how to link a table to two data sources when first creating a table. But how...
  4. A

    Keeping background notes inside the database wrapper

    Hi, Pat Hartmann, Brilliantly simple. I'll do that. Thanks. Adrian
  5. A

    Partitioning an address column

    Hi, Mick, Neileg, and everybody, Thanks for your comments and offers of help. The problem is now solved. Yes, it does not matter in which field the town or village is, as long as it is in a separate field so that the commas can be taken out. I have been lucky and found a local guy who, last...
  6. A

    Partitioning an address column

    Hi FoFa, E Pluribus Unum, you are one to talk (smiles!), it's "Ex uno plures" what I want. Seriously, you are in effect telling me that it cannot be done. I would of course be prepared to do a limited amount of manual tidying up. So what I propose to do is: 1) to replace all commas in the...
  7. A

    Partitioning an address column

    Problem: Turning an address column containing a comma into two or three address colums containing no comma I have a database with the structure: company address town postcode (zip code) The present address column contains one of the following (I give examples) - 76 Nelson Street - 99 Bush...
  8. A

    Keeping background notes inside the database wrapper

    Is there are facility which enables me to keep something like a Notepad text file safely inside the mdb wrapper. I want to keep notes on what is going on in the database, state of development, reasons why certain decisions have been made, purpose of certain columns (but not as restricted as can...
  9. A

    Searching all fields in a table

    Hi, Rod, Great. That sorted me out. I have been doing these searches for ages, but I never saw that option (Table, or Form) in the Match field. Thanks. Adrian
  10. A

    Access 2000 Problem, Can anyone help?

    Hi, I don't know how to do what you want to do AUTOMATICALLY, but manually the idea is as follows. So I just want to explain what an earlier correspondent meant when he said you have to change the table (and you can NOT 're-set' the query). The query always shows the same record for a given...
  11. A

    Searching all fields in a table

    Subject: Searching all fields in a table Hi, All, I have to send an Access table consisting entirely of Text fields to another company for automatic list cleansing. My table MUST NOT CONTAIN even a single comma, else the whole procedure will go Iraq-shaped. Therefore before sending the...
  12. A

    How to partition a table into two linked tables

    Hi, Ruralguy, No, I have never used Action Queries. Will look in book for it. How will it help me in linking these tables? Gives a hint. I have though, with the help of a friend who has at least a hunch (but only a hunch), succeeded in linking two tables by clicking on the Relationships...
  13. A

    How to partition a table into two linked tables

    Adrian replied to that No, I have never used Action Queries. Will look in book for it. How will they help me in linking these tables? Gives a hint. I have though, with the help of a friend who has at least a hunch (but only a hunch), succeeded in linking two tables by clicking on the...
  14. A

    How to partition a table into two linked tables

    Hi, All, I have so far only worked with single tables and queries but not with linked tables. Now the following problem has arisen. We have a database all of whose fields except two are of type = Text. Two fields are type = Memo. We have to submit this database, i.e. its main table, to an...
  15. A

    Memo field does not allow <enter> to create linebreak

    Hi Bosch and Wayne, Thank you for your your suggestions. Using ctrl-ENTER instead of ENTER worked (produced a line break). Changing the keyboard options to "Move after enter: Don't move" did NOT have the desired effect. I now have 'don't move', but the result is that the original field is...
  16. A

    Memo field does not allow <enter> to create linebreak

    Hi All, I have a database with two memo fields. Both have exactly the same properties in table design view. One field is called 'notes' and when I want a new line I just have to hit ENTER. Result is as wanted. The other field is called 'responses' and when I hit ENTER, the cursor jumps to the...
  17. A

    How to copy a column from one table and insert it into another table in the same db

    Hi Rickster57, yes, thank you, it worked. I had forgotten that creating a new column in a Table does not automatically make it a Memo type. Thanks. Adrian
  18. A

    How to copy a column from one table and insert it into another table in the same db

    Hi, thank you, I will try this. Apologies to everybody for three-times posting my query. The submit button seemed to be stuck, I interrupted and pressed again to get it going. Sorry. Adrian
  19. A

    How to copy a column from one table and insert it into another table in the same db

    How to copy a column from one table and insert it into another table in the same database Hi, All, I have two tables (old and new) sitting in the same database. The new table is the result of 'data cleansing' done by an external company. In the process (export and import via excel) two memo...
  20. A

    How to copy a column from one table and insert it into another table in the same db

    How to copy a column from one table and insert it into another table in the same database Hi, All, I have two tables (old and new) sitting in the same database. The new table is the result of 'data cleansing' done by an external company. In the process (export and import via excel) two memo...
Back
Top Bottom