Search results

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

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

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