Search results

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

Hi Rod, Thank you for that. Adrian

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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