Search results

Thank you all for your help. So I guess it´s no wonder I didn´t figure it out. I will try your suggestions and see how they work. It is supposed to run on a table with some 500 000 posts so it can´t be too slow. How about the IIF? Slow, right? Pat Hartman Is there a reason why Access and...

Hi. I have a query with three calculated fields. I want to take the highest value from those fields and use in another calculation. (Like max(a1:a3) in excel). I can´t seem to find a function for this, but there is one right? If I should use dmax or max in some way please help me with the...

Did it work? I´m a bit curious myself. Fuga.

Here´s something I fooled around with. This will combine the lines and save them in another text file. I´m sure there are better ways, but here we go. Be sure you have backup of your data. I just tried it with a few numbers, I don´t know what will happen with millions of text lines...

Are you sure you need to have tables for the team lists? It sounds to me like you should use only queries. Fuga.

You can probably achieve this in a number of ways. One way might be to have a vba loop. But if you´re not used to that (I noticed you are a new member), maybe you could do it with a word macro? How are you planning to know which row should go with which? Do they always come in pairs so that...

Do you have a table storing the links to the pictures? If so, just count the number of links in the table before you delete the file, like: If dcount(.......) <= 1 then kill...... etc Fuga.

I think that to have your data normalized means that you structure it in the most efficient way. This is quite an artform. Normalized tables would mean that they are structured so that data is not duplicated, doesn´t take too much space, isn´t stored unnecessarily etc....you get the idea. There...

To export a query to excel you can use this line. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, "name of query", "c:\dir\file.xls" Fuga.

I´m afraid I can´t get it opened. Perhaps someone else will be able to help. I noticed I´m not the only one who downloaded your sample db. Fuga.

I don´t know how much help I´ll be, but I´ll have a look later today. If you post the attachement here, more people will be able to help you. I use access 97. If you have it in a version I cannot open, please tell me more about what you want to do. Fuga.

The first thing you need to do is to decide what information you want in the db and how it should be structured. For instance, it sounds to me that you need a "customers table" and a "suppliers table", with whatever information you need. Be sure you have a primary key in the tables. Since, I...

I would look over the structure. Have you considered using 1st table person table: PersonID (PK) Name adress etc and 2nd table original payment table: PersonID (FK) orig pmt ID (PK) orig pmt amount orig pmt date and 3rd table running payments: orig pmt ID (FK) Pmt amount Pmt date This way...

Thanks for the info, Hooi. The 4th dimension is apparantly a good thing. What is it? Fuga.

Hi, I was wondering: What´s your general opinion about Filemaker. I´m thinking of learning the program, and I would like a comparison with access. for instance, what´s the equivalent to the VBA? Fuga.

Hi, Shariefoo. There is a wizard you can use to import txt files. You will be given some options as to which character separates the fields. That´s when you choose tab. If you click the advanced tab, you will be able to save your import settings (your importspecification), not only with the...

I have answered in the other thread. However my answer is in code rather than macro. My advise is that you use code. It´s actually a lot easier once you get the hang of it a little bit. Anyway, that´s my opinion. Hope it works out. Fuga.

Sorry, form_open is the name of the event. Private sub form_open() DoCmd.TransferText acImportDelim, "your importspecification", "your table", "c:\yourdir\yourfile.txt" end sub Fuga.

Yes, this is what i use. I use it as an on_open event, but of course you can have it as a button click event or what ever. DoCmd.TransferText acImportDelim, "your importspecification", "yourtable", "c:\yourdir\yourfile.txt" In "your importspecification" you choose the right options for...

You use File->get external data. Ther is a wizard there to guide you. Tab delimited is one of the options. Fuga.