Search results

Thanks John. I have created it in the way you posted. It was the most simplest and I can convert the results at a letter date now with the simple query. Do you know if it is possible to totally uncheck the option buttons in an option group if you dont want anything selected? because when I...

thanks John, grpBath is the option group. I will look further into your sample. thanks for your help on this.

Cheers for your replies. What I really want is what Bodisathva has helped me with, changing the values to words in the fields that show up in the table. I need it because I will be using them values to transfer to a total different system later in the year. All thats happening now though is...

Thats seems to be working now thanks BUT on the form now there is no black dot appearing in the option buttons. They just seem to have a grey scale and when the form reopens they are all selected. Any ideas????????

Private Sub grpBath_Click() Dim strCondition As String BathCondition = strCondition Select Case grpBath Case 1 strCondition = "Good" Case 2 strCondition = "Fair" Case 3 strCondition = "Poor" Case Else...

Is there anyway Rod to have the option value changed to a word instead of an integer? Or the value to change to a word once it is stored in the table? This is so the when I run a report from the table I can have the value in the [Bathroom Condition] field to read "Fair" instead of an integer ie 2.

Thanks rod. Ill have a play about and see what I can find!

Hi peeps, I am encountering a few problems when I'm using the options button on a form. Is there a way for the options button to display a different value instead of a -1 when the data is transfered to a linked table? i.e Good or Poor or Fair? Also can a number of option buttons have the same...

Thats great thanks. My solution is: If FrontDoorType = "N/A" Then FrontDoorColour.Enabled = False FrontDoorColour = "N/A" Else: FrontDoorColour.Enabled = True End If This changes my second combo box to disabled and has the value N/A. The value is changed to...

Hi people i once again need your help! What I would like is for a combo box to disable if a certain vaule is entered into another combo box. I have a combo box [FrontDoorType] and when the vaule is N/A or blank then the [FrontDoorColour] combo box is disabled. Have tried using the conditional...

<DateAdd('yyyy',-18,Date()) This subtracts 18years off the system date. I used this as the Date of Birth on the entry form had to be valid to 18years old or older.

As if it was that simple. Very well done.

Is there a way where you can send the data on a form to a detination table without closing the form????? It's probably the easiest solution but it's 4pm and nearly home time so a memory blank is upon me!

Thanks people. I have it working now

Hi Guys, Does anybody know the formula for validating a date in a DOB field. I want it to only allow dates where the age is at least 18years old. Something like '<Date()-18' (But a formula that works!) Thanks in advance!

Much appreciated....I will get the hang of it one of these days!

Hi guys, Still trying to get used to this Access lark. A table contains a column with numbers i.e - 1,1,3,4,2,2,2,3,4,4 If i just want a query that shows one of each i.e - 1,2,3,4 what do i need in the criteria line? Thanks in advance

Hi there, I have 4 fields in a table(Call_Freq, Call_Week, Call_Day, Call_Sequence) I have to make a query that finds records with Null values in these fields. If they are all null that is fine so I only want to return records with either one, two or three of the columns with Null values...

I posted two by mistake sorry. Thanks for your help.

I have a report in Access run against a query. I am wanting to return all the rows that start with 'F' coloured RED. All the others just to stay as they are. 'F' is an ID and every row starts with a single letter. Do you have to do this in a VB code or is there a function in Access that does...