Search results

Hi there. I have inherited a crazy old database. It has a payments table with multiple instances of supplier code and supplier name. I need to build a query that returns a single record for each supplier code and name but in some cases the supplier name is spelled differently so using DISTINCT...

Hi there. I have inherited a crazy old database. It has a payments table with multiple instances of supplier code and supplier name. I need to build a query that returns a single record for each supplier code and name but in some cases the supplier name is spelled differently so using DISTINCT...

Hi there. I have inherited a crazy old database. It has a payments table with multiple instances of supplier code and supplier name. I need to build a query that returns a single record for each supplier code and name but in some cases the supplier name is spelled differently so using DISTINCT...

Hi there. I have inherited a crazy old database. It has a payments table with multiple instances of supplier code and supplier name. I need to build a query that returns a single record for each supplier code and name but in some cases the supplier name is spelled differently so using DISTINCT...

Hi there. I am just wondering why the property sheet for the activex calendar control in access 2003 has only a few events but when you go to the code builder you have all kinds of events to play with. The reason i ask is that i wanted to use a function of my own when a user clicks a date...

Hi there. I have a form and on open it traps the user into a combo box where an option must be selected before they can move to another field. I did this by using the lost focus event of the combo to check if an option has been selected and then return the cursor to the combo if no selection...

Hi there. I was wondering if its possible to emulate the way lotus notes views work using a query. Say i had three different tables for three different order types and each table has several common fields like datecompleted,amount and customername. Is it possible to create a query that will...

Hi there. I have a form with two sub forms on it. The form loads with a reference number that I pass to a function that in turn requeries the first sub form. The function call is in the on load event of the main form. This part works fine. The second sub form uses a similar requery function to...