Search results

Hi. I am converting a lot of queries to views, and i'm sort of in a gridlock on how to write this line in T-Sql: Sum(IIf(IsNull([dato]) Or [dato]>[Kursdato],0,[kapitalnedsettelse])) AS kapitalned In english: I want the field "kapitalned" to be 0 if the field "date" is null, or greater than the...

I am planning to use DSN Less. Then I dont have to bother IT in setting up connections. DSN i probably something I will ask about later :-) I got it working, but I think something is missing. My question that really bugs me... I upsized, and got it working. I wrote plenty of views and so on. I...

Thank you RX_ , once again :-) I will read your posts on the subject! One question. The database now works fine (from the looks of it). I've written a lot of views and so on, and I will continue to improve the application before I go live. BUT, lets say I am happy with everything, and "launch"...

Hi. I have finally upsized my backend to SQL Express. After some fiddling it went well. By now the endusers still use the access backend, and I am still testing the SQL backend. This post should probable be split in multiple threads, but I'll give it a shot here. Log form usage: I used to...

Thank you ! This seems to work quite nice! I really appreciate that you use your time to help newbies like me. Have a nice day !

I have attached a stripped down version. Use the form frmPortfolio. Change the combobox on the left side, and you'll se that the "SISTE kurs" changes accordingly. Try adding a new record.

I used to get the same error. To fix it I decompiled, then compiled, and it worked every time. Thats just a quick fix though. The reason for this error in my case was som faulty code, actually unrelated to the form that got corrupted. Have you done anything at all with the frontend (like...

Ok, I tried, but no luck. Its possible that I placed the code in the wrong place. I added that line to the combobox dirty event; Private Sub prodID_Dirty(Cancel As Integer) Me.Dirty = False End Sub That didnt work. I tried it in the subform dirty event; Private Sub Form_Dirty(Cancel As...

Here's the line it stops at. Set rs = db.OpenRecordset(strSql, dbOpenForwardOnly) The lines before is probably the problem: It tries to find TOP 1, but it is non-existent because its not added yet. How can I add the record BEFORE elookup does its job? strSql = "SELECT TOP 1 " & Expr & "...

Hi. I use Allen Browns Elookup instead of the dlookup. This gives me speed, and it works well, but it returns an annoying error. I have a continous form with financial holdings. To add a new record I simply press a combobox (name of box is prodID) and choose from a huge list. When I pick the...

Ranman256: Your opinion is that you can copy&paste the accdb file as much as you want, and this operation will NOT corrupt the file you are copying?

Hi. Will copying the database file while it is still in use, cause corruption in the original file? I've read numerous places that you shouldnt copy the file while it is being opened by another user because you dont know what sort of state the db is in. How to interpret that sentence? Is the...

Thank you RX! That was just the answer I wanted. Even if it were friday (now its monday:)) You gave me grounds to be very productive during the weekend. First some answers to your questions; DSN; To be honest, I have seen the name DSN, but it stops there. Is this something I should read up...

Hi. I have moved my data from Access to SQL Express, and linked the tables to the Access frontend. I have made views for the "biggest" queries that has a lot of calculations. Before I upsized, I restricted the amount of records calculated by using criteria from the customer form (frmKundekort)...

Thank you !!!!!!!!!!!!!!!!!!!!!

Probably a simple question, but I cant get my mind to the logics here.. :banghead: I have lots of products with changing prices. I need to get a list of all products with the latest price per product. I've done this in access with nested queries, but never in SQL before. I need a subquery (i...

Thank you for all your replies. I have now upsized to SQL, and the upsizing wizard revealed an error that might be the source of mye corruption issue. The primary key in my log table had autonumber, indeks Yes (Duplicates ok) turned on. SQL didnt accept this, obviousely. I changed this to no...

Hi. The backend is in the "common" area. Hidden. Never moves. Each user have their own frontend. I use the policy to copy the latest version of the frontend to the users desktop (still within TS). So when they log on, they have "fresh" frontend. The SQL server we are going to use, is located...

First to CJ: Both FrontEnd and BackEnd is on the terminal server. The only reason for my wish to upsize is to stop the DB from corrupting when the uses disconnects (and then often the server reboots due to no active connetions). This aint good. Is it wrong to upsize when the only reason being...

Which factors? What do you mean by replicating data?