Search results

Hmmm..... I can´t find the reference to atp.

Yes, I read it. I´m not sure I understood it though. The thing is I use the stdeva function on the previuos 1000 rows in excel. My experience is that whenever you calculate something on previous rows(posts) it takes a lot longer in access than in excel. Do you think I should try the ATP?

Hi, Is there a difference between the statistical functions in access and those in SQL server? For instance, is there a median function in SQL-server?

thanks everyone! I'll have to think about how I will go about it. But for the record: access can´t import that kind of formulas?

I´m not sure about this, but try the syntaxforms!bookings.night Also, you might want to consider using the me object. As for the prise field, I´m not sure where you mean the value is? Is it on the bookings form?

will you be ok with having to "ok" the actual sending? I think there is a security thing that prevents outlook from actually sending the mail. You can solve this with the redemption. http://www.access-programmers.co.uk/forums/showthread.php?t=92015&highlight=automate+outlook Does anyone know...

Hi, I´ve linked an excel sheet to a table in my db. The sheet contains some statistical functions. However, the value of those functions do not link properly. in stead I get a #num! in those columns. How do I link the value of those formulas? Thanks Fuga.

Hi, I´m trying to build an application for my db. I´m using a datagrid control and I want the Autonumber field(PK) to work. As of now, the field is not incrementing numbers, making it impossible to add records to the table. What do I need to do to make it work lika a table in Access? Should...

Thanks! I´ll try that. Do you think that will help with the return character as well? Fuga.

Hi, I´m using the open for append method to write to a text file which is then converted to an xml file. I loop through some lines in excel and for each line I´m writing it to the text file. The problem is every string begins with " in the xml and ends with the return character. This means...

Hi, I´m thinking of building a program in VB that uses an access db for data. what programs does the user need on his computer? Does he need access? How should I distribute the application? Fuga.

exactly! I can find the paragraphs in the original text, but once I import it into access, well... I suppose I could include some crazy letter, representing the carriage return, and then somehow replace it before the text field on the form is populated, but really... I just can´t help feeling...

Thanks for your replies. This is how I mean: I can store this in a text field: 1 cat. two dogs. 3 chickens. But I want to store it like this: 1 cat. two dogs. 3 chickens. Actually I don´t care about how it is stored, but I don´t see how I could display it like this otherwise. Any...

Hi, I´m developing my first web page using visual studio. I have connected to an access db, and it works fine. But now I want a text field that can display blank rows, so that the user can identify sections in long texts. I´m not at all used to having text fields to deal with, so this might be...

In SQL, you use the "top" statement, combined with the method of sorting. select top 3 ....... order by .....desc. In design view, you click the summation sign and enter the number of records you want shown. Make sure you have the right sorting too. You will also need to include your where...

well, the problem came back. It´s all very strange. When I open the module and hit f5, the process works. But when I call it from another module, it doesn´t. Very annoying. The whole db is quite useless without it. Could it be that the computer can´t handle it? Fuga.

Well, now I have, and it works! Thanks.

Thank you both very much. I think I solved with a workaround. Excel really wasn´t quitting, so I had to set it to nothing in the middle of the process, and then creating it again. What puzzles me is that I´ve never had this problem before... Fuga.

I think so, but I´m not sure. If I haven´t, would that cause this behaviour? I´m not at work right now, so I can´t check. Fuga.

Hi, I have a graph which uses the value of two combo boxes for beginning and end parameters. In order to work, the datevalue() function is used. When i design the rowsource, it works. But when I exit Access and open it again, it doesn´t. Then the rowsource is either wrong or too complex. What...