Search results

The pass-through query contains only the actual value that is sent to the server. So in order to change the content of the passTrough I change the sql so that the right rgID is present in the PT. This is the content of the PT: exec dbo.SP_rgListe @rgID = 1; When I say ".close" I dont think I...

I am wondering if I am closing/cleaning up a connection properly. I have found that over time this functions gets into trouble. First it gets slow, after I while I get "unrecognized database format" and other nasty messages. The database itself is not corrupted If I close the application and...

Hi. My application is generating a lot of PDFs from template files, and get data from an msaccess form. This is done with VBA. This works quite nicely, but I get into trouble when I want to get data from a continous form. Only the first value end up in the PDF. This makes perfect sence due to...

I tried this approach without any luck. This is absolutely doable, but i end up knocking med head against the wall in the naming of the secondary ctl (the one's one the subs). So, for a quick and dirty fix I ended up doing the same loop 5 times for alle the different subs. For Each...

And a new problem occurred..which probably is an easy one. The button that calls this is on the main form. The actual data is in 5 different subforms. The code worked when i called it from the form that actually contains the control, but I dont figure out how to deal with the controls on the...

Thank you very much, you are absolutely right! It gave me a new error in the adobe file itself (xml parsing error: not well-formed (invalid token) (error code 4), line 5 column 13 of file). The reason for this "token error" was how I used quotes. So when I changed it; Print #intFile, "<field...

Hi. I am filling out a PDF based on values in my form. The form has 5 subforms, with a lot of controls on each. The code works today, but it takes to much time to change. The idea is that i reference each field in the form (each textbox control) by its name, and then i name the pdf field the...

Hi. I have som problems grouping a mssql view. I have a few thousand accounts, and I have about 4 different types of portfolios. These portfolios are identified with "kontotypeID" these portfolios consists of hundreds of instruments each with a marketvalue ("markedsverdi") for the account. I...

Hi. I always decompile when I make a change that requires republishing the frontEnd. So there shouldnt be much rubbish code. I deleted all reports, forms and macros now, and ended up with 7mb file size. That probably means that the queries take up 7mb and the rest took about 35mb's. So back...

Hi. Thank you for your replies. I guess this would be time consuming, and I probably need to take on form at a time. In general: Is it so that a query takes up "zero" size in the db when not in use? If so, then I could leave the queries. Forms and Reports has logos, pictures, and all kinds of...

Hi. My db has too many objects that is not in use. I would like to remove probably half of the queries, reports and forms, cause I suspect they are not in use. Is there a simple way to figure out which objects that has "no connection" from the spashform? The frontend is about 40mb large, and I...

Hi. Thanks to you all for the advise. I have tried some different solutions, and found that "weak" relationships (just a bunch of relationships between the tables) actually works. The purpose of this database is basically to give me fast way of finding connections between people, property and...

I am working on a database to find "common ground" between persons of interterst, real estate and company ownership. This is of an investigative nature. I have tried to google a solution, but the words relation and database gives trillions of hits, but no hits (i can find) with the kind of...

Excellent! I had to add "is nothing then", and it now works like a charm! Thank your so much, and I wish you a great evening! Do If Not (IE.Document.getElementsByClassName("ftqbb ftqw2 pid-59-bid")(0)) Is Nothing Then dd = IE.Document.getElementsByClassName("ftqbb ftqw2...

Thank you! The code works, but in the same way as before. If the currency has no change it works, if its the green or red, it gives me an error. I get an error on the first statement when this is the case. Run-time 91 "object variable or block variable not set. Perhaps it is not an "is null"...

Hi. I use a function to look up a currency value from a webpage to do some realtime calculation. It needs to be realtime, and this restricts possible sources online. I have a function that works alright, but it has some flaws I would like to address. The class changes names depending on if...

Once again, thank you! I got the logfile to work with a combination of dbAppendOnly + dbSeeChanges. Think i'll mark this as solved. We are now live and kicking !

Hi RX_ I just want to say thank you for all your help! I have studied up on the mitigation, and I believe I have a solution that works out now. First, I will use DSN Less, but not use the onload event since it slows down opening the application. It will remain stable for a while, and its fairly...

Thanks guys, you really helped med out. Some small tweaking, and it seem to work now. Now I have to do this with the remaining "hundred" lines or so :-) The end result; CASE WHEN dato > kursdato THEN 0 WHEN dato IS NULL THEN 0 ELSE SUM(kapitalnedsettelse) END AS kapned

I know the basics, but have problems combining case, OR and isnull.... In access i can "change" the operator, but not in SQL. I am looking for an example of these three together. Example in the line underneath, where dato isnull or bigger than kursdato, then kapitalnedsettelse should be zero...