Recent content by PeteJM

Hi, Which is the best method for creating calculations? 1. Create all calculations in the Query and create a form based on that Query. 2. Create calculations in Unbound Text Boxes on the form. Would any of the methods result in the data loading quicker. For example if it was on the form not...

Thanks for you help. I can finish the report now! Cheers Pete

Hello, I'm stuggling to work out how to go about setting up a formula. I have 497 students 186 are Male 311 are Female. How do i work out the percentage of Male and Female students? I have no idea how to do the Math behind this so cannot start to add it to my database. If anyone can show me how...

Here you go. Regards Pete

A sample would be great. Thank you for taking the time to reply. Keep up the excellent work. Kind Regards Pete

Nice screenshots. Don1 Nice database, do you know where there are any examples/tutorials of how to achieve what you have done with the room allocations form. Regards Pete

Hi ozphantom, Thanks i was searching the forum for this exact answer it will help me loads with my reports. Thanks!

You could set the default value of the control to display your message and then set the got focus event to: Private Sub control_GotFocus() Me.control = Null End Sub Pete

That worked perfectly, Thank you very much for you help. Regards Pete

Hi, One one of my forms i'm using the following code on the After Update event of one of my text boxes. Me.SD_Knownas = Left$([SD_FirstName], InStr(1, [SD_FirstName], " ") - 1) What i'm trying to do is pull the firstname from a string of text. For Example my name is Pete James the above ode...

Hi, I have a database that stores name and address details in a table. There have been some data entry errors where a name has been entered twice. I can't make Firstname & Surname primary keys because there are occasions were some people with have the same name. What i'm looking to do is when...

The best way would be to create a form with a combo box that contains the months and a button to run the query. If you the enter Forms!FormName!ComboBoxName into the query in place of the [ ] that you are currently using it should work. Regards Pete

Hi, I can create unmatch quiries using tables but i don't seem to be able to do it using quiries. I want to look at the values in on Query1 and compare it with Query2 and return the results that don't have a match. Is there somthing different i need to do when using quiries instead of...

If you hold down the Shift Key when opening the database it will restore the database.

Hi all, i wonder if anyone can help. i have been using the following code on my forms. Dim lngWhite As Long, lngGrey As Long lngWhite = RGB(255, 255, 255) lngGrey = RGB(192, 192, 192) I use this to set background colours of text boxes. The problem is i am finding myself repeating these same...