Recent content by test2000

thanks guys, I will integrate your suggestions..

got it... Me.ListBugs.RowSource = "SELECT * FROM newSQL3 WHERE (newSQL3.BugsID NOT IN (SELECT newSQL9.BugsID FROM newSQL9))" just the job.. im happy now ;)

Think I am finally getting somewhere thanks to you... I have added the below to delete the query each time and it looks to be working. DoCmd.DeleteObject acQuery, ("newSQL3") Now I need to do the same, though this time for non-matching ... I have tried the below; Me.ListBugs.RowSource =...

Hi Jal, Ah, yes this is exactly what I need. Though as you say the queries are saved under a variable name. I have tried creating the query on the fly as you mention, and that worked once, though as soon as the code runs again it complains that the query already exists so cannot be...

thanks Jal for your reply, sorry if my problem description is a bit vague.. basically ... this would solve my problem, if it were possible(?); Me.ListBugs.RowSource = "SELECT FROM newsql3 WHERE newsql9.BugsID = newsql3.BugsID The issue is that newsql3 and newsql9 are variables from...

I have 2 variable newsql3 and newsql9, the relevant query is below; SELECT tblBugs.BugsID, tblBugs.DateB, tblBugs.Clarify_Case, tblBugs.DescriptionB, tblBugs.NotesB FROM tblBugs ORDER BY tblBugs.BugsID; tblBugs.BugsID is the keyID here is the relevent code; Private Sub IOS_AfterUpdate()...

Thanks a lot for the reply ScooterBug, I have now removed the 'DISTINCT' statement as it is not needed anyway (cut and paste error). I have a relationship as per below; #tblComponent..............#tblCardtoComponent............#tblCard_Types ComponentID...

thanks for the replies, Basically the reason that I am planning on storing duplicate data is because I have a Form for entering data, though a lot of data is very similar, so I have a Duplicate Button so that all the data remains the same, though a new record is created with a new KeyID. This...

Hi Experts, I need to copy all variables from a list box and place them into a table, I guess that I need to loop the below? the list box is called Sup_Card_List. Private Sub CmdCopyCards_Click() Dim sqlD As String Dim Value9 As String Value9 = Me.ComponentID sqlD =...

TOP MAN! didn't realise that there was a duplicate button, been thinking about this for ages!!! Thanks! That has fixed my initial issue though within the form there is a list box populated from a query which also requires to be copied which isn't happening at the moment.. any ideas...

Hi Experts, I have a few tables which are all linked to a ComponentID via relationships, I use a form to add and edit records, this works nicely. Though we have an issue that new records are very similar to old ones, so I want to be able to open a form (which is built on a query like when I...