Recent content by Mat1024

You are right, it is not the fields but the records. The strange thing is that only the beginning of the records (10 records) are mixed up. The following records are perfectly sorted... :confused:

I use the "Import External Data" Function of Excel, and then import the whole database.

Hi everyone, I have a strange problem: when I import data from access to excel, sometimes, the order of the fields get mixed up :confused: Example of normal order: 1 2 3 4 5 Example of mixed up order: 5 3 4 1 2 I don't know what is the matter, as it only happens sometimes. Can you help me...

Funds are our "point of entry" for any further data input. There is one record per fund. ...the thing is: we have a good thousand of funds with an average of 132 monthly data per fund on a huge, excel sheet-like table. I wonder how I am going to compile all of this, because for example, for...

Wow! thanks a lot for your advice. I'll try this and keep you informed. Thanks again!

You are right, the database looks like a spreadsheet. (cf. the 2 screenshots) Do you have any idea on how I could improve it? Thankyou very much!

[Function Series Based] Average only for columns? Hello, I am designing a form and would like to implement a text box with an average. I would like it to calculate the average of the value of different fields. But the average function seems to work only with one expression :confused: ...

of course.... thanks a lot! it works perfectly fine now! By the way, do you know how to put the combo box in read only to avoid adding entries by error? So that when you press a letter it goes to the entry (for example you press 'z' and it goes to "zanit"), without having the chance to create...

I need help, I don't understand the code you use: Private Sub Combo16_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[ID No] = " & Str(Nz(Me![Combo16], 0)) If Not rs.EOF Then Me.Bookmark = rs.Bookmark End...

Thanks a lot !!! This is an excellent source of inspiration.

Hi everyone, I am having trouble designing a page with Access XP (2002), and would really appreciate your help. I want the page to be used to add new entries to the database or to update the existing entries. I run the wizard, choose my table, select all fields, no levels, no sort order and...