Search results

I've discovered that the problem is caused by the last assignment statement: Forms![ufmService].[TotalPoints] = Forms!ufmService.[TransportPoint] + Me.TPoints I've removed it and use another way to do summation. The problem is resolved now. Thanks for helping The_Doc_Man...

Actually, when I move the mouse up to the parent form, everything is fine until I click on anywhere on the parent form, then the error message appears. My On Mouse Move event is empty.

Hi Marion, Thanks for the suggestion! I've turned it off from Tools->AutoCorrect Options..., restarted the application. But the speed seems to be the same though.

My pleasure. I actually never heard of the 4th Dimension until I read the comparisons.

Yet more comparisons fyi please.

Is it possible to use SendObject to send an email to a user with the email embedded with a button for him/her to click on it to approve a request? - similar to a Lotus' workflow.

Have a look at the comparisons here: http://www.4d.nl/4D%20Access%20FMP%20Comparison.pdf There are pros and cons but I personally prefer Access as it has a lot of features. But learning curve is rather steep.

I have a subform that contains a call to a subroutine which creates multiple rows of new records depending on the first row of record entered. Near the end of the subroutine, it calls DoSummation (as shown below). Then when I move the mouse to the Parent form, 'error 3251 - Operation is not...

Hi The_Doc_Man, The application I'm developing now is on my development PC. It's a 2.4GHz PC, we have 10/100Mbit/sec network speed. The speed is already bad on my PC, it becomes worse when I place the be on a fileserver. I've not done defrag for few months now. My guess is whether it is due...

Hi There, I've noticed that when switching to View from Design View or Saving a form, they take a long time. 10 seconds to save a form, 5 seconds to switch from Design View to View. If the be is on a fileserver, it takes much much longer for these two operations. It used to be much faster...

asmodius, Your 'Switchboard Items' may have corrupted. Try the followings: 1. Change 'Switchboard Items' table to a different name. 2. Change 'Switchboard' form to a different name. 3. Recreate the Switchboard using the Switchboard Manager. 4. If everything works fine, delete the corrupted...

Thank you Bob. Got it now...

Thank you Paul.

How is it done? by simply saving it as Access 97? But I don't see such an option when I try to save it.

Does anyone know wheter it is possible to downgrade Access 2002 application to Access 98?

Hi Bob, In a scenario where I want to sum up the total hours:minutes from a table containing multiple records, how should I call the function you've created? Is the array being used in such a situation? Table A: idx____Parentidx___TimeSpent 1________1________10:00 2________1_________9:12...

Great! Thank you Kevin.

My application now requires computation which I believe can only be achieved using VBA. But since I’m not a programmer, would really appreciate some help on this. Here is my problem: I’m creating a customer service module which needs to calculate the total number of points used which depends...

I noticed that the AuditTrail demo works well on a single form. However, in a form-subform situation, it will not capture changes made to the subform, even though the subform's table has its own tbAuditTrail field. eg. if I edit a field in the child table, the tbAuditTrail in the parent table...

Fantastic. It works! Thank you Mailman. Appreciate your help.