how do convert the first letter of a name to capitals in access

Access 2002. I have a table with a hyperlink field that I want to populate with drawing image files related to the records (inventory parts). Our drawing...

I have a table where I want to match up product names with a .jpg picture of the product. All the .jpg product picture files are in a folder on my...

I want to save 192 bit-values in 12 integers. How do I save this information in a field in a table? Can I save it in a text field – and how do I the extract...

Im looking for the Input mask that allows for dates in 2000. Thanks

Can I use an "If" statement in the critera of my query? If so, I am trying to return a value from a table in one column based on the condition of another...

I want to have a table with imperial heights stored (eg 5'10") but when I create my inpout mask with 9'##" ( 9"' "##"") it just displays as 5'10. Is there any...

In Access, can you set a field that will flash or blink if certain parameters are met, for example, the number entered is less than 10?

Hello, I have a temp table that is created from code to use for printing a report. It works great except for a field used for middle inital. If a...

Some authors always make the foreign key also a primary key; while other authors make the foreign key a non-primary key. Question? what is the difference in...

how do I add a header and/or footer to a table in datasheet view in Access 2000

Hey everyone...for some reason i cant seem to figure out how to link a table to display my subdatasheet.its really imp...n ive been trying but the links with...

I'm looking for an attendance chart in which I can input the name, date of absence, reason of absence, and the service level of my company that day. I would...

When should a field be indexed? If a field is used in a relationship, either as a primary or foreign key, an index is created as part of the process. If you...

Sorry this is first posted in Public.access before I saw that there is a special tabledesign group Who can help me...? Jan Hi I'm a newbee and has to solve...

Well, not really...but my front end doesn't show them anymore. I had to add some security, which for me a databse password was enough. I ended up relinking...

There must be a way to get a list of a database's tables into a text file. Any list of the tables I see in Access can't be tagged and put into the clipboard....

Hi there, Ive been a bit to ahead of myself, and i need to add some buttons to my form - but, ive set up within start up to have all my menus dissapear (all i...

I am setting up a table that includes the field "First Name" and "Familiar First Name" I want the default for the second field to be the first since in most...