Search results

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

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

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

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

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

Hi, Would it be possible to get the first word from a sentance. For example Peter James would Return Peter. John Michael would Return John etc. The first word could range from 1 to 50 characters. Regards Pete

Hi, can anyone help I use the code =Environ("username") provided by people on this forum to return the username of te person logged into the database. This works fine but... Wouldit be possible to create a function using this code to return the users real name. I have a table T_Staff with...

(Access 2003) Hi, I would like to have a message box pop up from my database. The problem is that i would like it to pop up at 8pm Monday - Thursday, 2pm Friday and 1pm Saturday. i have a text box on my form that displays the time using the =time() function. I have tried a couple of ways to...

Hi, I have some forms in my database that are in Datasheet view. These open fine wheni open them directly but when i open them from a command button they only open as a single record. Is there a way i can get them to open in datasheet view from the command button. Regards Pete

Hi, I'm trying to prevent a user from picking a status if there is no end date. I'm thinking that if i undo what they pick and go to the end date field they could enter a end date. It would be nice if i could create a message box to tell them that they have made an error aswell. I have the...

Hi, Can anyone help with a problem I have? I would like to be able to open an existing word document from a form in Access and when it opens display the Print Dialog box. I would also like to be able to have Access open the correct document based on a field on the form. If anyone could point...