Search results

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...

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. 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...

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...

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...

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...

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...

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...

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...

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)...

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...

Hi. I am going to upscale my backend to an SQL Express server because of corruption that occurs due to the way our network is set up. It is not possible for me to change the network setup. The backend is relatively small in size (5mb and growing). Its updated with the access frontend by 10-15...

Hi. I have a split DB, with frontend and backend within a citrix environment. All users work from within the citrix environment. We have an autodialer application (outside citrix). When i set focus to a number, and hit CTRL-ALT-SHIFT-D I automatically dial the customer. It's a nice function...

Hi. My application is made with MSaccess2010. It has multiple users, a split front end, and all users (and db) is on a citrix terminal server. This works great (enough). Backend accdb, frontend accde. However, I see the need to upgrade the backend to SQL server and keep the frontend in access...

Hi! I have a DB that is split to a back and frontend. The FrontEnd is published on a Citrix server, so is the backend. It works well, but I have issues with images in report. We have a lot of suppliers that demand that we use their standardized forms for entering customer information. Most...

Hi. I have a little "y2k issue". My DB has many (!) forms that are based on Crosstabs queries. The headers are years, and therefore my formfields has controlsources like 2014, 2015 and so on. Example: The table it comes from looks something like this: tblProject Project: Myproject Value: 1000...

Hi. I have a form with 80 - 200 rows of questions. The Questions has a field for username/agent, that the supervisor manually has to enter because of the way the db i created. How can I make a makro/function or something to automate this. Se the attached form for further explanation. I was...

Writing username to table onOpen and onClose in a form Hi. I am trying to make a log of all the different forms in my db. It is for statistical usage only, to se which forms that are often used, and which forms who are never used. Allen Brown has a great audit trail, but I cannot implement...