Search results

Create a table with two fields?

put the code in after update of the text box

"errors because my primary key "EmployeeNumber" has duplicates." You cannot have have duplicates in primary key. Take off the primary key icon from your Employee Number. What are the steps that you took? When you are importing the data in Access from Excel, it would ask you if you want...

on open and on current, lock all textboxes on click unlock the textboxes.

Have you tried exporting it to a ready made Access database structure?

Wait, is this on a form? Can you attached your mdb?

build a criteria in your query if field1 <> field2

Your join does not generate common data then. there must be common data between the two joins. do a left outer join if you dont care if the second table does not a common data. Ask the clip, what is left outer join query.

Call your table "Table1" then create a query, do not drag a table, edit the sql, paste this. SELECT Table1.Name, Table1.Type, Table1.Quantity, SUMALL.SumOfPrice FROM Table1 LEFT JOIN (SELECT Table1.Name, Sum(Table1.Price) AS SumOfPrice FROM Table1 GROUP BY Table1.Name) as SumALL ON...

nz function

Name, Quantity, Price, Type AC32, 755.95,13698, LM AC32, 320.89, 1736,EA but I would like it such that, Name, Quantity(LM), SumOf LM+EA, AC32, 755.95, 15434, Create a crosstab query, drag all fields name = group quantity where = lm price = sum

To refer to a subform's control if you are in the main form. Me!Subform1.Form!ControlName

http://support.microsoft.com/default.aspx?scid=kb;en-us;278376

Can you just another number field and update it? If binary value = blah, then update the number to blah.

what's your access version?

To check syntax, put this into the msgbox first before using it.

FIrst, your first two tables are incorrectly link. Second, I dont want to go further for fear of going nuts over your "relationship" :)

DoCmd.TransferText acExportDelim, "Standard Output", _ "External Report", "C:\Txtfiles\April.doc" search for Transfer text method

use nz nz(mynullfield, 0) Sets the value to zero in case your field is null.

IS the data in sequence? Does it have a record ID? What's the access version? HAve you looked at creating the pivot chart form?