Recent content by grae.uk

awesome thanks, got it working with that! Much appreciated :) G

Hi guys, I have a database that I am working on where I want to create a button on the form that will take 5 of the fields on that form and enter them into another table that is storing a few pieces of the same data but working with another part of the system....and then open the form with the...

not sure that will work because the whole thing is part of a big block of code...let me post that.. Private Sub searchDBButton_Click() Dim stDocName As String Dim stLinkCriteria As String Dim vWhere As Variant Dim x As Integer x = 1 DoCmd.Close acForm...

Hey Neil, Thanks for the reply....sounds good but I am VERY new to this still..and not sure what you mean by design grid...? Thanks in advanced :) Graham.

Hey Neil, Thanks for the reply....sounds good but I am VERY new to this still..and not sure what you mean by design grid...? Thanks in advanced :) Graham.

Hi, I am not sure that the Group By function does what I need it to do..group by just seems to group them together for output. I just want one of each person record... Cheers, Graham.

Hi Jal, Thanks for the reply. The code i put in the post actually works as I expect it to, so not sure about the double filitering thing...I have to confess it is just modified code from another query that works fine and has the same vWhere in both places... So at the moment no, I don't get...

Hey, I am new here but read through this Vista rant and had to post. I think I am possibly one of the very few that really likes Vista! (no i don't work for Microsoft! lol). For me it has been stable, Wireless is always brilliant, it is fast, I don't have any programs that have a real problem...

So this is like leaving a wall post on facebook! except everyone can read it!! :)

Hello, I have a strange problem that I would appreciate some help with. I have a query that is basically search a table with one linked table and I need to use the DISTINCT command as there is possibility of duplicate results. However as I understand it with the DISTINCT command you can only...