Recent content by Beerbrewer

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