Search results

  1. T

    Comparing two queries

    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()...
  2. T

    Copy query listbox into table

    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 =...
  3. T

    Copying Form data

    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...
Back
Top Bottom