Search results for query: *

Hi there! Sorry if this is the wrong forum, I have tried to get the right one; Simple question really, is it possible to perform calculations in Access such as having a list of companies and a list of figures from which I want to be able to find out the Lower, Median and Upper Quartiles of the...

Thank you all, works perfectly but do you know how I can remove any blank pages, the record will fit on the page but then page two is blank, page 3 contains a record and then a blank etc Any ideas??

Hey there, I was wondering if there is a way to print preview a form before it prints so then it would be possible to see what is going to be printed! I cannot find, using the wizard in access any wizard that will allow me to do this, is there another way?? Many thanks in advance! Powerhouse

Hi there, I hope someone can help me as I am at my wits end! I am trying to automate a boring process and below is the code I am using to do this: ************************************************* Workbooks.Add Sheets("Sheet1").Select Sheets("Sheet1").Name = "1995"...

MR Abdulla, I have been playing around with my forms and come across an annoying problem, after the user presses OK on the frmSrchCriteria form you created for me, the user is taken to a results page, On this page I have another button which simply opens the frmSrchCriteria form again to search...

Thank you it works perfectly, Once again you have sorted me out adn I thank you very much. Many thanks, Powerhouse

The button opens a form which is linked to a query which in the query design view, criteria row under the title heading has the following: Like "*" & [Enter a word from the title you wish to locate] & "*" From doing this a box appears when you open the form which the query is linked to in...

Mr Abdulla, Lovely proverb by the way! I wasn't sure if that code would work for the query in the same way as before it was taking information from a combo box, this time the button is taking information from a search box brought up by the query eg: [Enter Search Word] found in the criteria...

Hi, Is it possible to create some code in order to have a message box appear should there be no records to display once selecting a button which brings up a search box which will run a query? If there are no results at the moment it just displays a empty form. Many thanks for your help in...

Thank you to you both my problems are sorted and its all thanks to you! Many thanks, Kindest Regards, Powerhouse

Thank you to you both this has been most helpful, Zameer Abdulla, I have inserted your code and it works but is there anyway to get rid of the resulting message box which appears afterwards telling me that I have cancelled and OpenForm action? Thank you so much for your help though!

Record Source of second form: Central Sources 2004. I didnt understand the DCOUNT method sorry! Many Thanks Powerhouse

ZmrAbdulla, Sorry to keep bothering you, I have inserted the code in the right place now! It works fine but it doesn't seem to close the form, the message box appears just fine though - thanks. Any ideas? Many Thanks, Powerhouse

ZmrAbdulla, Thank you for your reply, I have looked at this thread and have inserted the code but I'm not sure its in the right place. Access is also telling me that my form is not based on a table/query so the recordsetclone function is not valid. I have included the code of the button where...

Hi there, I have a form with a button on it. This button takes the information form a combo box also on the form and retrieves the relevant journal details. The user is then presented with the appropriate details of the journal through a form not a report. In the combo box's list of Journal...

Hi there, I'm no expert but.. Is there nothing in the Format-cells-number/time or custom options? Powerhouse

Thank you to both this was very satisfying when I saw that it worked. You know your stuff Cheers again Kind regards Powerhouse

Hey there! I have a simple spreadsheet which works out how many hours you have worked in a day and how many hours this creates during a week and so on... e f g h b - a d - c e + f 3:00 3:45 3:15 7:00 10:00 3:35 3:00 6:35 16:35 3:30 3:25 6:55 23:30 4:10 3:40 7:50 7:20 Column E shows how many...

Sorry just realised this is not posted in the right place!

Hey there! I have another problem! Seeing as this site has been so helpful so far I though I would see if I could sort my next hurdle out!! - I am only having these problems because I have taken over a database and I want to improve it!! I have a combo box on a form with certain records in it...