Search results

I give you a detailed example here... (Site RI no is private)

Yes it is and the first query runs.

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...

Sorry that as I haven't mentioned the text box will not be controlled by the table......

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...