Recent content by shkrebs

Almost right track... Hi Dave. Yes something like ... except that my data is stored in a accounting system without any export-funcions and that's what I'm trying to make. I've made the 1-n relation and I'm able to create a table where I put together all the company/dept/staff. My table looks...

Hi there. This is maybe not the right forum but since I'm messing around in my code, I'll start here. I'm lost about how to handle this problem. I got tree tables which I would like to mix together into one "flat" table. Tabel1 = Persons, Telephone, Fax ... Table2 = Company, Telephone, Fax...

Hi SSECCA I promised a big smile - here it is :D I see that my mail is not very clear 'cause I want to use the FM as a frontend and not the other way around ;) Anyway I found a solution where I'm using Access to "collect" the datas from the different tables and then I'm using a script from FM...

Hi there. I want to import / link a FileMaker DB to my Access DB using ODBC, to eliminate the need of making an export from Access. The problem (or task :)) is that I need informations from more than one table at the same time. Is this possible? What I done so far is: Since FM is not able...

Yes - "Ciao" or "Adios" or as good old Arnold once said: "Hasta la vista" :confused: I'm not to sure - I'm danish and just happen to be here because of a women :D Sorry - forgot it's only 6½ hour between Kentucky and Madrid :) Anyway - thanks for your help.

Address-book Hi Autoeng. Of course, yes it was something like that I'm looking for. Guess once I got the client in the address-book I can use the other resources like calender etc with this client. Anyway - it's worth a try. Thanks a lot - by the way - you up pritty early today, no? :) Søren

Hi there. Need an advice regarding those two products. Is it possible to "link" OutLook to the data from Access? It's and attemp to maintain only ONE database with customers but use the calender of OutLook to book meeting, apointments etc. I know how to make an import but I would love a...

When you are writing SQL in VBA you shall not end the statement with a ; The whole statement shall be between " Your-SQL-statement " Hopes it helps you. Best regards Søren BTW - just like Travis showed you in his example.

Create recordset... Hi Neil. I can see what you want to do, but I'm reusing the same query many times but with different value in the WHERE part. I.e. collecting the salesnumbers for a group of commercials. Also because the pc's in this company is quite old and I have to be careful with the...

WOW Travis - of course. Yes, my problem was that there was no value to test on.... From now on you will be a part of my eveningprayer :D Thank you Søren

Hi Sconly... Well - I'm not an expert - but why do you use a function to do this when you don't need a value return? Try to put your code into a sub instead. Søren

I'm using a public function to calculate the difference between to numbers in %. To make sure I don't get a "Division by Zero" error I'm using a switch. The numbers come from a table where the datatype is Currency. The function works - but still it returns #Error on my report when there is no...

Hi Jon. Well - it seems to me that you've got a lot of very good suggestions. With more than 4000 on this thread and no logo ... have U thought about that you might not have explained clearly what kind of logo you want???? ;) Good hunt Søren

Hi all. I'm writing almost all my queries in VBA and in this forum I've learned that to save memory it's best saving the queries and then execute them. Often I'm using one query as a source for the next query (can't remember what it's called :( ) and all the queries containing parametres and I...

I'm writing a SQL statement in VBA and save it with a CreateQueryDef, but when I look at it (the SQL's) in the QBE then the sequence of the fields has changed. It's a INSERT statement but I don't know if it's makes a different. Can anyone explain me what is deciding the sequence of the GROUP BY...