Search results

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

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

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

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

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

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

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

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

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

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

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

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

Putting the same text into every cell in a query column Hi All, I sometimes have to mark every record in a query with the same text in a field, when the field is either empty or contains whatever text. At present I do this by copying the text, and then pasting it (ctrl-v cursor-down, a...

Form view: lower part of screen hidden; dragging form footer does not help Hi All, I have designed a form which requires the whole of the screen for showing. The screen is maximised. One third at the bottom of the screen is a blank area marked by a thin horizontal line. The blank area...

Form view: lower part of screen hidden; dragging form footer does not help Hi All, I have designed a form which requires the whole of the screen for showing. The screen is maximised. One third at the bottom of the screen is a blank area marked by a thin horizontal line. The blank area...