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

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

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

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

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

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

Hi there! Please would anyone be able to tell me what I can do to close Excel itself and have a related Access database form open on the closure of Excel - as the Excel is a link from the form but I want to go back to the form after making alterations to the workbook. Thank you in advance...