wideasleep
Last Activity: Feb 27 '08, 04:46 AM
Joined: May 28 '07
Location:
-
Will give that a try if I understand it right. Thanks... -
Exactly! This is a work order system for our maintenance department. One part will be for users to submit a work order. This information is in it's own table. The other user will be for our maintenance dept. This will be for assigning work orders to the maintenance staff and for them to fill out that information once they have completed the work. And then the final part will be for our maintenance manager to complete his part of it.
...Leave a comment:
-
The fields are going to vary from combo boxes to text boxes....Leave a comment:
-
Hiding fields based on user ID
Hello everyone,
I am trying to make fields on a form hidden based on a user ID. I'm pretty much starting this right from scratch. Can anyone point me in the right direction on how this can be done?
OS: Vista
Version: 2007
Thanks -
One other thing that might help in understanding what I'm doing for my employer is that they want to make a comparison on each item from a day to day basis ie; if a substandard existed one day vs. another day. This was why I went with a y/n checkbox for each item. I was thinking on laying out each checklist Item in it's own table but felt that might confuse things.Leave a comment:
-
Thank you Mary,
I read a couple of articles on normalization including the one on the site but I have been questioning my layout on this project for a while. Your layout seems to make more sense. I guess I've limited myself to the use of foreign keys when I could always use more than one.
CurtLeave a comment:
-
Scott,
I was looking at using just a checkbox but went ahead and used that code with a hidden checkbox and the radio button and that worked. Thanks for all the cooperation.
CurtLeave a comment:
-
Normalization Opinion
I'm laying out a form and am in question on my normalization of data and I would appreciate a few opinions if this could be layed out better. I'm trying to follow a one to many all the way through on this. Here's the layout of my tables.
tblBuildingInfo
ID(pk)
Building_Number - lookup
Inspection_Date - date/time
Inspection_Time - date/time
tblChecklistIte ms
ID(pk)
Checklist_Item( fk)... -
I was just looking at the same thing. It seems the only way to go because there is no way to change the code to accomodate this. I'll give it a try and let you know how it works.
Thanks,
CurtLeave a comment:
-
We're getting closer! I put in both codes and it worked with the exception of when I went back to records with the damaged radio button selected. It then put it back to the normal wear selection and turned it white again.
Curt...Leave a comment:
-
This is a combination of different fields on a form, but they all come from the same table. Text, Combo boxes and of course radio buttons. As I changed the selection to make the background turn red I went to the next record and that one was red too, and so were the rest. This is why I was wondering if the code needed to be put in for the option group instead of the actual radio button in the group.
Curt...Leave a comment:
-
Scott,
Whoa, I guess it worked too good. It turned all my records red on the form. I did have another selection with a radio button called, "Normal Wear" and I set that one to white. Any ideas? This is an option group by the way.
Curt...Leave a comment:
-
Scott,
That worked great! I appreciate your reply.
Thanks Again,
Curt...Leave a comment:
-
Form Event, Background color
Hello Everyone,
I have a form that has a radio button called "damage" My employer wants the background of the form to turn a different color when this radio button is selected. Does anyone have the VB Code to make this happen?
Thanks -
I'll give that a try, Thanks...Leave a comment:
-
I have a date field on both tables and another field called spills_injuries in both tables that are being used to link them...Leave a comment:
-
Combining tables for data entry on a form
Hello,
I have a situation where I have been asked to combine two tables and make a form to continue to enter data. I have created a relationship between the tables and have gotten to creating the form but it doesn't allow me to add a new record. The "new record" selection at the bottom of the form is not selectable. I tried creating a add new record button but that was a no go also. Anyone have any suggestions?
... -
Adding a new field on a subform
Hello All,
I recently added a new field on my subform and made a relationship to it with the ID fields. When I did this the subform went blank. I mean there were no fields or anything! It's just a white area! The subform is an actual form and not a datasheet. Can anyone tell me the reasoning behind this and how to fix it.
Thanks
OS: Vista
Access Version: 2007 -
Hi All,
I guess i wasn't ready to put this one to bed quite yet. I need to break this out by months also and I really haven't had any luck with it. I made another text field called months for it but I'm getting a number that's way off the mark.Leave a comment:
-
Actually I see the reasoning behind it as I look at it more. It's just how it all works together in the code.Leave a comment:
No activity results to display
Leave a comment: