Search results

Try and see.

Send a short example of your MDB, (Access2002-2003 or Access2000), and tell what you want to do.

But, there are no LName and FName in the related table (tbl Audition). I think your tables not normalized well.

Look at "DemoTextAlignA2002-2003.mdb" (attachment, zip). f1 is a TEXT field. In the query put a FORMAT on this field, FORMAT = @@@@@@@. Look at Query1 (Format for f1 field). Run query and see. I think it is what you need.

Send a short example of your MDB, (access2000 or 2002-2003).

Send a short example of your MDB, (access2000 or 2002-2003).

Send a short example of your MDB, (Access2000 or 2002-2003).

Look at "DemoIndex1A2002-2003.mdb" (attachment, zip). Look at tables, query. Run query adn look at "tblStudentNew". But it is SUSPICIOUSLY if you have got 2 students with the same LName and FName.

As I can understand you, you want to make one record "Doe John 654" from 3 records. Make a new table "tblStudentNew" with Index1 on the field LName and FName (1 index on 2 fields), with UNIQUE properties = YES. Make an "Append query" on the table Student (input), and tblSdtudentNew (output). Run...

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

What is the look of your table ??

Look at DemoDifferenceA1A2A2000.mdb" (attachment, zip). If you want +4 as result, it must be a2-a1. Look at table, query, run query and see.

1) As CRXFTW said, you don't need the same data in two tables. 2) If you want it, link the field (from the form) with the field in the table, and dislocate the instruction in VBA. Look at "DemoCombo2A2000.mdb" (attachment, zip). Look at tables, query, form (VBA). Open form and try.

OK, here is a NEW ONE. I add a Table1. Look at Table1, Combo Box. Open Form and try.

Hello Razaq! Here it is, attachment, zip. 1) It's a COMBO BOX, not a list box. 2)I never use a button for exit. I use a smal button on right uper corner on the form (X). 3)I never use a button for "ADD NEW RECORD". I use a NAVIGATION BUTTONS. 4)All buttons i put in the FORM FOOTER. 5)What is...

Send a short example of your MDB, (access 2000 or 2002-2003).

Look at "DemoRenameCellA2000.mdb" (attachment, zip). Look at Table1, queries, Module1, Form1 (VBA). Open Form1 and click on the button. Before take a copy of your table. I think it is what you need.

Look at "DemoDateReport2A2000.mdb (attachment, zip). I think it can help you. Look at table, query, form (VBA), report. Open Form1 and try.

Try this: DoCmd.RunCommand acCmdSaveRecord DoCmd.OpenReport "ReportName", ,"AutoGeneratedID=" & Me.AutoGeneratedID Instead of your code.

You don't need a same data in the 2 tables.