Search results for query: *

Hello, I have a text field with a date like "Tuesday 14 Apr '09". I need to either change that to a standard date via a query, or be able to sort on records that have dates between X and Y. Can someone help me to make the conversion? Thnaks in advance Andrew

Hi, You can set the keypreview property in a form to TRUE. Then the key up event in the form willl trap what you are looking for I think. Runals

Never mind I found it. I commented out the offending routine and then uncommented sections until I found the problem lines. For some reason I had put in On Err goto xxx I changed it to On Error goto xxx And the problem went away. Andrew

Hello, I have an application that I am writing that uses an Access 2000 DB to hold information. A user has complained that when selecting a record from a flexgrid and updating it that a runtime error 5 occurs which is an invalid procedure call or argument. I have tried to duplicate it in the...

What was the old version of Access? It could be that the new version is incompatable with the old version. Andy

Seems to me that the original code flaw is that the record set (rs) is never committed, that is there is no update. Also I think you need and addnew command at the start of each loop iteration. The last response seems lots cooler though. Andy

Thanks Andy

Thanks for the reply. That is what i though should happen. However the recalculation is not happening. I don't know if I am running into a buffer problem or not. Is there a way to force recalculation? I am using ADO BTW. thanks Andy

Hello, I am manipulating an Excel sheet with VB6. In the workbook there are formulas - specifically "sumif" that should be recalculating some cells. As I add data via the VB program the recalculation does not take place. I have made the workbook sharable, but excel is closed at the time of...

I have been using Twiddlebit Plan. ItDoes not have all the feature so Project but it inexpensive and reads Project files directly. Andt

Hello, I am just joining the discussion here. One of you said that % Complete is of no or little value. I disagree. I use MSP to plan a project. I want to use it to track a project. If there are 100 hours scheduled for a task. I put it in as duration (I knwo it shoud be work) and hava another...