Search results

:p Hola Montemontgo! 1) Access97 is limited to 1 Gigabyte, in Access2000 it is 2 Gb. I suggest you to learn something about "Compact", "Repair" and "Splitter" (Access Help). 2) The field "Year" my be Alpha field, it is up to you, but it must be a separate field. If you put a prize...

:rolleyes: Hello Montemontgo! I made a short example how I should make it. There are two tables, and two forms. frmPerson is a main form, and frmPrizeSubform is a subform. One person you enter only one time, and all of his prizes in subform. You can see three queryes, only for example.

:o Hello Montemontgo! Es I can see from your question, you wrote more data in one field. you have to learn something about DATABASE NORMALIZATION.

:p Hello Wilhels! Send me your mdb, maybe I can do something.

:o Hello Rich1968! Open any VBA (form, or module), click on "Tools", then click on "References", if you find "MISSING" references disconnect them.

:) Hello SweeT V! I think you need a SHORTCUT. Open Windows Explorer, (minimise it), find your "mdb", right click on your mdb, find "Create Shortcut", click on it. The SHORTCUT will be created on windows explorer, pull them on the desktop by a mouse.

:o Hello Tron57! You don't need two tables with the same data (CustomId, and CustomName), it's wrong. It's enough one table. Look at "DemoFindA97.mdb", I think it's what you need.

:) Hello frankie13! Look at "DemoListBoxA2002.mdb"

:) No I'm wrong, not Input mask, but Format properties, write & it means only a to z. or >& it means A to Z.

:( Ashkan, something is wrong, newer mind, in properties input mask put ? it means only A to Z.

:confused: It means

:p Ashkan Rub off the "Valdation Rul" and fill up the "Input Mask" properties.

:( Hello Ashkan! The length not depens on "Valdation Rule", it depens on "Data Type" and "Field Size".

:confused: Hello Leffe78! Why not! You can link childfields and masterfields i despite of the subroms source is a query. Look at "DemoSFormA97.mdb.

:rolleyes: Hello Leffe78! I suggest, make your "other form" as a subform of the "first form".

:p Hello harvey I think you created a FORM that has two combo boxes. Look at "Demo2ComboA97.mdb"

;) Paul I think it is not necessary to make a global function. The every user must know that february can't have 30 days, and so on. Yo can change a "MsgBox". "Date is opposite the calendar" or something similar.

:cool: Hello Paul! Look at "DemoDateA97.mdb"

:o Hello warmduvet! Write the code in SUB FORM_CURRENT Me.ComboName = ""

:) Hello Ksab! On the Access window click on "Queries" tab, then "New" button, on NewQuery window chose "Find Duplicates Query Wizard", follow wizard. Look at "DemoDuplicateA97.mdb"