Search results

I use an ADODB.Connection object but i referd to it as "pubObjDatabase" out of old DAO habit since it stores the same values as i put supply to the DAO database object. Public pubObjDatabase As ADODB.Connection I do make changes at runtime (not when I've deployed something but while...

Thanks for the response. I tried to produce a clean example and modified the code directly before posting so it would just show the most interresting part. The other object i refer to did exist in my code so it was declared but it should obviously not have been there. I don't like the with...

Hi! I've banged myself into a tough headache and was hoping that someone would be kind and show me some light. For some reason i've had to make an update on some old VBA projects of mine. In this update i switch all references of DAO to ADO. I know there are some limits to what i can...

Thanks! It does work like a charm but it feels like cheating to use a function almost as using VBA by which it would be possible to retrieve whatever value you'd want I eventually got my head around it and managed to produced a pure SQL expression which provides SELECT tblColors.Color...

Hi! I'm trying to create ONE query which would fetch me the number of occurences on a particular value in a field while keeping duplicates. For instance let's say i've got the following table Color......Value Red.........5 Red.........8 Orange....1 Then i would like to have the following...

I’ve built an Excel front end application that uses a back end access database. The purpose of this application is to work through prospects. In the application there is a distribution functionality where users are provided with the next best prospect to work with (for instance by using estimate...

Hi! I'm working on a project where users are interacting with an access database through a collection of userforms in Excel. I've got an issue with a query that I try to run from a sub routine in excel. The query works fine when i runnit i access but when i try to execute it through a database...

Thanks Pat! The overall aim with the query is to find out if the first device ID (which is the device label) is unique or if there are several devices (the second ID is uniqe for every device) which use the same label. Pending on the outcome i'll use different scripts for uploading some...

Hi! I've got a problem that I'm to frustrate to solve or let go. Was hoping someone here could help me with it. I do hope you'll have some patience with me if this is very basic stuff that I shouldn't be bothering you with (I've just recently begun to work with Access and SQL). Anyway I'm...