Search results

DONE IT I had to change the bound column from 1 to 2 now it seems to work ok.:D

OK, no worries. Thanks for your time.:)

I've just changed the names to box1 and box2 so the code is Private Sub box1_Change() Me.Box2.Requery End Sub I've also changed the SQL to suit.:) Cheers.

Forget that last one I've just changed the names, However it still does the same. Also I don't know if this matters but some records in the table don't yet contain a subMCGRP. Would this matter or would I be able to just pick the blank space in this case. Sorry.:confused:

Yes, Obviousley this is a problem:eek: , Erm....... The form was inherited, how do I change them:confused:

Here is the SQL, erm. SELECT DISTINCTROW [Asset Data - Cleansing].mcgrp FROM [Asset Data - Cleansing] GROUP BY [Asset Data - Cleansing].mcgrp; SELECT DISTINCTROW [mcgrp], [SubMCGRP] FROM [Asset Data - Cleansing] GROUP BY [mcgrp], [subMCGRP] HAVING ([mcgrp]=[Forms]![Asset Data - Cleansing...

Nearly a star It would seem that, whatever I pick from the list, only the first item in the list is displayed. Sorry to be a pain:confused:

Thankyou Thankyou, what a Star!!!!!!!!!!!!!!!!!1:) :)

Nearly Now I get a list that relates to the other one but I have some blank spaces and a lot of duplicates.....

Not quite right This is nearly right, but all I am getting is a choice of what was selected in the first field.ie. If CADM was selected in the first field, Then I get a choice of CADM,CADM,CADM,CADM,CADM,CADM etc.:(

Limit options in list 2 Cheers Harry, But I am trying to make it so that the options are limited to what has been selected in the first field. If this is what you meant how do you do it:D

I have two fields in a form which are linked to tables forming pull down lists. however these fields relate to each other and I am trying to make it so that if you pick an item from the first list, the second list only lets you choose items that are related to that list eg:- CADM FRIER CADM...

Cheers. The format was dd/mm/yyyy. English layout.;) No worries it worked a treat.:cool:

I have several dates in the format 01/02/1999. All I need to know is how to add seven days to this date so it reads 08/02/1999.?

I have a problem where by I need to change values in an access table which actually represents a date, they are stored like yymmdd, I have preceeding zeros to represent 2000 etc...ie. 000101 = jan 1st 2000. The problem I have is when I try to convert these dates into a new field name using:-...

Thanks very much, works like a dream.

Next problem Excellent!! The update works superbly. Now the next thing I need help on is when I try and change the field type in the design table view from long integer to a date time format, ie yymmdd. Instead of simply updating it how you would expect. It changes the values to eg. 751456...

Attached is a copy of what I'm trying to do.

If I wanted to update a value in an update query from 1000101 to 000101 how would I get access to display the preceeding zero's.:confused:

This gets me a little nearer, however I need the Job ,sub, and lineNo in one row and all the text in one cell, the code you gave me only clears every other cell under job and sub. :)