Search results

i've three tables. 1. Customer (concerns customer data) 2. Conversations (concerns conversations with customer) 3. Invoices (concerns outstanding invoices of customer) Last two tables got the key of table Customer but have an arbitrary lenght to one another. I would like to export this data to...

I'm trying to append records from a linked .txt table into an Acces table. The .txt file is formatted as a report so columns contain different datatypes (headers & columnnames are text while the data can be numbers). Creating the linked table I have formatted some fields as numeric so the...

I have made a linked table to a text file (which is continuously updated). Unfortunately the file is formatted as report. This means that the first values are omitted if they are double. For a proper processing I must put those values "back". So far I know there is no solution by SQL since if...

I have a report imported from a text format into Access. The problem is that double values are left blank. The first field is numbered and each number concerns one item. It is necessary to add numbers to the blank lines in my Access table for processing the data properly. How could this be...

Clients can receive multiple Mailings. Therefor I have a subform Mailings on a mainform Clients. Is it possible to show the last mailing of each client at first when I switch bewteen the clients? - Docmd.GoToRecord causes some problems, because it interrupts another code. - Sorting (descending)...

On a main form are three leveled subforms: - Form_Customer - Form_Mailing - Form_Subject - Form_Invoice When a control on a subform has got the focus once, the normal taborder is somehow overruled. When I use the TAB-key to leave the main form and enter Form-Mailing, the cursor jumps to the...