Recent content by CaptainBalrog

Hi there. Thanks for the response i will give it a try. Sorry to all about the multi posting. I kept getting a network error so i thought my post had not been submitted.

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

Thanks for the info chaps, i should be able to get it sorted now.

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, thanks for the response. I know what your saying about the design but trust me what i'm going to use this for does make sense, i just gave a bad example. I'm starting to get the mindset for access now i think, its hard to get out of the notes mentality after three years of it. Thanks again.

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 again. I got it working. I called the function to refresh the second sub form in the oncurrent event of the first one and it worked fine. I have been developing in the evil lotus notes for years and this is the first access app I have been given so I’m still learning what all the extra...

Hi again. Do you mean the main form should be bound? The sub form in question is bound to a query as far as I understand it. I made the query in sql design view and then selected it as the data source for the sub form. The reason I am using an unbound form is that it’s just the way things are...

Hi there. I did what you suggested but its not working as yet. Currently when I try to open the main form the sub form control is white. Any idea why that might be? When I click the button to enter something in the Link Master/Child fields I get an error saying “Cannot build a link between...

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