input masks and visual basic

[jathayer]

Can somebody please give me the input mask/validation rule, that will make a field start with a capital letter. e.g. Sweets or Popcorn.
Also, how do i make a frontend?!

 

[emcf]

1st issue I can help with...have a look at this post -
http://www.access-programmers.co.uk...?s=&threadid=42298&highlight=capital+letters.
2nd issue.....i've no idea mate.

 

[neileg]

Create a FE/BE by using the database splitter wizard.

 

[UKBobby]

Sorry to Hijack this tread a little but what is the benefit of having a FE/BE database?

 

[neileg]

FE/BE advantages are in my view all about the fact that the FE can be different for different users. Eg you can have a Access 2000 FE and an Access 97 FE attached to the same BE. You can restrict users view of the data and system objects by the FE. Etc.

 

[UKBobby]

Thanks Neil