Re: [MS_AccessPros] A tip form

 

Although I am no Access wiz probably a table with the tips you've entered into a table pop up in a form randomly with the rnd function.  

Russ

Sent from my iPhone 7

On Jul 18, 2017, at 5:51 PM, Art Lorenzini dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

 

That is exactly what I want. Whe the user starts the database a tip form pops up with the tip of the day or something like that.

With Warm Regards,

 

Arthur D. Lorenzini

IT System Manager

Cheyenne River Housing Authority

Wk.(605)964-4265  Ext. 130

Fax (605)964-1070

"Anyone who claimed that old age had brought them patience was either lying or senile."  

---

On Tue Jul 18 2017 15:20:52 GMT-0500 (Central Daylight Time), Russ Adams grizpatch@cox.net [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

 

I could be wrong Duane but I think he is looking for a place to locate tips for the user like a help file. 

Russ

Sent from my iPhone 7

On Jul 18, 2017, at 3:34 PM, Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

 

Art,

I would put yourself in the user's chair (or ask them) to figure out how they would use the system. 

How about a date field so you can view new tips?

Are your subjects the same as categories for searching?

Are some tips related to other tips?

Have you considered adding a keywords table?

Regards,

Duane

---

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com> on behalf of dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com>
Sent: Tuesday, July 18, 2017 2:05 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] A tip form

 

I would to create a form that contains tips for the database. I created the following table:

tblTips

TipID

TipSubject

TipDescription

TipPic

Is that the appropriate structure or should I try something different. the TipPic is a ShortText field whch will contain the path to a snapshot picture. But I am not sure how to implement this...

Any ideas, would be a great help.

Thank you,

Art Lorenzini

Sioux Falls,SD

__._,_.___

---

Posted by: Russ Adams <grizpatch@cox.net>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___