Search results

I'm doing a query which filters records of people that are aged 18 - 25. This works fine but I want to to a query which will retun a range of ages as opposed to just one age bracket. When I run this query it will only return the ages of people ages 18 - 25. I want it to also return ages 26 -35...

Hi all, Heres an interesting one, Some of our Sales people are sumbitting duplicate credit cards applications to us. They are submitting an application for a blue card and a red card for the customer (hence they get paid twice). This is against the rules and is hard for us to detect. Here is...

Hi, Someone sent me a spreadsheet with about 4000 entries. Anoyingly they have enter the date of each record as yyyymmdd format without spaces. In order to import this information to the database I need to convert yyyymmdd to dd/mm/yyyy. Does anyone have any ideas how I could convert this...

raskew, That doesnt seem to produce what Im after Ill try and make this even more simple - A simple table with two columns: tblMain Name | DateOfBirth ================== John Daly | 02/01/1950 Mark Holeman | 06/08/1955 Sarah Good | 23/12/1957 Pat Redmonde | 11/04/1959 Nob Relling |...

Cheers Mile, thats exacltley what I did.. now it gets more complicated. The two tables now look like this... The new entries in bold are the birthdays of the applicants. I need to filter the querie by age of the applicants. The ages range from 18 years to 70 years old. I am using the...

Cheers I give that a try now :)

Thanks mate. I already have a postcode server set up. Thanks anyway!

The table is on an SQL server. I'm using an ADP file. How do I change to 4 part year digit in table design view?

Hi all, When I enter a birthday in my form as 01/02/09 it enters it into the database as 01/02/2009 but I want it to be 01/02/1909, Is there a way of making sure that access never enters dates that are this century? Should I change there field types to text instead of date/time? Thanks

I have two text boxes, one for the area code and another beside that for the phone number. When the area code field has the focus I want it to hop to the phone number field when I press space bar.

Thanks

Thanks m8, that works great but It's not exactly what I'm trying to do. Ideally the whole label box background would turn white as shown in the screenshot above. Would you have any suggestions? Thanks

Complicated querie (for me anyway) Hi folks, I have been asked to run a querie on a huge chunk of information in order to get statistics and performance on our Sales executives. I will try and describe and simplify what I am trying to do. We employ sales people in various airports around...

I originally had an normal access database and then I split in to SQL and an ADP file. I have a combo box on my form that looks to the SalesExec table and puts the Forename and Lastname into one column in the combo. The row source looked like this: SELECT tblSalesExec.EmployeeID...

I have thousands of records and in one field all codes start with 10.... I need to remove the '10' from all records. How can I do this? Should it be done in a spreadsheet or can access do it?

Fantastic, thanks

When the user clicks on a text box that already has text in it, it should select all text automatically so that they can just type over it. I tried this Private Sub txtCurrAdDOR_Click() Me.txtCurrAdDOR.SelText End Sub I get an 'Invalid use of property' error

For example, when the user is in the Title box the area turn white. This make it easier for them to see where they are. I was going to set each text box with an 'on focus' event to change the backround of the give area to white but this seems time consuming.. any ideas.

If a certain event happens it will change the enabled property of an object eg. If me.txtAge < 18 Then me.txtName.Enabled = No Any ideas

If I click the dropdown box there is more than one result. How do I get access to fill the various text boxes with the reult that I click?