Recent content by BrenoAguiar

That Worked good PHV! Bob, I have dif. items and dif. places that can be added or deleted by users. Also the value of the items are a sum or subtraction of another table, and thats the reason of the query. But I understood what you said and tried that primarily, but it would not work with other...

I have a cosstab query "cross1" that brings the result: placeID | 001 | 002 | 003 | 21 02 03 78 28 12 0 45 02 05 10 20 I have an unbound form with a combo box having the "placeID" options and another Combo box with the "items", beeing the items...

Thanks to Both of you guys! But since I have 8500 records, I can not specify the Name. But the first solution would work too with only certain names. But Thanks to Both ! Breno

I have a table like this: ID Name Bcode Ccode 1 John 211 212 1 John 211 301 2 mary 020 025 2 mary 020 056 2 mary 020 059 3 cathy 112 115 And I need to count the records to show how many times "John"...

Sorry.. forgot to paste the error. But was the [location] missing to ".Addnew". Thanks again PHV!

How can I edit the value of a specific field in a table through an unbound form. I tried something like that but it didn't work: Dim subm5 As Recordset Set subm5 = CurrentDb.OpenRecordset("pur_unit", dbOpenDynaset) With subm5 .FindFirst "location='" & Me.[location] & "'" If .NoMatch Then...

That was the problem. I removed the primary key from the Cleanup table and left only in the units table and it took care of the problem. I have to Preserve the data in the UNITS table, so I removed it from the Cleanup table. Added an autonumber field as a Primary key though. Thanks a lot!

Can you post the SQL of the one that you are trying to run? Or Is that the one : IIf(IsNull([colvar1]),Is Null Or Is Not Null,[colvar1]) IIf(IsNull([colvar2]),Is Null Or Is Not Null,[colvar2]) IIf(IsNull([colvar3]),Is Null Or Is Not Null,[colvar3]) ??

Well, The cascade option is unchecked. But the primary key is in the UNITS table and also in the CLEANUP table as the COmputerCode field.

Sorry.. here is the code: RunCommand acCmdOutputToWord

Panzer, you can try the "Output to MsWord" option int he Tools\Office links menu. You can generate the report in Access and once you bring the report you can hit the output option and it will go in MSWord format.

I have a form that it has been working fine to ADD data to the table "cleanup". BUt if by mistake the user types something over the field "computercode", it will mess up another table "units" that it should NOT! here is the SQL: SELECT Cleanup.ComputerCode, Cleanup.UnitCurrentGrade...

Thanks KNicks and Leslie. DUe to the circustances both tables talk one to many in both ways, what had to do with the design estabilished. BUt I liked the Idea creating a temp table and generate an autonumber field that would work for what I need now! Thanks a BUnch!

I'm trying to delete some records from my table "Btable" that has the same field [street] value in another table "owners". I tried: Delete * From Btable WHERE Btable.street=Owners.street and also Delete * From Btable Inner join owners ON btable.street = owners.street WHERE...

I have a table that looks like this: ID Name unit 1 john 104 2 Mary 301 2 Mary 302 3 Carl 405 3 Carl 407 3 Carl 409 And I was wondering If I can combine the "unit" field values, in another table/query...