Search results

Thanks for your help but after a Holiday I'm no longer on the job. My apologies for this late reply.

Thanx, but how do i use OLE to achieve this ? Remain both fields linked to Customer so that a number of rows is inserted equal to the maximum number of records of one of those two tables? Example: Customer1 has 3 conversations & 4 invoices Customer2 has 3 conversations & 2 invoices etc It should...

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

Thanks for your reply, but i already have. All topics with "numeric overflow" remain unanswered. There is even somenone with exactly the same problem - but no solution.

If you use the wizard to create a form you you can choose multiple ("more than one") tables as data source (second menu). Then you can choose how you "want to view your data". Try it out!

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

Man this is brilliant! Please accept my humblest gratitude. :-)

Are there Boards with the same names? Try to sort on the key values as boardID

Sounds genious! Thanks! Unfortunately I got an error: on Dim dbs as Database ("Compile error: User-defined Type not Defined"). It seems "Database is not a valid type? I also have antother question. Should the code be put in a module or can it also be put behind a form? Thanks again.

And what does not work after you created a (linked)form based on the same table and a button to open it (and search for specific records)?

How is sorted and grouped?

I do not quite understand your SQL or the results (not really straight) but a normal way of solving this is to add another group level: Gender for male/female

So what is the problem? That you cannot create a union-query or fields4,5,6 or?

Unfortunately my first table above is not straight. But in my database it is. So Please consider it as a beautiful table.

Thanks for your replies. I'm sorry. Probably i have not been specific enough. I have created an linked table. The text file is space-delimited and causes no problems to be "imported" (=through an query appended in an existing table) as a perfect duplicate with valid records. The fields are...

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

As always there are multiple solutions. I stich with my former conclusion that using a table is none. Stille I do not understand WHY you prefer a table look on screen. You should consider this! Working with a single subform is a simple solution that is userfriendly. You can use the record...

You can create a subform within your mainform to get alle the records as you want. "The wizard will lead you through the process". Furthermore creating a field in a table based on other fields within that table is not a proper use of it. It is better to create a query that calculates the...

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

Thank you for your answer but I get the same error: Run-time error 2001: You canceled the previous operation. When clicked on Debug the line Me.Bookmark = rs.Bookmark is highlighted. That line is used to find a record, but to show the last record on my subform is activated "On Current". The two...