Search results

Hey guys, Been a while since i've posted here. Things have changed since! hehe Well i'm using Access 2007 and i'm trying to do the following I have a general query that feeds from a table (in that table there's a uniqueID for every row) - Lets call it Query1 I have 3 other queries that "feed...

Access for some reason, when I delete the content of the Table TblPartsTracking, doesn't insert into or update anymore.... here's a sample of a code that i'm using to insert into: Private Sub cmdOkWO_Click() On Error GoTo ErrorHandler Dim strSQL As String Dim DelStr As String Dim varItem As...

Heh, It's funny how it can react. I didn't modify the code of my forms or anything. 2 on click functions used to work now it doesn't.. Only thing i did was compact and repair database... Weird And the Debug.Print Function looks good and have the right values... Hehe Weird............ Unsolved...

Sup, I need your help ladies and gentlemen. I need to do the following: I have the following Append Query: INSERT INTO TblTmp2 ( CustomerID, Line, PartNumber, Weight, WONumber, DrumsBoxes, CageNumber, Quantity, Fini, Épaisseur, PONumber, ReqDate, DateIn ) SELECT TblPartsTracking.CustomerID...

Hi, When I click on the button OkPack, I get type mistmatch... :( What I'm trying to do is: Take the last field in TblPackingSlip, Add 1 to it, then add a new record with the new value (which would be the last value + 1) and display the last value in a text box call txtPackNumber.. Thanks...

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...

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...

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...