Search results

Maybe you make a mistake somewhere.

For Sum on Column, look at "DemototalSumA20022003.mdb" (attachment, zip) Open form and see. Adapt it in your mdb.

I think your tables not normalized well. Learn something about DATABASE NORMALIZATION.

Try it and see.

Look at "DemoLanguageA20022003.mdb" (attachment, zip). Look at Table1, Query1GroupBY (MakeTable Query). Run query, look at a "tblNewLanguage". Adapt it in your mdb.

You don't need a button for this. Look at "DemoSaveA2000.mdb" (attachment, zip). Try to enter a new record. Look at VBA (Form_BeforeUpdate). Adapt it in your MDB.

Why you have got a ZERO in F2 field ???

Look at "DemoPercentageA20022003.mdb (attachment, zip). Run Query1 and see.

O.K. send a short example of your MDB and tell us what you want. (Access2000 or 2002-2003).

You don't need to save the calculated fields, because you can calculate it again when you need it.

Tell us what do you want indeed. Do you want that the user complete the "tbEnter" inevitable, or he can do it but must not do it.

Try to do this via "OutputTo" command, but not form but query.

Try this: If IsNull(Me.tbEnter) or Me.tbEnter = "" Then MsgBox "....." Else DoCmd.Close End If

Try this: ....... MatStr & "'" & "And [Destination]= '" & Znumber1Str & "'")

Not AutoNumber but NUMBER. Look at "DemoAutoNum42990A20022003.mdb (attachment, zip). Open Form1 and try to enter some records. Look at Table1, VBA.

Yo don't need the same date in two tables (or more). It means yor tables not normalized well. Learn something about DATABASE NORMALIZATION.

Try to do this vai COMBO BOX, (not a command button).

For a NEW RECORD you have got a NAVIGATION BUTTONS on the form. If you want a COMMAND BUTTON for this look at "DemoGoToNewRecA2000.mdb". (attachment, zip). Open Form and try. Look at VBA.

Your query is complicated (as John said) because your tables not normalized well. Learn something about DATABASE NORMALIZATION.

Look at "DemoABC_A20022003.mdb" (attachment, zip). Look at Table1, Query1 (column 3 and 4), Form1 (Record Source). Open form and try. I think it is what you need. Adapt it in your MDB.