Search results

Give us more information

Well first is that you would need to select some Fields and then join them.. either using inner, left or right join... For the rest then, you can use that query as a record source of a subform or form for instance

I have a query that populates some information. I need to narrow the information. I have a list box where there's some info in it and I want the CustomerID, which is column 0 in the list, to be the CustomerID that the user selects from the Listbox So what would be the part in bold? WHERE...

well, basically: My list box has 3 columns: CustomerID, PartNumber and DateIn. it takes this information from TblPartsTracking. Now, When the user selects some parts, lets say XZV-01892 and XZS-0092(Yes my list box has multiselect set to true) from the list box, which is the second column (#1...

See below

Hey everybody, What I want to do is when a user selects a couple parts # from the list box, some of the information from TblPartsTracking, TblCients, TblParts will be put into a tmp table so that a report can use those... I have been able to create a strSQL as follow: strSQL = "INSERT INTO...

Sup again, How is this possible: I have a table and I want the user to use informations from 2 other tables... My relationship and layout is as is as follow: TblClients: ClientID CustomerID (PK) Address ShippingAddress City Province Country PostalCode PhoneNumber FaxNumber Others TblPieces...

Sup ppl I have a form where there is 2 combo boxes and 1 list box. What I want to do is when a user selects 1 date in combo box and 1 date in the other combo box(the first combo box always has to have the oldest date), all the pieces that are from the first date, selected in the first combo box...

Thanks for replying What do you mean exactly? Really need to get that working.... It is one of the main key in this database

Hi, (Using Access 2002) I've used both http://support.microsoft.com/default.aspx?scid=kb;en-us;209576 and http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/wc080300/wcblurb080300.asp to try and make synchronized combo boxes. Here is my problem. Here is the layout of my 2...

dunno if this could help but here's the combo box survival guide http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/wc080300/wcblurb080300.asp