Recent content by DomZ

I can guarantee you, even so that the wizard choses the fields for me... haha

Yea, i've created a report using the wizard and i added a subreport to it. Now when i have both linked the master and child fields from Query1 and Query2, when i preview 10records from the report, the subreports shows all the records from Query2... Am I missing something?

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

UPDATE: I updated office xp to SP2 and it seem to have fix the problems on 2 of the 4 computers that had problems.. Thanks for your support mates

I did try what you said... No success... :( What i'll do is prolly leave it as it is and delete all the records except 1 and replace it manually and continue working with it.... however, never had a relationship between both... always worked.. and even before I did reset the table couple times...

Ok I'm doing this EXACTLY: Now the TblPartsTracking Has some test parts that I entered. If I use them through my DB it works fine. I can use my SQL Statements well. NOW: I delete the content of TblPartsTracking, Meaning I open the table, select all the records and press delete. I open my form...

well, What I do: I delete the content, then add a part to that table using a form I made, and then run the code.. Doesn't work

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

UPDATE: I finally got it Here's how i did it SELECT First(TblPartsTracking.CustomerID) AS FirstOfCustomerID, First(TblParts.Line) AS FirstOfLine, Count(TblPartsTracking.PartNumber) AS CountOfPartNumber, Sum(TblPartsTracking.Weight) AS SumOfWeight, TblPartsTracking.WONumber...

Hey pat Thanks for replying. Only thing i don't understand is this statement. could you please explain yourself? 3 more things: 1- What you would select in Query1, what Field from TblPartsTracking? Basically Everything, except that PartNumber would be treated as Count not First right? 2- Does...

Bump

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

LOL sorry pat, i have a headacke and I was thinking about a paul when i wrote the msg Thanks got it working