Search results

i tried that but the row changes so one time it would be row 28 or maybe row 9, all depenidng on which coleague is trying to use it

Hi All i have also posted this on a dedicated excel page but havent had much luck with help or sugestions so hope you dont mind me posting it here to, here is the link to orginal post Orignal Post On Excel Help Forum so i have a file which is attached and once someone press's filter(...

Cheers Jon (y)

Hello All with it being Easter and been doing my best over the past year at work ( where i currently am ) i have updated the Quiz-A-Rama one last time code wise and also with some new questions for the Easter hols. The code update, fixes the issue when someone would press the give up button on...

your code works then it dint, says error and then when i debug it says Null in the lookup section would i need to refresh the form after each update please see attached copy of db with your code edit so compacted and repaired it again ( twice lol ) and it seems to work if you choose from the...

not been ignored working on both but got called away thanks for the input :)

see example attached, no only one combo box

cheers for that it half works as it shows correct when its vendor owned but when they be different in each it shows both, see example image "Should just say JS Owned"

Morning you lovely people, have been looking at this StrComp Function and i think i understand it but i cant seem to get it to work, please see my code and explanation below Private Sub cmbSKU_AfterUpdate() Dim LResult As Integer Dim LResult2 As Integer LResult =...

sorry for DP but did a quick google about bind/unbound forms and found this aweseome site hehe binding subbforms and have fixed it cheers all

i didnt set it as unbound just used the create a subform wizard

just tried to link master fields and Computer Says No :(

so how would that look like as i wnat to filter down the subform so would it be someting like and this is very bad air coding subform.path.filter = mainform.combo12.value

thanks for asking this question and posting many of your soultions, i myself have treid number 8 but it dosent seem to work for me i took your code and changed it to relflect mine of course which looks like Forms![Form1]![tblMain_SubForm].Form.Filter = "[FileName] = '" &...

did you not see my attachment, it worked cheers all

cheers i just googled that and mapped teh shared drive again with no drive letter and i have now got this

Hi All i have a split database which we have just moved to a new shared location but the split hasnt seem to have worked i use the split database function in access and what is attached is how it is linked but it should be like the one marked correct any ideas on how to get rid of the...

thanks for this was pulling my hair out trying to get my back end re linked :)

cheers the code did work it was my fault, bangs head. was trying it on a copy of the form and hence the name for the form wasn't the same :) cheers all

huh, what do you mean check and substitute, if your asking if they are spelled the same then yes they are