Forum Restructure

Mar 19, 2007

Due to the ongoing bulk of regular spam posts that this forum receives, and based on similar activity on other forums, I think it would seem to be that the reason for this is the use of the word 'General' in the forum's title. In my experience it is the areas marked this way that generate the most spam, be it 'General Discussion' or otherwise.

So, in order to try and combat this, I was thinking that it may be in the forum's interests to change the name of this section. If it's what spambots are geared up to search for then it makes sense to shield the target from them.

My thinking is that, were I to change the name, the forum would be best placed at the base of the 'Microsoft Access Discussion' area and renamed to 'Other Issues'.

Thus, my plan would be to have the 'Microsoft Access Forum' ordered in this way:


Database Design
Tables
Queries
Forms
Reports
Macros
Modules
Other Issues


I'd appreciate others thoughts on this so reply away. There's a poll at the top of this thread if you just want to post a yes/know/don't know sort of response. The poll will only be active for one week, starting now.

View Replies


ADVERTISEMENT

Restructure Query

Jun 19, 2006

I have two tables (one table current three week data, and another for all the project data),
the three week data table lists tasks by IDs and the task status (Ahead of Schedule, Complete, Delayed, Late, On Time, Postponed)
all project data lists tasks by IDs and the task category (Plan Tasks, Plan Task for Next Two Weeks, Milestone)

The following query that returns a percentage of a task that has a given status and is apart of a specific category (so for example the query would give me the Percent of all Tasks [in both tables] that are Ahead of Schedule and marked as a Plan Tasks)

Code:SELECT FormatPercent(subQuery1.Instances/subQuery2.Total) AS PlanTasks_that_are_AheadofScheduleFROM [SELECT COUNT(ThreeWeekStatus.Status) AS Instances FROM RawData, ThreeWeekStatus WHERE RawData.OutlineNumber=ThreeWeekStatus.TaskId AND ThreeWeekStatus.Status="Ahead of Schedule" AND RawData.Category="Plan Tasks"]. AS subQuery1, [SELECT COUNT(ThreeWeekStatus.Status) AS Total FROM RawData, ThreeWeekStatus WHERE RawData.OutlineNumber=ThreeWeekStatus.TaskId]. AS subQuery2;

now I have many copies of this query for each of the following status and category
Percent of all Tasks [in both tables] that are Ahead of Schedule and marked as a Plan Tasks
Percent of all Tasks [in both tables] that are Complete and marked as a Plan Tasks
Percent of all Tasks [in both tables] that are Delayed and marked as a Plan Tasks
Percent of all Tasks [in both tables] that are Late and marked as a Plan Tasks
Percent of all Tasks [in both tables] that are On Time as a Plan Tasks
Percent of all Tasks [in both tables] that are Postponed as a Plan Tasks

Percent of all Tasks [in both tables] that are Ahead of Schedule and marked as a Plan Task for Next Two Weeks
Percent of all Tasks [in both tables] that are Complete and marked as a Plan Task for Next Two Weeks
Percent of all Tasks [in both tables] that are Delayed and marked as a Plan Task for Next Two Weeks
Percent of all Tasks [in both tables] that are Late and marked as a Plan Task for Next Two Weeks
Percent of all Tasks [in both tables] that are On Time as a Plan Task for Next Two Weeks
Percent of all Tasks [in both tables] that are Postponed as a Plan Task for Next Two Weeks

Percent of all Tasks [in both tables] that are Ahead of Schedule and marked as a Milestone
Percent of all Tasks [in both tables] that are Complete and marked as a Milestone
Percent of all Tasks [in both tables] that are Delayed and marked as a Milestone
Percent of all Tasks [in both tables] that are Late and marked as a Milestone
Percent of all Tasks [in both tables] that are On Time as a Milestone
Percent of all Tasks [in both tables] that are Postponed as a Milestone


as you can see having 18 similar queries is not real efficient, how can I restructure my query so I can get it to simply to one query with the following output
Name | Ahead of Schedule | Complete | Delayed | Late | On Time | Postponed
Plan Tasks | % of tasks | % of tasks | % of tasks | % of tasks | % of tasks | % of tasks
Plan Task for Next Two Weeks | % of tasks | % of tasks | % of tasks | % of tasks | % of tasks | % of tasks
Milestone | % of tasks | % of tasks | % of tasks | % of tasks | % of tasks | % of tasks
Total | % of tasks | % of tasks | % of tasks | % of tasks | % of tasks | % of tasks

View 3 Replies View Related

New To This Forum

Mar 9, 2007

Hi,

Before I ask my question I was wondering if it was possible to attach a zip file of the database I'm working on? It would save some typing.

Thanks

Eddie.

View 2 Replies View Related

Hello I'm New To This Forum And I Have A Question :)

May 16, 2005

Several of my databases is a little slow and that puzzles me since there isn't over 200mb of data yet :confused:

Is there any advantage in storing data on an oracle server and will it speed up things or is there other things I can do?

Perhaps someone in here would be so kind to look at my database and give some advice on the structure and possible changes to improve performance?

Perhaps I should add that I don't know much about other database tools so I'm shooting in blind here.

So if anybody will look at my database and see if he/she can optimize it I will be happy. I can leave little data inside to allow You to see the output - if needed.

I'm not very technical with access (not yet) so things might be done differently than I do to speed up things

Any help is greatly appreciated :)

View 4 Replies View Related

This Forum Got Me In Trouble...

May 1, 2007

Hello all active members of this forum,

Like I stated on the title, this forum got me into trouble. By following the reading in this forum and some recommendations from the regular users I have created thre database for the place I work at. now they want me to be the official DB admin! :eek:

So now I'm coming back to you guys for more advice... :rolleyes: what reading should I do to better my Access knowledge over all.

Any recommendation is welcome.

I have already contacted th local college and they do have a distant learning class for Access and I will be taking it the next semester, but I would like to do some reading into becoming a REAL Access programmer with a solid foundation.

There must be some good books out there to purchase to get me started. So all are welcome to give me some feedback.

Thanks!

René

View 14 Replies View Related

Forum Database

Jan 2, 2006

I have been tasked to design a Forum Database using ASP, could someone please point me in the right direction as to the design for table structure for this.

I know that the user will be looking at a web front end which in turn will be accessing the Access Database.

Any assistance would be much appreciated.

Dispersion36

View 1 Replies View Related

Question On This Forum

Oct 10, 2004

How long normallly does it take to get an answer?
Also, what does the "View" on the right margin mean?

View 4 Replies View Related

Does Anyone Know How To Post A Db On This Forum

Mar 17, 2005

could anyone please tell me how to post a database on this forum ive tried attachingit but it says file not suitable

View 4 Replies View Related

Complex Sub-forum

Jan 5, 2007

I'm trying to design a system for an electronics shop. I have two tables, one called Products and another called Suppliers.
The Products table has the following fields-
- 1) Product ID
2) Supplier ID
3) ProductName
4) Information
5) Price

The Suppliers table has the following fields-
- 1) Supplier ID
2) Company
3) Address 1
4) Address 2
5) Address 3
6) Town
7) County
8) Post Code
9) Country
10) PhoneNumber
11) FaxNumber

Basically I want to create a form to show the supplier name and ID and then implement a sub- forum which shows all the product details for that supplier. How do I do this? Do I have to use a query?
Thanks

View 2 Replies View Related

Recommendations On SQL Server Forum ?

Oct 6, 2005

Recently I moved the back end of some databases I develop and maintain to a SQL Server for speed and stability purposes.
Whilst this forum has been great for digging out answers to various Access problems I encounter, I persume there are some similar forums dealing with SQL.
Has anyone got some recommendations ?????

Thanks

Richard

View 2 Replies View Related

Report Spaming On This Forum

Jun 5, 2006

How does one report spaming on this Forum?

View 3 Replies View Related

Publishing URLs In This Forum

Nov 1, 2006

Brain-death is a horrible thing to witness.

I have searched FAQs, advanced search, etc., and know I'm not looking in the right places.

Question: How do you, in this forum, publish a URL using a descriptive title versus the actual URL itself?

Obviously it's not rocket-science since so many contributors do it apparently effortlessly, but folks I'm struggling.

Please point me in the right direction.

Thanks - Bob

View 3 Replies View Related

Using Google To Search The Forum

Feb 9, 2007

Did you know that you can use Google to search the Access Forum and get a more refined result?

I find that the search facility provided is excellent at searching for single words. However it does not provide the sophistication of tools like Google for searching for exact phrases.

To get this sophistication do this:

Open Googles advanced page: (http://www.google.co.uk/advanced_search?hl=en)

The first section of this page is shaded blue, and contains the following items:

with all of the words
with the exact phrase
with at least one of the words
without the words

You can add words to varying degrees of sophistication for your search.

This is the important bit!
Just below this blue shaded area there is another section, go to the fifth item down in this section which is:"Domain" also make sure "Only" is selected. In the next text box (to the right of Only) place the domain you want to search in, this case you want to search the Access Forum so place in this box the following:

http://www.access-programmers.co.uk/forums

Now give it a try! Try searching for: "Date Selection" (without the Quotes)

If you search for this with the above Google method, you will get 90 results, If you search this result with the Forum search then you will get over 300 results.

Caveats:
Your search will only return items within the access-programmers site, and only items that are allowed to be indexed by Google.

Cheers Tony...

View 14 Replies View Related

How Do You Put Usernames In Forum In Access? Please Help Me?

May 25, 2006

Hi,
I have been using access for quiet awhile (I learned it 2 months ago). I want to have a online business (using Dreamweaver and Access) but, I want to organize my data and I want to figure out how (when you go onto a website say target.com) to make the username and password in Access (Like when you register for an account, you put in your username, password, email address...ect. and the you make your account and then when you put in you username and password again to log into your account (I want to know how to do that)). Another thing, when the person logs into a account and wants to buy a product how do you do that in access.
Any answers can help me.
You could send me a link to a webpage that tells me how to do this stuff.
Any Tips?:)

View 1 Replies View Related

Check Box To Update A Forum

Oct 3, 2004

hey all,
i'm making a database to catalogue a whole bunchs of projects of mine. i have a few
questions but i'll ask one for now. i have made a form with a check box and i want it
so that once that check box is clicked, another element appears or becomes un-grayed
or something. basically if the check box is checked then i have to specify a file location
for the file that i'm confirming exists. (if that makes sense)

thanks for any help
-marwan

View 1 Replies View Related

Does Some From The MS Access Group Monitor This Forum?

Mar 10, 2006

Surely I am not the only one who imports text files in to Access (on XP) containing double quote characters???

Does Access quit the import at the double quote character for anyone else.

To the MS Access group.. have you tried this??

Thanks

View 1 Replies View Related

Noob Question Sorry. Forum Sizes!

May 30, 2006

How can i make all my forums fill my screen? so dont have to recreate them? so they are not just tiny boxes. as originaly designed? I looked in hope that there maybe have been something in the startup drop drop down, but i was't so luck. also tried to select whole forum and group and name the whole thing bigger by dragging the resize command. but this just messed the whole forums up so i did't save changes.

Thanks im sure this is a really stupid question.

Shrew

View 7 Replies View Related

Limited Posts In Access DB Forum

May 2, 2007

Hi there!

I`ve been using Access DB for a forum for about two years now, but from time to time I have to download the db and delete about a 1000 posts (+/-).

The reason for this is that the db want accept more posts unless I do so.

My question is how do I "extend" the db to accept more posts?


Thx in advance,
Sarre

View 5 Replies View Related

Not Able To Enter Or Change Data In A Forum

Aug 13, 2007

Here is my problem:

I created a Query to calculate an over all rateing useing other data that was already in the database. The Query worked out perfectly, and I then wanted to put the one field that gave me the overall rateing that I just calculated and put it into a form. So I added the Query with the rateing into the one that made up the other form and added the field to the Query. The problem was that when i went into that form and added the field, it made it so that i could no longer change any of the data on that forum. I thought that it might have something to do with the fact that there were no fields with math in them in that form untill i added the over all rateing one, could that have messed it up? Please send me some seggestions because I havent a clue at what could be worng. Thank you, Ben

View 12 Replies View Related

Attention To The Best Access / VB Programmers In This Forum

Feb 9, 2006

Right first of all hi everyone,

i have been to about four forums now and No One has been able to make this work it can be done as i have seen it from the access sample database (Order Entry). I have been informed that this forum has the best of the best in access guru's, this problem has had me stuck for 2 weeks i don't normally asked for help but it has breached my knewledge base and now its time for an expert to have a look at it.

I have had many suggestions but none have worked, below is the link to the Order Entry database so you can see what i am trying to acheive and also another link of my actual database as it stands.

The problem is that i have a form called Customers this is displayed when the database is opened, the form has a subform called QuoteSelector that holds all the quotes if there are no quotes then the user is then able to add a new customer and then create a quote when they click the Create New Quote button.

Then another form called Quotes opens this holds the data form the quote and also has a subform called QuoteBuilder, this form holds all the materials that have been selected for the quote.

Now when i click the Create Invoice button that is on the Customers page i want all the information from these forms to be displayed in my report called Invoice. I have already created the Invoice i am just having trouble in passing the CustomerID and the QuoteID to the Invoice or i think this is what is needed in order to make all the data display.

If you can help this would be great as no other forum has been able to and this one has the best reputation for programmers with access so well i will have to see it, but please take a look at the Order Entry database and see how the Invoice is generated you will notice a box pop up letting the user enter more details i don't want this i just want the invoice to come up and then the user can print it.

Thanks in advance and hope this can be done:

This is the sample database Order Entry

Order Entry Download (http://www.weblogics.co.uk/Order Entry1.zip)

This is the Database I NEED to create the invoice for:

Database FOR Edit (http://www.weblogics.co.uk/quotes.zip)

View 2 Replies View Related

How To Configure Forum (NewsGroup) In Outlook Using NNTP

Oct 15, 2005

Hi All,

Is there any way I could configure this forum in my Outlook Express using NNTP? If yes, Can I have NNTP Server Address?

Many Thanks in advance,

Jigs :)

View 1 Replies View Related

Showing Another Database Button (Sorry Didnt Know Which Forum To Ask In)

Aug 10, 2005

Would this work: Having a command button that opens another database. Cheers

View 1 Replies View Related

Yet Another Keypress/input Mask Question For The Forum

Jul 7, 2006

Yea yea I know, another one...
But the way I see is that I haven't asked them all so its ok... :p

Right basically, I only want to allow input of Y N or P into a text field. I thought it would be best to do it with an onkeypress event as I know of no way to block certain characters in a text field with an input mask.. this is what I came up with but it doesnt seem to work...

If Not KeyPress=78 Or Not KeyPress=80 Or Not KeyPress=89 Then KeyPress = 0

Any ideas?

View 1 Replies View Related

Seached Forum For Automation Of Emails, But Still Stuck-cos Im A Newb

Dec 30, 2005

Hiya,

Sorry to add to the email threads, already posted on this forum. I have already searched on the forum for the relevant help but im still struggling. As am a newb when it comes to this sort of thing, and everythink is an on going learning curve.

Background, i work for a architectural firm, my boss would like the database to send out automated emails, to the local planning authority.

I have a query called "ApplicationEmailCouncilQuery" in this i have the following fields. ApplicationProjectID, ApplicationSubmitted, ApplicationRef, ApplicationDecisiondate, ApplicationContact, PlannersEmail, ApplicationEmployee, Email.

How do i get access 2k to automatically send out emails to each of the results individually as produced fromt he query, every 2 weeks.

I want the email to use the fields from the query.
To: "PlannersEmail"
Send: Your Application ref is "ApplicationRef" submitted on "ApplicationSubmitted"
Message: To ApplicationContact,
Please could you give me an update on the application "ApplicationRef" which we submitted on "ApplicationSubmitted".

Please reply to this following address "Email"

Yours Truly

"ApplicationEmployee"

-----------------------------------------------

Sorry for the long post, any help on the above matter would be greatly appreciated.

Thanx

Keith

View 3 Replies View Related

Switchboard Opens Blank Forum, Altho Is Populated.

May 31, 2006

Hi all,

I decided to create a switchboard using tools---> DB utilts---> SW manager.
i have managed to get this on the front end, altho the first button the contacts does't work properly. when i click it using that i cannot see any of the data that is in the database? but if i go out the switchboard without pressing anything on it. and goto contacts form the data is there?

Wired? or is it something simple i have missed?


Thanks

Shrew

www.dsltech.co.uk/310506.zip

View 1 Replies View Related

General :: Create A Forum That Changes Values In A HTML Template

Jul 8, 2014

I Am working on a Access database that will build a excel spread sheet, that will be uploaded to Ebay via file exchange. I am looking to build a forum that will edit parts of a Html text in a column, such as the size and color.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved