Search results for query: *

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

Thanks Both. I can add that on a SUB too!. Thanks guys.

I was wondering if there is a way to put on a excel spreadsheet a Function (or maybe a formula) for this problem: For every $100 add $5.50. Example: If I get $100 the result should be $5.50 If I get $157 the result should be $5.50 If I get $200 the result should be $11.00 If I get $201 the...

Awesome! I was trying to understand it before the typo... But it works great now. Thanks PHV!

The media_cd IS a numeric field so I removed the single quotes. What I have now is a "Compile Error - Method or data member not found" and it highlights the = rs.Forms! I tried the Brackets but no success neither..

I'm having a problem with the following code that it seems to work but it does not find and Display the field searched. This is a form that you update records and once you submit the changes, it requeries another form and it is supose to find the record updated. here is the Code...