If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
F- in Access
That's very nice of you, John, but why don't you make similar offers to many
other OPs you respond to? Further, you condone the actions of visio john and arno r but they never make an offer like yours to any OP. In fact their conduct obviously violates the Rules Of Conduct of the newsgroups and you condone their actions. OPs need to be very wary of hypocrites in sheep's clothing. Steve "John W. Vinson" wrote in message ... On Thu, 13 May 2010 11:19:01 -0700, shumate62 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!!!! I have a copy of your current Word doc describing your needs and will try to get back to you in the next day or so (free of charge). -- John W. Vinson [MVP] |
#12
|
|||
|
|||
F- in Access
"Steve" schreef in bericht ... That's very nice of you, John, but why don't you make similar offers to many other OPs you respond to? Further, you condone the actions of visio john and arno r but they never make an offer like yours to any OP. In fact their conduct obviously violates the Rules Of Conduct of the newsgroups and you condone their actions. OPs need to be very wary of hypocrites in sheep's clothing. Steve It's about time to take your pills again $teve... You are becoming VERY lunatic again. There is hope: When MS is really discontinuing newsgroups and transitioning users to Microsoft forums they can (and will) ban you. Arno R |
#13
|
|||
|
|||
F- in Access
Case in point - he offers zero help to this OP!
Steve "Stop$teve" Stop$teve@Data**** wrote in message ... "Steve" schreef in bericht ... That's very nice of you, John, but why don't you make similar offers to many other OPs you respond to? Further, you condone the actions of visio john and arno r but they never make an offer like yours to any OP. In fact their conduct obviously violates the Rules Of Conduct of the newsgroups and you condone their actions. OPs need to be very wary of hypocrites in sheep's clothing. Steve It's about time to take your pills again $teve... You are becoming VERY lunatic again. There is hope: When MS is really discontinuing newsgroups and transitioning users to Microsoft forums they can (and will) ban you. Arno R |
#14
|
|||
|
|||
F- in Access
Everybody who hasn't run across you yet needs to be wary of you, especially
those who in a moment of madness may consider hiring you. In fact, John has offered a membership database (and maybe some other databases, but that is the one I can recall offhand) free of charge to people working on projects for non-profits. He is always generous with his time and expertise, but never more so than when somebody posts along the lines of "I have been asked to create a directory for my church ...". Steve wrote: That's very nice of you, John, but why don't you make similar offers to many other OPs you respond to? Further, you condone the actions of visio john and arno r but they never make an offer like yours to any OP. In fact their conduct obviously violates the Rules Of Conduct of the newsgroups and you condone their actions. OPs need to be very wary of hypocrites in sheep's clothing. Steve 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 [quoted text clipped - 30 lines] to get back to you in the next day or so (free of charge). -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...arted/201005/1 |
#15
|
|||
|
|||
F- in Access
If you post a sample of the type of data you have to work with - DON'T use
real data - then I'm sure that someone will be able to help you out. It doesn't sound too complex. Can I suggest that you make astart yourself. 1 Create a table (call it tblPeronnel). in this table create An Autonumber field - make this the primary field. Also add the following 1stname Surname 1s tline of the address 2nd line of the address 3rd line of the address 4th line of the address ZipCode or PostCode Salutation (thats Mrs, Mrs, Miss,Dr, etc,etc) You can add any other details you want "as long as this information only applies to the specific person" All of these fields are text fields - except for the Autonumber field. Don't add - speaker, guest, etc to this table Next create another table with details of the meetings you hold Autnumber - primary Date of meeting (date . time format) Location of meeting Plus other items eg. Max seating, etc Now the 3rd table I would suggest that you hold off with. Just create the 2 above and then come back to this form ans someone will be able to tell you how to link them together with a many to many (thats many people can go to many meetings and many meetings can have many people in them). In this 3rd table is where you will store the details of speakers, guests, etc - as they are applicable to a specific mix of people and meeting. Post back when you have the 1st 2 tables done. Next -- Wayne Manchester, England. "shumate62" 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!!!! |
#16
|
|||
|
|||
F- in Access
"Steve" wrote in message
... There is nowhere in the Code of Conduct for these newsgroups that prohibits offering help with an Access application for a reasonable fee. Offering a product or service for sale is considered spam. Spam is prohibited. You've been told this many times and yet you persist. The fact that you must spam the newsgroups for work must be a testament to the poor quality of your work, since you'd have sufficient business if you satisfied your clients. There are posters here that sell a product. If they mention their product in the body of their post, they always include other free competing products as well. You are welcome of course, to use 3 or 4 lines in your SIG to promote your services provided you actually offer relevant help in the posting. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access |
#17
|
|||
|
|||
F- in Access
On 14 May, 01:16, "Steve" wrote:
That's very nice of you, John, but why don't you make similar offers to many other OPs you respond to? Further, you condone the actions of visio john and arno r but they never make an offer like yours to any OP. In fact their conduct obviously violates the Rules Of Conduct of the newsgroups and you condone their actions. OPs need to be very wary of hypocrites in sheep's clothing. Steve I see you're still a complete and blithering idot $teve. |
#18
|
|||
|
|||
F- in Access
"Steve" wrote
Case in point - he offers zero help to this OP! Steve Au contraire, Steve. By cautioning the OP against your solicitation for business, he has, in fact, been very helpful to the OP. See the SIG below? It identifies me, the poster; it brags a bit about one accomplishment -- a book; and points out that (free) newsgroup support for Access will continue to be available after these newsgroups are shut down on June 1, and where to find that newsgroup. It does it all in three lines, and (look carefully) contains no solicitations for paid work, nor even a link to buy the book. -- Larry Linson, Microsoft Office Access MVP Co-author: "Microsoft Access Small Business Solutions", published by Wiley Access newsgroup support is alive and well in USENET comp.databases.ms-access |
|
Thread Tools | |
Display Modes | |
|
|