Automaticly Sort without my permission

[mrtool]

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.

I'll see how far I will reach.

I liked how you compare my situation with the house on the beach, it's true..but that's if you don't know not a damn thing of the basics. But in my case maybe I might know a lil. So the beach must change into something a lil more harder.

Anyway.. I undersand what you was trying to tell me..I decided to make "forms" for the users to input their data instead of "table". Another question that popped up was that if in the "forms" it's possible to select from a drop down list.

Meaning that if I make the lookup in the table for that field. If it will allow you to choose from the options in the form.

 

[Scooterbug]

Yes, you can put drop down lists, or combo boxes as they are called, on a form. The wizard can help walk you through on how to set those up.

The best way to use that however, is not to use a lookup at the table level. Instead, the data for the combo box (the row source) should be the table that contains the data you want to display in the combo box. You then would store the primary key from the row source as a foreign key.

 

[SOS]

The best way to use that however, is not to use a lookup at the table level. Instead, the data for the combo box (the row source) should be the table that contains the data you want to display in the combo box. You then would store the primary key from the row source as a foreign key.

Although it it completely acceptable to create the lookup at table level PROVIDED you remove the lookup later, after your form has been created. The benefit to doing it this way is that the combo box will be created for you on the form. But you have to go back into the table after all of your forms for which you did this have been created and then set the lookup from Combo Box to Text Box in order to remove the table level lookup.

 

[mrtool]

I'm back again peeps..

With y'all recommendations in mind..I went and look briefly at the basic..And with the help of them.. Make a newdatabase

It's not finish yet..I only did the first part which is the making of the table..My next steps is to make forms so that the user can input the data..

But before I do that I want to hear from y'all if im on the right track, what should I do diffirent ( get a feedback)etc.

Getting a feedback as soon possible would be very good..Because I'll be heading home in a hour..

Let me know peeps..

 

[SOS]

I'll take a look and give you my impressions as well. My first impressions are that you need to do this straight up:

Do not use special characters as field or object names. Using # as field name is bad, very bad. Use Num instead. Don't use NUMBER as it is an Access Reserved Word.

Also, don't use parentheses in your object names. Get rid of ( ) in those names and I would not use spaces in field names or object names as it complicates things later.

For example instead of

Projects Info (KM)

you would do

ProjectsInfoKM

or

Projects_Info_KM

(underscores are okay).

I'll be back with more as I can see it isn't quite right yet.

 

[mrtool]

Okk..Keep them coming, willing to learn from my mistakes

 

[mrtool]

Are you getting through SOS..or you need some explanation or maybe it's just you not finding no mistaked (also possible)

 

[SOS]

Are you getting through SOS..or you need some explanation or maybe it's just you not finding no mistaked (also possible)

Here's your database, reworked with better naming, and the keys fixed (you had several using an autonumber but then set the key to the text, which is not correct).

Take a look at your revised sample (attached)

 

[mrtool]

Okk thankss SOS..I'm working on the forms now..

Did you look at the lookup by the way??

 

[SOS]

Did you look at the lookup by the way??

No, didn't look at that. It might help with creating your form (remember that you need more than just a single form, but will need to have a main form and subforms for the one-to-many relationships).

Just remember to remove the lookup at table level after your form/forms is/are created.

 

[mrtool]

Okk, but can I still choose from a drop down list if I delete the source??

 

[SOS]

Okk, but can I still choose from a drop down list if I delete the source??

ON A FORM, yes. You use a combo box (also known as drop down). When you set one up, it should store the ID in the field but display the text. The combo box wizard is just like the lookup wizard, so it should be fairly easy. If you have troubles, someone here can help.

 

[mrtool]

Okk..I got it

It's going pretty good now, I'll finish it off later..
By Monday I'lllet y'all know how it went..

Thank for all of y'all help. I know I asked a lot, I'm sorry for that, but I just wanted to understand it very good before I go and do something..It have to be done for Monday too, so that also is a reason why I kept asking..

Thanks for all advice/recommendation...Y'all will here of me Monday again..

 

[SOS]

Have a good weekend!

 

[Kryst51]

I am glad that your questions were answered. Good luck with everything.

 

[mrtool]

Heyy peeps..Whats'up...
Pleasant Week..

Is it possible that I can ask 1 more question.It's concerning the part of form. I asked it already in the other forum, but didnt seem like anyone could help me with it..

So I jump back to this thread, hoping that here my experts yes can help me. It's very simple, I just want for a calendar to pop up next to the field where I have to input the date (in the form)

How can I make that possible??
I'm usng access 2003

 

[mrtool]

Never Mind Peeps..I got it
Thanks for looking anyway