Getting Started

Opening a From in Add Mode
I have used a macro to have a Command Button open a Form in Add Mode - I notice that the 'Record Selector' thing at the bottom of the page is still present - Is this normal ? Is there a way to get rid of it - I want the user to add a record then return to the screen I am using as a Main Menu. Thanks for any he... 16 Jun 2008 10:38

Office pro vs small bus 2007
I don't need access but would like to have onenote to use with mobile 6 on my treo, which would be the best purchase. Also, how many computers can I load the software on when I purchase it? -- New user of office pro 2007 ... 16 Jun 2008 12:41

Records
How many records can the Access 2003 hold? Is there a point where I should begin to think about splitting the database? Also, if I delete a record, does it still store it somewhere in the database and add it's total to the record that I'm accumlating? ... 13 Jun 2008 21:30

Email field Hyperlink type
Access 2003 I have a field 'email' with hyperlink type. On the form, click the field, outlook does not start unless email field start with mailto: User does not remember to type mailto: before the email. Beside, display mailto: does not look good. Any way to get around of this? ... 16 Jun 2008 08:35

Appending values from a form into a new record in an existing
The form is not bound to the underlying table because I don't want the users putting junk into the underlying table. For the Sales Rep, Agent and Subagent, there are existing relationships, and I don't want them to be able to put in the wrong Agent for a particular Subagent, or the wrong Sales Rep for a particu... 13 Jun 2008 18:27

need template for printed music collection
My lifetime collection of several thousand items of printed music for piano, for organ, and for keyboard needs organizing. My printed music includes sheet music, method books, piano-specific song books, organ-specific song books, keyboard- and synth-specific song books, fake books (melody & chord symbols), and ... 13 Jun 2008 12:49

Appending values from a form into a new record in an existing tabl
How do I append data from a form into a new record in an existing table? I have a form that I want to use to generate the following fields: Sales Rep, Agent, Subagent, Revenue, Commission and Transaction Number. I have combo boxes so that the user can select the Sales Rep, Agent and Subagent based on values in... 13 Jun 2008 12:49

rs.FindFirst to find last and first name
My table has 2 separate field: Last, First I want a combo to find name and allow people to type Last SPACE First. So my recordsourse for the combo box is: SELECT [Last] & " " & [First] AS name FROM tblMaster ORDER BY [Last] & " " & [First]; How to connect LastSPACEFirst in rs.FindFirst in AfterUpdate event? ... 13 Jun 2008 14:52

Access被樂觀的鎖定
因為您和其他的使用者試圖在同一時間更改同樣的資料， Microsoft Jet 資料庫引擎會停止處理程序。 (錯誤 3197) 此一錯誤可能發生於多使用者的工作環境。 另一位使用者已經更改了您正企圖更新的資料。 此一錯誤可能發生於多位使用者開啟同一資料表或建立 Recordset 且使用樂觀的鎖定。 在您使用 Edit 及 Update 方法之間，另一位使用者已更改了此資料。 請再一次執行 Update 方法，以將您的資料覆寫過其它使用者的更改 以上為軟體顯示之問題內容，請救救我吧！ ... 13 Jun 2008 11:17

Adding a suffix
I am a relatively new user to access. I am having a problem. I have 2 tables, each table has the same field and it is formatted as text. I need to be able to query the data from table A, add a suffix and update at least 2 other fields. Then I need that record inserted into table B. I need to repeat this N numbe... 20 Jun 2008 13:17