Search results

First class... Thank you very much... Chris

I have to fields in a table: 1. Age 2. FullCost I would like a query to work out a discount cost to meet the following criteria: if age > 12 and Fullcost is > 100 then DiscountCost = Fullcost * 0.5 Can't seem to get this to work in SQL Anyone got any ideas... Thanx in...

Thanx me man! I understand now......at last. (It will only open the payments input form if the Members details form is loaded!) Thanx.again......Chris

I have inherited a database, i am now trying to fully understand it. The only problem i have is the there is a module called 'Global Code'. Can anyone please explain to me what it is doing exactly. Global Code: Function IsLoaded(ByVal strFormName As String) As Integer ' Returns True if the...

I have a database residing on our network drive at work. Is it possible to create a button (or something) on my desktop that when clicked it will automatically open a chosen report from my database. Thanx in advance..........Christy

I have a field in a table called money.... if i enter the value 2.5465 everything is fine. but if i enter 2.546532 it will round the number to 2.5465. at times i need to enter at least 6 figures after the decimal place. i have tried changing the properties in the field many times but the...

I have a query with field called MemberAttend..... This field tells me if a memeber attended a meeting. The only options for this field is 'Yes' , 'No' , 'N/A'. My question is how 'in a query' can i count the number of Yeses i have. Any help would be great.................C

I have form which records scores for a round of Golf.....How can i add the scores for the front 9 and then the back 9 and total them up. I need them recorded in a table. So on the form for each player i can see their front 9,back 9 and total score. Any help would be great.............C

I have a main menu that is maximised and thats fine. I then have a members forms that pops up in front of this main menu and thats also fine but now that i need another form (committees)to appear in front of the members form i ca'nt get it to work. Main Menu form is maximised......Memebers form...

I have an assignment to complete for college and i need to produce a report in my Db that will show the top 5 best scores from a golf competition. There could be 30 entrants to the comp but all i need is to show the best 5 scores in order of best first. Any help at all would be great..........C

I can use code to do this no problem.......i have to do it this way for college and i hav'nt a clue about macro's....... .............. Cheers...........C

Can someone please tell me how i can do the following.........I have created a button on a form.....When i click on the button i would like todays date to appear in a text box i also created (The text box is DipatchDate)....... Thanx for any help...........C