Help creating forms in access please

[josh.clare]

Hi all,

i have created a very basic access database that contains all the information i need for our jobs at work. a majority of the data is in 1 table.

All i need to do now is create some userfriendly forms to add/edit data in the tables.

i have uploaded my basic database here:
http://81.134.132.58/josh/Database7a1.zip

Can someone please help me in creating these forms, as you can see i have made several attempts but am struggling. i want to create forms for sections of the table if possible,

Thanks,
Josh

 

[John Big Booty]

Firstly you might want to consider a naming protocol for your DB objects, such as TBL_TableName, FRM_FormName, QRY_QueryName etc. Currently you have both a Table and a Form called Companies, this will cause you no end of pain once you start writing code.

Additionally I notice that you are also using Table Level Lookups this too will lead you into a world of hurt.

Finally I notice that some of your field names include embedded spaces and other special characters, the general advise is to limit yourself to alpha and numeric characters and the underscore (_) and eschew any other characters in your object names.

 

[josh.clare]

hey john,

i have renamed my forms and tables acordingly but what am i supposed to use instead of a table level lookup?

Thanks,
Josh

 

[John Big Booty]

You'll need to use Lookup Tables, for an example have a look at the sample posted here.