Search results

i have a table like this. no. times --------------------- 2001 3 2002 1 2003 2 how i can run a query/vba so that it can turn into 200100 200101 200102 200200 200300 200301

There is a sample database below. I want to input the details of the new students to the student database. A form is set and i want that after i choose a student number, the three subjects will update automatically so that i just need to input the name and teacher in charge of the student.

SELECT [New Site Address].[code no], [New Site Address].[Site RI no], [New Site Address].[site address], Left([site address],InStr([site address],[name_eng])-2) AS [front words], InStr([front words],",") AS comma, savenumer2(Replace((Right([front words],Len([front words])-comma)),"."," ")) AS...

i just wanna ask can i set a field size for a textbox so that it can be entered only a limited number a words For example, when i set field size = 8 and want to type beautiful, it will stop at "beautifu".

How can i save another new access file (=copy/backup) by clicking a command in a form? (Link should be imported by browsing, just equal to save database as) Thank you. :)

I have created the login form below, but there are some problems: 1. If both ID & PW are right, the program goes wrong. 2. There is also the same problem if i choose the wrong pair of ID & PW. It doesn't matter if you turn to vba code :D Thanks

Assuming that I have two tables in my database. table: A Sentence Tom is a boy. Mary is a girl. table: B BeforeWords|||AfterWords Tom ||| Peter Mary ||| Betty is ||| was After running the queries, it should have Afteradjust Peter was a boy. Betty was a girl. Table B is a converter which...

Assuming that I have two tables in my database. table: A Sentence Tom is a boy. Mary is a girl. table: B BeforeWords|||AfterWords Tom ||| Peter Mary ||| Betty is ||| was After running the queries, it should have Afteradjust Peter...