Search results

Thanks for all the replys, PAT, I will go over my design and relationships again to see if I can improve the normalisation. DocMan thats a good idea with the new table and one I will try to implement. RV the reason for creating a new table is because; There are a list of tasks that are...

Ok I have a massive task to perform as the main function of this database I'm developing however there is no way I'm going to figure this out without the help of you guys. On a form I will have a TextBox with a "Change Type" value. Now when I click a button I need it to search the record in a...

I've just loaded that form for the first time today and it now works! I haven't changed anything but I can't find any problems with it anymore. ODD! Thanks for the reply though!

Yeah I have only just started developing this database. I intend to use the security tool but I wasn't going to do this until I had finished the database. I intend on having usergroups and access rights for each user. I was kinda hoping I could set alot of the rights that aren't user specific...

I have a form and a subform. On the mainform I would like to stop the records from being edited. So I have stopped editing, additions and deletions. However I would like the details from the subform to beable to be edited. However the subform has the same "Allow" properties as the mainform...

I have a subform which takes data from a query. The main form is attached to a Action Plan table and the subform to a query from the TypeTask table. The query has a criteria set for the Action Plan ID. This action plan ID is taken from the recordset of the main form. So when the mainform...

Ok your right you need to create a query. This is the way I would do it. First of all you need to create a query using the wizard. Use your employee table and follow the instructions. When you run that query it should show all the employee records. Now you need to create a listbox on your...

The number of action plans depends on the number of requests. The request is turned into an action plan onece it has been accepted. However there are about 30 Change Types and about 100 Tasks. More than one change type can share a task aswell!

Thanks for the reply I've already thought of that one and lots of other combinations, the problem is that the tasks for an action plan depend on a the change type of the action plan. The system works so that a request in the system is created. when a request is made a change type is selected...

I have a database and have to develop a form which displays information about Action Plans and there tasks, however after playing around for days with listboxes and subforms I can't seem to get them to work. The tables (Action Plans) and (Tasks) aren't directly related. Here's how they are...

How do you manually grab that data from a selected record in a subform?

Right I'm in need of help AGAIN! This time I have a form with a subform on the left which is linked to a Requests table. This is read only sub form. What I want to do is select a record from this subform and this selected record is then filled into the fields on the right of the subform on...

Cheers indesisiv, works perfect! Cheers for the help guys

I have a tricky problem I have a series of fields on a form. Date Entered, Deadline and Estimated Time. The Date Entered and the Deadline will both be date inputs by the user. What I want is that when a user inputs these dates the estimated time is then calculated between the two dates. So...

Ok Guys I've managed to solve this one. I simple added a listbox and set the values to the status ID in the status table. Then I selected to fill the data into the Status ID field in the Requests table, it worked! Thanks for the help!

Jack, I first of all added records to the status table too see if this was the problem but it still didn't work. If I'm understanding you right you want me to have the main part of the form Status and the subform on that form as Request. This is no good because the point of the form is to...

I'm a relative beginner and am in need of clarafication on an error message I'm getting. Two of the tables in my database are called Requests and Status, They are linked together.The primary key of the Staus Tbl (Status_ID)(Autonumber) is the Foriegn key in the Requests Tbl (Number). When I...

I don't know if there is an easier way to do this in XP, but a guy from my office passed this code on to me: This is added to a Module: Declare Function CallWindowProc Lib "user32" Alias _ "CallWindowProcA" (ByVal lpPrevWndFunc As Long, _ ByVal hwnd As Long, ByVal Msg As Long, _ ByVal wParam...

I'm after a bit of professional advice here. I've just been handed over a design specification and an interface and have been asked to build a very big database. The interface is made up of one form with about 12 tabs on it. I was wondering whether I could set up each tab to a different table...

That's Interesting! Even when I comment the code out, that I entered into the load event, I still get the error message. As long as a load event exists eg. there is a Private Sub and End Sub I get the error message. What the hell is going on?