Search results

I used to have that kind of problem, but since I started to use VBA in stead of macros, I haven´t seen it. Anyway, I seem to remember that there is a "pause" function somewhere that you can use in a module. Either here or in microsoft kb. Fuga.

In what way does the data differ on the machines? Fuga.

I didn´t quite understand the key violation problem, but anyway: If you put this in a module: sub runquery() docmd.setwarnings false docmd.openquery "query1" docmd.openquery "query2" docmd.openquery "query3" docmd.setqarnings true end sub then, instead of having macro1 behind your button...

I tried repairing the db. I´ll try the compiling (or is that included in the repair?) Thanks! Fuga.

Thanks for the reply. No, i haven´t deleted any modules (at least not to my knowledge). I deleted two charts from the form, and when I was about to save the changes, the error message came. Fuga.

Hi, I´m trying to save changes to a form, and I get the message "module not found". I cannot save the form. Does anybody know what´s going on? Fuga.

Since we´re on the subject. A while back I tried to change a field from double to single. The result was the numbers somehow got corrupted. (2.33 could be 2.33000000001 for instance). I never understood it. What did I do? And what should I have done instead? The numbers are not very large...

Hi, I have a db at one location, running a fetching operation every 15 minutes. Since I'm at a different location, I use outlook automation to send an email, telling me the db is up and running. This of course fills up the "sent items" folder quite rapidly. Sure I can delete them manually...

Make sure the field type is set to double. Fuga

:o Indeed, why not. I´ll try it. Thanks. Fuga.

Thanks for the quick reply. This is a part of a "data fetching" routine I use to get information from the web. Depending on certain things, the data will vary slightly, so that I cannot use one macro (in word, which I run from access). I solved this by making two copies of the downloaded text...

Hi, I have an error handler in a procedure which executes when an error occurs in the "main" procedure. However, the same error might occur inside the error handler, so I need an error handler inside the error handler. I tried to just have a second error handler, but you can´t do it that way...

If you are in design view when creating a query, you click the summation button up in the menues. This will give you some alternatives. Group by is default I think. Change it to "sum" for your amount field. If you choose view->SQL, this is a simplified version of what you want: SELECT...

Sounds to me that the balance is a calculated field. You don´t need to store that value. I would set it up like this: TBL 1 Transaction time/date (date) Transaction amount (double) + whatever info you want about the invoices To find the balance, you use a query. Fuga.

Hi. Normally I use the ldownload function to retrieve html source from the web, but I seem to run into problems when the page is a secure page (i e you have to log in). Even if you´re logged in, the ldownload doesn´t seem to get the data that is there. If I´m wrong on this I would greatly...

I seem to remeber a similar problem. I think it was because the code came to a stop before the .quit line. Fuga.

What will happen if you design your table so that the first field is a double, and then import the file? Fuga.

There are a number of ways you can go about this problem. Depending on what the data looks like, you can use Primary keys or validation rules of your fields so that the leading records are not imported into your table. You could also write a macro in word that deletes the leding 4 lines, and...

Make a query. sort descending on your autonumber field. then put "15" in the box next to the summation sign. In design view, that is. Fuga.

I will. Thank you for taking the time to answer. Fuga.