Automaticly Sort without my permission

[SOS]

looking at the fact that it's a very big file..where can i go and upload it? speedyshare??

1. What version of Access is it?

2. Have you done a COMPACT AND REPAIR on it yet (that will help with the size)?

3. Then you would ZIP the file to get it below the 785Kb mark. But it must be compacted using the internal Access Compact and Repair FIRST and THEN Zipped.

 

[mrtool]

Ok it's 324 kb now..so where or how do you want me to post it??

Sos..if it's possible to get feedback from you of the database would also be great..Don't have to do it for today, you could also get back to me tomorrow

 

[SOS]

Ok it's 324 kb now..so where or how do you want me to post it??

Sos..if it's possible to get feedback from you of the database would also be great..Don't have to do it for today, you could also get back to me tomorrow

You post it here (and again - WHAT Access Version is it?)

When you reply to a post you can click the button GO ADVANCED and then you look down a little ways on the page and there is a MANAGE ATTACHMENTS area with a button to click to open a dialog to select the file, upload and then close the upload dialog and then hit the post button.

 

[mrtool]

http://www.speedyshare.com/589919760.html

It's saved in Microsoft Access 2003

 

[SOS]

Why didn't you just post it here? I can't download from "speedyshare" as it is blocked by work. And many others can't either. Your file size was fine and it is not rocket science to follow my instructions on uploading.

 

[mrtool]

I'm leaving to home now..tomorrow I'll be back online to see the respond y'all gave me..for questions just post them..and I'll answer back as soon I read them

 

[mrtool]

For a brand new database would alsoo be greatt
That way I could even see that you understand the basics..what do you say Kryst51

 

[Kryst51]

Ayyye de me!

 

[mrtool]

Because the size of the file exceed the maximum..that's why I upload it on from speedyshare.. And there's no way to zip..

 

[gemma-the-husky]

did you say this was an ASSIGNMENT mrtool

like school assignment ?

 

[mrtool]

did you say this was an ASSIGNMENT mrtool

like school assignment ?

Noo..I'm on vacation now..it's an assigment that I got from my boss, but I'm stuck and when I ask him for help..he only point me out to the net..

 

[Kryst51]

hmmmm interesting, didn't notice that....

 

[SOS]

Because the size of the file exceed the maximum..that's why I upload it on from speedyshare.. And there's no way to zip..

So you are on Windows 2000, or Windows ME, or Windows 98, 95 or 3.11? If you are on Windows XP or Vista, you have a built in Zip utility. You can right click on the file and selct SEND TO > COMPRESSED FOLDER and that is zipping.

 

[mrtool]

Dont go yet..
I'm going to Zip it right now, In 3 minutes the file would be posted

 

[mrtool]

This is it..I'll be back tomorrow to see y'all reply..

 

[mrtool]

Tomorrow I can also explain more briefly what I was trying to do..

 

[The_Doc_Man]

mrtool, as a point of etiquette I should mention that asking someone on the forum to do your work for you is not usually considered good form. We can look, we can make suggestions. But if we do it for you, we have gained an albatross hanging forever from our necks. (See "Rime of the Ancient Mariner" if in doubt.)

The biggest problem I see here with people who are just starting off is that they saw some simple thing in Excel and decided it would be cooler to make a database out of it, or the boss wants one for a similar reason. And the boss either doesn't know or doesn't care that database design is NOT best left to the inexperienced. So instant "in over your head" and no easy way back to the surface.

You might indeed get help here but many of the posters have been trying to tell you that you need to step back and learn something for yourself so that you don't have to spend countless hours typing and waiting for some kind soul to pity you enough to do your work for you. Because whether that is what you intended or not, that is exactly how it is coming across.

Forgive me for being brutally honest, but I think you need to step away from the keyboard and find some reading material first. Your words come across in a way that makes me think you aren't ready for what you are trying to do.

It is clear that you need help, but what in God's name persuaded your boss to give you an Access database assignment? That is not a trivial project if you want to do it right, and we rarely help anyone who wants to do it wrong. I wish you well, wish you luck, and advise you to start reading seriously before continuing to bounce off the brick wall you are building for yourself with you lack of expertise.

 

[Scooterbug]

Mrtool,
Where to start....

First, you need to map out what you want your database to do. As it was already suggested, read up on some basic tutorials for Access. A quick look at your database and I cringed. None of your tables have primary keys, and your tables are riddled with lookups. Both are really, really bad ideas. You even have 2 tables that only have one field.

You best bet, in my opinion, would be to scrap what you have and sit down with paper and pencil and start from scratch after reviewing those tutorials that were mentioned earlier.

 

[mrtool]

First, you need to map out what you want your database to do. As it was already suggested, read up on some basic tutorials for Access. A quick look at your database and I cringed. None of your tables have primary keys, and your tables are riddled with lookups. Both are really, really bad ideas. You even have 2 tables that only have one field.

You best bet, in my opinion, would be to scrap what you have and sit down with paper and pencil and start from scratch after reviewing those tutorials that were mentioned earlier.

Mrtool
I'm busy scrapping what I have on paper right now. And after I'm planning to start all all over again..

I wanted to facilitate the job of the users when they're putting in their data.. That's the main reason why my database have so many lookups..but right now I'm putting it on paper. I'm also trying to prevent some look ups..

One question is there another way of making a lookup without having to make a new table (with the data that you want to show up in the drop down box) in?? Like by writting the words you want to show up in drop down list in a line or something??

I would like to read the basics once again..seeing how many trouble I have..But this database have a deadline for monday..so that's why I came up on the net to ask people..hoping that I'll get my answer directly instead of looking into the whole theory again..

But I'm working on it all over again..But someone could help me with the ques I asked

 

[Scooterbug]

Having the db done by Monday is pretty ambitious. I hope you aren't doing anything at all this weekend.

As for the lookups...

Don't be afraid of having too many tables. Having a normalized db is much easier to work with.
For each combo box you want to use, you will need to basically have a table for them. Each table will have a primary key and the information you want the user to choose from. For example your Date(IT) table should look something like this:

tblWeekofYear
WeekNumberID PrimaryKey
WeekNumber Text

The primary key for this table can be stored in another table as a Foreign Key. By doing this, the relavent data can be associated with a record and can be retrieved via a relationship between the two records based on that ID Number.

btw, there are certain reserved words that you should steer away from when naming tables and fields. Date is one of them. Also, it's not advised to use special characters, like ( or ) either.

That should get you started. I honestly think you need to tell your boss that the deadline of Monday is not feasable. If it was a simple contact database, I would say sure. But I get a feeling that what you want this db to do...will take longer that you expect.

As for just asking for specific help, Nobody here has an issue with that. But there has to be an expectation of at least knowing the basics. Having a good table structure setup and understanding the relationships between tables is the foundation of a good database. If those concepts aren't fully understood, then it's like building a house on a sandy beach using toothpicks. Eventually it's gonna crumble as you build the house higher and higher.