I have a table listing departments which I use to populate a drop down combo
box on my form - property set to limit to list

What is the best way for the user to add a new dept to this list without
going to the table?

Steve

Keith Wilby baesystems.com> wrote in
news:c6b2279d-8f82-4ed6-bc95-2de55f1e21b2@i28g2000yqa.googlegroups.co
m:

Yes, you've often said this.

I classify you as one of the children wanting to be protected.

Get over it or killfile me.

Word 說明
Word 首頁 > 設定格式
按一下以追蹤超連結
全部顯示

全部隱藏

根據預設，追蹤或開啟超連結 (超連結：帶有底線的有色文字或圖形，按一下即可跳至檔案、檔案中的位置、全球資訊網上的網頁，或者內部網路上的網頁。超連結也可以跳至新聞群組、Gopher、Telnet 及 FTP 網站。)的方式，是按下 CTRL 鍵並按一下超連結。如果您要的話，可以設定超連結，讓您只需要按一下超連結就可以追蹤。

1.. 按一下 [Office 按鈕] ，然後按一下 [Word 選項]。
2.. 按一下 [進階]。
3.. 清除 [編輯選項] 底下的 [使用 CTRL+滑鼠左鍵追蹤超連結] 核取方塊。

For some reason this doesnt work for me.
It tells me that the locations doesnt exist.

"Douglas J. Steele" wrote:

I'm throwing myself at the mercy of the experts and asking for help. I
volunteered to help my local library- fundraiser group create a database in
order to put their annual event names in a computer rather than the stack of
loose papers and notes they have in a three inch file. Each year they have to
spend days handwriting invites and sorting through the names etc and I wanted
to put it in a specific type of database. I thought I would be able to create
it but after spending every spare minute I had over the last month or two
watching tutorials and making a thousand broken databases I have reached the
conclusion that I am a failure at Access.
The database I wanted to create seems so simple I know it would take an
Access master a mere 27 and a half minutes to create it. The basic idea is
an address book table with Name, Address, Email, etc. Then a second table
that lists the type of person they are Speaker, Guest, Media, and then a
third table allows for the year to be selected for that type (In 2007 John
Smith was a Speaker and then in 2008 he was a Guest, etc) so you would have
the address book part and then a subform below that would allow for two combo
boxes with the type of person and the year.
Does anyone already have something like this created that I could just enter
in my data? Anything like that?
Thank you thank you thank you so much for any help!!!! ...

Gee, was it something I said? I feel ignored.
--
Green and Growing

"Wizbard" wrote:

"CindyO" discussions.microsoft.com> wrote in message
news:B36E5B78-FCDB-46F8-9258-0A0FB5797180@microsoft.com...

If you have an attachment named "hey you.mht", it may very well be a virus,
especially if it came in an e-mail bounce message and you didn't send a
message titled "hey you". It may be innocuous, but I would be very
suspicious and *not* open the attachment, nor view the e-mail in HTML
format.

Attachments of the form "ATT#####.htm" are usually the HTML-format version
of a message. You see this as an attachment when you view the message in
plain text. It isn't normally anything to worry about. However, in a
message that is already fishy, I wouldn't take any chances.

Hi
Finally got it working with:

Shell """C:\Program Files\Microsoft Office\office11\excel.exe""
""\\server\shared\public\folder\file.xls""", vbMaximizedFocus

Thanks for all your help

Steve

"Steve Goodrich" btinternet.com> wrote in message
news:oakGn.69865$YL2.42678@en-nntp-06.am2.easynews.com...

Hi,
I am a very new Access database user.
I am using the Microsoft Access function called “Get External Data” to
create link tables to an Oracle 11 G R2 database. My problem is that Access
is adding the database name to the names of all the link tables instead of
just creating link tables with the original Oracle database name. Eg a table
on the Oracle database is called “com_user” but is created by Access as a
link table called “databasename_com_user”
Unfortunately all my automated test scripts that use the Access link tables
fail because they do not recognize the link table names.

Do you know how I can remove the database name from the link tables or even
better stop access adding the database name to the link tables when get the
external data.

Many Thanks

Your question may be better answered in a newsgroup appropriate to your
problem. This newsgroup is dedicated to the Microsoft Access database
product. The Microsoft website may have misdirected you. That said, there's
probably nothing of importance, I'd just delete it.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access