|
|
Up |
|
  |
Author: Steve GoodrichSteve Goodrich
Date: Jun 7, 2010 23:27
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
|
| |
|
| |
1 Comment |
|
  |
Author: David W. FentonDavid W. Fenton
Date: Jun 7, 2010 21:18
> I've said this many times, although not directly to you since I'm
> supposedly in your KF - your knowledge of Access and many other
> topics is to be admired and perhaps even envied, but the apparent
> chip on your shoulder that manifests itself in what many perceive
> to be extreme candour or condescending rudeness seems to get the
> better of you far too often.
Yes, you've often said this.
I classify you as one of the children wanting to be protected.
Get over it or killfile me.
|
| |
|
| |
no comments
|
|
  |
Author: maymay
Date: May 14, 2010 10:42
Word 說明
Word 首頁 > 設定格式
按一下以追蹤超連結
全部顯示
全部隱藏
根據預設,追蹤或開啟超連結 (超連結:帶有底線的有色文字或圖形,按一下即可跳至檔案、檔案中的位置、全球資訊網上的網頁,或者內部網路上的網頁。超連結也可以跳至新聞群組、Gopher、Telnet 及 FTP 網站。)的方式,是按下 CTRL 鍵並按一下超連結。如果您要的話,可以設定超連結,讓您只需要按一下超連結就可以追蹤。
1.. 按一下 [Office 按鈕] ,然後按一下 [Word 選項]。
2.. 按一下 [進階]。
3.. 清除 [編輯選項] 底下的 [使用 CTRL+滑鼠左鍵追蹤超連結] 核取方塊。
|
| |
|
no comments
|
|
  |
Author: Andre AdamsAndre Adams
Date: May 14, 2010 01:33
For some reason this doesnt work for me.
It tells me that the locations doesnt exist.
"Douglas J. Steele" wrote:
> Try creating a shortcut to the database, and put the reference to the group
> file (.mdw) in the shortcut. Note that the shortcut must include
> msaccess.exe, not just the .mdb file.
>
> "C:\Program...
|
| Show full article (0.94Kb) |
|
no comments
|
|
  |
Author: shumate62shumate62
Date: May 13, 2010 20:19
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!!!! ...
|
| Show full article (1.39Kb) |
|
11 Comments |
|
  |
Author: WizbardWizbard
Date: May 13, 2010 20:17
Gee, was it something I said? I feel ignored.
--
Green and Growing
"Wizbard" wrote:
> I'm back... embarrassed to admit that I got my Committees module working for
> about a day and then accidentally deleted my subform and haven't been able to
> recreate it properly again. See my earlier...
|
| Show full article (2.12Kb) |
|
no comments
|
|
  |
Author: Dirk GoldgarDirk Goldgar
Date: May 13, 2010 18:46
"CindyO" discussions.microsoft.com> wrote in message
news:B36E5B78-FCDB-46F8-9258-0A0FB5797180@microsoft.com...
> not a computer wizard, Can anyone tell me what these are? I got it in a
> returned email notification failure from who i sent an email to. I don't
> know
> if they contain a virus or what, but i can't and don't wanna open them
> until
> i know if they might be a virus . but i do know my email to this person
> came
> back as a failure.
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.
|
| Show full article (1.16Kb) |
|
no comments
|
|
  |
Author: Steve GoodrichSteve Goodrich
Date: May 13, 2010 18:01
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...
> Thanks, I'll give it a try when I get back to the office
> Steve
> "Douglas...
|
| Show full article (4.82Kb) |
|
no comments
|
|
  |
Author: Lee7763Lee7763
Date: May 13, 2010 16:46
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
|
| |
|
1 Comment |
|
  |
|
|
  |
|
|
|
|
|