Asking for help!

[JIT]

Hello Everybody, Good Afternoon! I earnestly request help from you to solve a problem on form design. I am making a database of machine/chamber in use. The database consists of two tables. In the first table, I enter all the primary data about the machine/chamber such as capacity, purchasing dates etc. In other table, I enter the daily record of a particular machine/chamber whether the machine/chamber is in use, red-tag, not in use. I have designed a form to enter data for first table (primary machine/chamber details table). I am having a problem in designing a form for the second table- specific data inputs. At present, we have an excel sheet, where all the machine/chamber number is listed, and the operator in every morning checks out the status of machine/chamber. I want to design my form in similar way. What presently, I have done is that I have designed a form and forcing new page for every machine record. In the form header, I have made a text box to enter data entry date. Then for each machine, operator chose the machine from combo box and tick mark the status. What I am finding is that when I want to enter data for the second machine, the date, which I have entered for first machine does not recorded for the second machine. This is a problem, as on latter date when I want to get record for a particular machine/chamber within a date range, I will not get that record. However, the overall form looks exactly like the excel data sheet. Could some of you please tell me where I am going wrong? Or any other way to design the form?

I sincerely request your inputs. Thanks in advance!

 

[quest4]

Good afternoon, JIT. Need a little info here, then we can dig into the belly of the beast, aka your dbase. You said you have two tables, are they linked? Is there a PKey? Is Referential integrety check? How about Cascading updates and delete? This is in the relationship. Is there a query involved here? Now you have a form and I assume a subform, is that correct? What is the Master child links? That is enough for now. NOw I am not sure how fumiliar you are with Access, so if I get over your head please let me know. It does not sound like anything hard here, we just got to get the basics correct and the rest is easy. hth.
PS: I sure hope this thing e-mails responses.

 

[JIT]

Thanks!

Hello Quest4, I am really want to thank your for your mail. I am really struggling. I clarify your questions:
The two tables are have one to many relationship with referential integrity. No, the second form for machine/chamber is not a subform. I just one to open this form and enter the status for each machine. There are 78 machine/chambers. So it will be difficult for some one to go for each machine and enter record. Presently in excel sheet all machines are listed as a column entry. The operator just tick mark appropriate status for each machine/chamber. I want to design the form similarly. The easiest thing is to make one form and place all 78 textboxes and associated other status field like a datasheet. So when operator opens this form for data entry, he can do what he has been doing till date. But it is not practicable solution. So I have designed the form as posted earlier. But the date fields are not working. What is practicable, I feel, is that after filling up the date field for first machine/chamber, when I go to the next chamber/machine, its date field should be automatically filled up based on the first date entry. But how? Or there is any other way?

Thanks

 

[JIT]

No reply received!

Would some of you please help me. I am a novice and requesting inputs from experienced people like you.

Thanks in advance!

 

[quest4]

No e-mail notification here. OK. Sorry I took so long to get back to you. I would like you to more or less understand what we are about to do. Dates and Done By's should always be automatic. That is the easy part. Oh just discovered the e-mail notification, it is now on. I would like you to lookat this link revies the info there and save it, this is a great site and it is good fore learning the basic of design:
http://www.microsoft-accesssolutions.co.uk/table-of-contents.htm
With that said, do you possibly have a copy of your dbase, striped of reports and most data? That would make it easier by seeing what I am modifying. Read up on the normalization of table at the link also. Oh is this a new dbase? That would be ideal. Let me know when you are ready. hth.

 

[JIT]

Thanks!

Thanks Quest4 for your guidance. I will come back to you.

Jit

 

[JIT]

For Quest4

Hello Quest4, I have visited the website. You have thrown me into an ocean. I am not a professional programmer. I work in a quality field and want to create a simple database to know what chamber/machine are in use/red tag etc. Could you help me to solve my problem? I would really appreciate.

Thanks,

Jit

 

[quest4]

I start out in the same general way and same deptment, an no I am not a programmer either. But I have now built several dbase and some quite complex. The reason I told you to look at the site is so you can start to understand what is being said and being done. The more I understood what was being said the more I like playing with these. And yes we can get you up and running. This is probably like the ECN Tracking Log that I just made, while making the Quality Control Dbase for our company. Can you attach a striped down version of what you got? Is this a new dbase? In other words, can we modify it to make it more functional? Remember, everyone in these forums stared out with out knowing a single thing about anything. So don't be afraid to ask questions, as long as you learn and understand. Talk to you soon.