Search results

  1. A

    --Is Not Null-- vs -- <>"" --

    Thanks, Banana and KeithG, I will consider these points - need some more information to understand entirely. Notes field can be done, but the text presently in some of the Fax cells is "FPS" (Fax Preference Service), which means it is illegal fax these people, and we must not try to obtain...
  2. A

    --Is Not Null-- vs -- <>"" --

    --Is Not Null-- vs -- <>"" -- A Query based on ValidMainTable shows 418 records when I set Fax to <>"", as in the SQL condition below WHERE (((ValidMainTable.Fax)<>"") AND ((ValidMainTable.URL)="") AND ((ValidMainTable.FaxSuppression)="N") AND ((ValidMainTable.LuigiBatchDate) Is Not Null))...
  3. A

    Changing data source (table) for a query

    Hi KeithG, thank you for creating that code for me. It is somewhat beyond me and I have never worked with Modules in Access before. Since I cannot expect you to teach me the basics in this Forum, I have sent your solution to a VB programmer friend (extraordinarily patient - smiles) and asked...
  4. A

    Changing data source (table) for a query

    Hi Keith, Thank you. This is a single-table db, i.e. no relationship. I have uploaded the db for you. It is now at the following URL: www.tudo.co.uk/testing/demo-db.zip I want to replace ValidMainTable by ProtectionTable01 (i.e. ProtectionTable01 will become the new ValidMainTable) and I...
  5. A

    Changing data source (table) for a query

    Hi PeterF, Thank you. I have come accross this feature before but cannot find it now. Could you please tell me where to change this setting, and its exact name, so that I don't mess up something else? Thanks. Adrian
  6. A

    Changing data source (table) for a query

    Hi, thank you both for trying to help me. Having exhausted you as a source of information, I think I WILL re-do the queries. I had one tip from a friend for the avoidance of error and of some labour: In Design View of the Query, I display the query in SQL view (View), then copy and paste it...
  7. A

    Changing data source (table) for a query

    You ask: Why not just create fresh queries for the new table: It is too time consuming 1 There are many queries attached to the table 2 Some of them are complicated, that makes re-making them time-consuming and, worse, error-prone 3 The substitution operation for this table is a regular...
  8. A

    Changing data source (table) for a query

    Hi, I have two Tables TA and TB. I have a set of queries based on TA. I want to substitute TB for TA (i.e. TB will stand in place of TA). I want the old TA queries remain unchanged but now be based on TB. If I delete TA and then rename TB into TA, I will lose the queries. Therefore I want...
  9. A

    Tabbed multiple-page form

    Tabbed multiple-page form I have created a tabbed multiple-page form, consisting of two pages. On one-page forms my Access is configured in such a way that, ctrl-pgDwn gets me to the next record. I want to use this on the multi-page form as well. But I always want a new record to start...
  10. A

    Query not responding: empty fields?

    Hi, thank you, Michael. That worked. I should still be most interested to know WHY my original approach did not worked: is not null What is the difference between: is not null, and <>"" Are there characters in my field which I should remove before creating the query? Thanks. Adrian
  11. A

    Query not responding: empty fields?

    Query not responding: empty fields? I have a table with a field 'Fax number', type: text (since occasionally we write a comment in there, like 'prohibited'). Some records have fax numbers, others are empty. I want to find all records which do have a fax number. So I wrote into the Query: "is...
  12. A

    ID fields: data type differs in linked tables

    Thank you, Len, for confirming my suspicions. This somehow happened inadvertently when (with due ignorance) I divided an original large table into three related tables. Will now, armed with your advice, go to someone local who knows more than I do and try to safely put it right. tx Adrian
  13. A

    ID fields: data type differs in linked tables

    I have a database consisting of three linked tables, with ID as unique identifier (primary key). I would have expected the data type for my unique identifier, especially in the main table, to be Autonumber. However, I discovered with some surprise that the primary key (ID) in Table 1 (Main...
  14. A

    How to search an Access table for unwanted <cr> characters

    Hi gHudson, Thanks for that. Haven't used any functions before but have book and will now find out how it works. tx Adrian
  15. A

    How to search an Access table for unwanted <cr> characters

    How to search an Access table for unwanted <cr> characters Occasionally a stray carriage return <cr> Ascii 013 character finds its way into an Access table. These destroy the database when the table is processed by an outside utility for data cleansing. To prevent this from happening, we...
  16. A

    Loss of Primary Key when importing csv file

    That's a good idea. Thanks, mate. Adrian
  17. A

    Loss of Primary Key when importing csv file

    Loss of Primary Key when importing csv file Hi All, We are submitting an Access db table with ID as primary key to an outside company for processing. We export it as csv file and that's how it comes back. After importing it back, we noticed that our IDs, which previously had 'gaps' as a...
  18. A

    Checking the integrity of db after processing

    Hi, All, Background (questions: see below) --------------- I have a db whose one and only table has recently been split up into three tables as follows: 1 Main table (containing contact column; name, tel, fax, email, etc) 2 Memo table (containing long fields of type Memo) 3 Non-memo table...
  19. A

    How to link additional data source to a form

    sorry, and thank you. Somehow this has sorted itself out now. THE WAYS OF THE LORD ARE MYSTERIOUS. Adrian
  20. A

    How to link additional data source to a form

    Hi jeremie, I have done what you said. All that worked OK. The form has now "All three tables query" as its source. "All three tables query" is linked to the three tables, and it shows specifically "Notes" from Table 3 and "Education Authority" from Table 2. In the query design view, both...
Back
Top Bottom