Search results

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

Hmm, in this case I would try to make two new test-forms. 1 with 1 field and a button, and the other with only 1 field. Give the fields name like FIELD1 etc. etc. just to keep is simple. Then see if U can make it work there. If it's working you have some mess in your names of your forms /...

Hi Doc. Thanks for your input. And your right about Ed, but then again, a lot of people is remembered for the things they didn't do :D Have a nice day over there. Søren

Hi shing... As The Doc said - if U could provide us with a little more info... :) Ie. 1) Have U created the new form based on a tabel / a query or what? 2) Do your button work? Does it open the new form? 3) What ver. of Access are U using? 4) As Dave wrote #Name means Access can't find...

Hi there.. With the button you create an "OpenForm" event, and use the wizard to guide you - it's easy. Let the fields in the new form use the old form as a datasource. Use the propety for each field and in the datasource you write: =Forms![old-form-name].[name-of-field-in-old-form] Good...

Well - as Fuga wrote then I think the best way is to make a query which select the data you need for your report and then base the report on this query. Goto propeties for your report and look for the DATA-SOURCE. If you don't change any names in your query then you should be able to change the...