Is there anyone that can help me out of this problem:
I have an access database application runing on my system and i want it to be available to number of users on the network that will post data and the data will reflect on the server.
Please kindly assist me. I will really appreciate it.
If you are running this database on a network, the best solution, for multiple users to enter data - is to split the database - you can distribute the frontend (contains only forms, reports, queries) to those users with a link to one backend database (which will only contain the database tables).
Thank you very much, it has got me out of the problem.
There is a point i dont know if i implemented well.
Here is the scenario:
I did as you suggested, but i had to link the table with - Link Table command in Get External Data menu that is under File Menu.
It is working but, the network administrator said my application is causing a congestion on the network.
Let me say once again, i really appreciate the solution but i dont mind if you can still help further on the network issue. Or is it something else that is congesting the network?
Yes, the steps you have performed are the correct ones. The only other suggestion, is to have your users use the front-end database file on their respective local harddrive; this should alleviate strain on the network by putting the processing back onto the user's computer.
In my access database, i have two controls - a textbox and a check box.
I want a situation where if the value of the text box is 0, then the checkbox can be enable, else, the check box should be disabled such that users will not be able to select it.
I have below a sub-procedure that i used and im not getting the result:
Private Sub Reconcile_AfterUpdate()
If Me!Reconcile = 0 Then
Me!commit2invoice = enable
Else
Me!commit2invoice = disable
End If
End Sub
OR
Private Sub Reconcile_AfterUpdate()
If Reconcile = 0 Then
commit2invoice = enable
Else
commit2invoice = disable
Please kindly help me out, i will really be grateful.
The main problem is that you can not change the record source of the form as it is a 1 to many query.
From my understanding the Account Officer(s) will make the final adjustment to the passenger breakdown e.g number of females, males, children, infants, staff on duty and free tickets etc. When the value of the reconcile field is zero then the commit2invoice will be enabled for the user to click.
Using this scenario I have added the following code to the relevant form.
Private Sub Children_AfterUpdate()
check_reconcile
End Sub
Private Sub Female_AfterUpdate()
check_reconcile
End Sub
Private Sub FOC_AfterUpdate()
check_reconcile
End Sub
Private Sub Infant_AfterUpdate()
check_reconcile
End Sub
Private Sub Male_AfterUpdate()
check_reconcile
End Sub
Private Sub SOD_AfterUpdate()
check_reconcile
End Sub
Sub check_reconcile()
If Me!Reconcile = 0 Then
Me!commit2invoice.Enabled = True
Else
Me!commit2invoice.Enabled = False
End If
End Sub
Samson maybe able to add more information regarding the requirements etc.