Search results

OK, here it is Access97, (attachment, zip).

Look at "DemoRemoveA2000.mdb" (attachment, zip). 1) Create a "Table2New" (look ta INDEXED PROPERTIES on the field Colour1). 2) Create an Append query (look at qryTable1Append). 3) Run Append query and look at a Table2New. I think it can help you. Adapt it in your MDB. My fault: In Append Query...

As I can understand you, I think you don't need a query. Look at "DemoProductCountA2000.mdb", (attachment, zip). Look at Table1, Form1. Open Form1 and try. Adapt it in your MDB.

Look at "Exclusive" (attachment, word, zip). I think it can help you.

Congratulations !

Try this: On first form OnClick (command button) event put this code: DoCmd.RunCommand acCmdSaveRecord

Try this: On the second form OnOpen event (or OnLoad event) put the code: Me.ComboBoxName.Requery

Send a short example of your mdb, (Access 2000 or 2002-2003).

I think you need something like "DemoSearchNextA2000.mdb" (attachment, zip). Look at Table, forms, (VBA). Open Form1 and try. Adapt it in your mdb.

Try this: Make a table (Table2New), look a column x1 (Format and Decimal places properties). Make an APPEND QUERY on this table, make a Form (with a command button). Look at "DemoDecimalPlacesA2000.mdb" (attachment, zip). Open Form1 and try. I think it'll work.

Look at "DemoLoginFormA2000.mdb" (attachment, zip). Open Form1Login and see.

Look at "DemoConcatenationA2000.mdb" (attachment, zip). Open form1 and try. Look at VBA.

Yes it's possible. Look at "Demo4ComboA2000.mdb" (attachment, zip). Open Form and try. Adapt it as you need.

Tray with an index on this fields, with UNIQUE = Yes.

Try this, in Sub Form_BeforeUpdate put this code. Me.[Field name] = DSum("[UserInputValue]","QueryFilter") and in Control source link this field with field in the table.

I think you need something like "Demo1A2002.mdb" (attachment, zip). Open form and see. It is for users only, not for expert.

What did you put in CONTROL SOURCE ? Put it in VBA, and link this field with the field in the table. (control source). If you don't know, send a short example of your MDB, (access2000 or 2002-2003).

I made some betterment in the VBA. Look at 6. record. If the Time1 and Time2 are in 15.03.2012. and Time3 is in 16.03.2012. I think you need it. Look at attachment, zip, (VBA).

Here it is (attachment, zip). Open Form1 and see. I think it is what you want.

As I can understand you, you have to include "DateInformations" in your "If". Send a short example of your mdb, (Access2000 or 2002-2003).