Search results

Sometimes a db gets corrupted. Try repairing and compacting. Also check joins etc in queries so that they´re still there. (They dissapeared for me once. Queries took forever.) Fuga.

I may be off base here, but it seems to me that you should look over your data structure. Do you really want the text to be in different fields? Fuga.

Hi, Is there a way to use VBA to check what connection you are currently using? Based on this informationk, I´d like to change the profile in Ms Outlook (see my other post today) so that if you´re on a modem, the emails would come from "modem@sweden.se" and if you´re on DSL, it would be...

Hi, Is there a way to change the default profile in Ms Outlook with vba? I would like to send emails automatically from a different user(profile) than I would do manually. Any thoughts? Fuga.

Thank you. Yes, it seems I´ve missunderstood the help. I thought you could only find the highest of (a1:a30). the thing is when I look at the results it looks like it only calculates 30 numbers. Is there a setting somewhere that I might have missed? Fuga.

Hi, I understand there´s a limit on the min and max functions to 30 numbers. How do I find the highest value among, say, a thousand numbers? Fuga.

Ok, so the problem is back. I´ve tried to export it as a text file, but it takes just as long. This is all very annoying. What is going on? Any computer should be able to handle this. Fuga.

Well it´s hard to know exactly what data you need to view, how you wish to enter it, what it looks like from the beginning e t c. However, from what I understand, you need two tables to store the actual data. 1. personal info about the student. This table chould contain a uniqe ID to identiy...

Thank you for your reply. The query extracts about 3000 rows from a table of some 200 000 rows. It has some joins etc, but the query runs sufficiently fast. It is the exporting that takes time. I know this because I did it manually. Each row has a date field, 3 integer fields and one double...

Sounds like you´ve run into a limit in access. Look it up in the help files and look over the design of your query. Fuga.

Hi, I´m exporting a query to an excel file and all of a sudden it takes forever. I don´t know that I have changed anything. I have both excel 97 and excel XP. The db is in AccessXP. Thanks! Fuga.

Hi, I´m trying to run a db in a97 on an XP machine. I´m having problems with the datevalue function. Now I know the date function sometimes malfunctions due to a references problem, so I'm thinking maybe this is the same thing. However, there are no missing references. I tried searching the...

Hi, When I run some procedures in a db, I get the message that the disk is full, and the computer eventually hangs. Of course the disk isn´t full, so there has to be some other explanation. Does anyone know what´s going on? Fuga.

Thank you all! Exporting it to another db - now why didn´t I think of that? I found a backup and replaced the form. It wasn´t all that recent so I lost some design and display features. However, luckily, the forms module mostly called on procedures in other modules, so the system was up and...

Hi, My mainform, which controls virtually all operations, has dissappeared. Since it´s supposed to load when starting the database, the form actually loads, but you can´t see it in the forms window. when I try to edit the code I get the message "module not found". What do I do? Thanks Fuga.

I think this is what Gregsmith meant. Sub clearlines() Dim lineX As Integer Dim mytext As String Open "c:\File1.txt" For Input As #1 Open "c:\File2.txt" For Output As #2 lineX = 1 Do While Not EOF(1) Line Input #1, mytext If lineX >= 9 Then Print #2, mytext End If lineX =...

Hi, I have an excel object ( a chart) on my form. On given time intervals the data in the underlying excel worksheet changes, and I want the chart to update on my form. Does anyone have any suggestions. I think I´ve been doing the right thing, but the chart just doesn´t update. Fuga.

I´m not sure about this. I normally write a macro in excel and then run it from access. But perhaps you need to have the workbook active in order to write to it with the "range" method. ex.activeworkbook.range(a1).value-- Fuga.

Thank your all. I´ll certainly look into the admin options. For now, I downloaded the redemtion.dll and it works, so I´m happy :) Fuga.

Thank you both. So the redemption is a library not included with office? that explains why I couldn´t find the reference to it. I think I´ll try the redemption. The clickyes solution is a bit too radical for me... :p But I still cannot believe that microsoft has done this without any method...