Hi,
I have a really frustrating problem with my Access db. Frustrating because I'm sure that the solution is very simple yet I have not been able to get to it....
Firstly, I have a main menu form which has a number of command buttons, one of which is to add a new client. When this is done the client details form pops up and when I begin to enter data a message pops up telling me that I cannot assign a value to the control because the form may be read only or the value I am entering may be too big for the control. This comes up and when I click OK I can continue typing no problems and then save the record. I check in the corresponding table and it is there. The form is not read only because I have all the permissions to allow edits, additions and deletions. The VB code for the command button from the main menu to the client details form allows the form to be opened as per the form property settings. I don't know what to do next to resolve this?
My second problem is that after completing the client details form I click on a Network details command button to move to that client's network details form. Firstly, the auto client number that is assigned in the client details form does not come up in the client number box in the Network details form and I need to type it in so that the two sets of detail are linked. I have checked my relationships and they are OK and checked the record in the client details table and it appears there with a + next to it linking to the network details table and showing all the information I have entered. I imagine there is a problem with the linking of the two forms through the control buttons. I have included in the VB code of the command buttons to jump from the client details to client network forms and vice versa by linking the two via client number but this seems to not be working?
Any help would be very much appreciated, I'm sure it is a simple solution and it is something small that I am overlooking. If anyone requires more information to solve this please let me know.
Sebby
I have a really frustrating problem with my Access db. Frustrating because I'm sure that the solution is very simple yet I have not been able to get to it....
Firstly, I have a main menu form which has a number of command buttons, one of which is to add a new client. When this is done the client details form pops up and when I begin to enter data a message pops up telling me that I cannot assign a value to the control because the form may be read only or the value I am entering may be too big for the control. This comes up and when I click OK I can continue typing no problems and then save the record. I check in the corresponding table and it is there. The form is not read only because I have all the permissions to allow edits, additions and deletions. The VB code for the command button from the main menu to the client details form allows the form to be opened as per the form property settings. I don't know what to do next to resolve this?
My second problem is that after completing the client details form I click on a Network details command button to move to that client's network details form. Firstly, the auto client number that is assigned in the client details form does not come up in the client number box in the Network details form and I need to type it in so that the two sets of detail are linked. I have checked my relationships and they are OK and checked the record in the client details table and it appears there with a + next to it linking to the network details table and showing all the information I have entered. I imagine there is a problem with the linking of the two forms through the control buttons. I have included in the VB code of the command buttons to jump from the client details to client network forms and vice versa by linking the two via client number but this seems to not be working?
Any help would be very much appreciated, I'm sure it is a simple solution and it is something small that I am overlooking. If anyone requires more information to solve this please let me know.
Sebby
