Search results

On one of my form, I have inserted a MS graph. This graph draws a pie chart and the data is base on the result of some queries. The problem is it takes a little time for the form load (mainly because the graph). I don't know use what event to notify that the graph finish loading. Also when I put...

You are right. Use Dcount would work. But I use this query at run time. Is there any solution that can always return a records in my query without using Dcount. Thank for your help.

I have a nest query as below: SELECT field1 FROM table1 WHERE field1 NOT IN ( SELECT field2 FROM table2 WHERE field3 = TRUE ) This query run fine as long as the second query ( the inner query ) have return at least one record. But there is still a case where the second query does not...

"Beginning Access 2000 VBA with Cdrom" by Robert Smith,Robert Smith,David Sussman,and Dave is a good one. More advance book is 'VBA Developer's Handbook' by Ken Getz and Mike Gibert. Hope this help you.

I'm @ work. I'm unable to use hotmail. They lock it. I send you my copy when I 'm home. Thank you for your help.

Another try I did is create a new mdb file and import all the code from the old mdb to the new one. The result still the same.

No, I didn't change the name. It still close a form and open the second form. I am not able to get a breakpoint stop not in this sub but on every other sub in the whole application. I try delete some code and then go to property sheet to write new other simple code and run it. But it still...

Thank you for your reply, cpod. I have put the breakpoint at the FIRST LINE of my command button. Other breakpoint at the form activate event, on open form event. But I still doesn't work. One of my commmand button have only 2 lines: Private Sub cmdView_Click() DoCmd.Close...

In my program, I try to set breakpoint at my command button but when I click on the button, it did not pause at the line I set the breakpoint. Then I close my program and open Northwind database and set some other breakpoint, this time it works. Anyone please tell me what wrong with my program.

Hi Rich. I finally choose the same solution with you. In addition, I open one more form while waiting the main form to reload. This form just have a label in it. Then close this form after the main form is complety loaded. DoCmd.Close acForm, Me.Name DoCmd.OpenForm "frmIdle"...

Sorry Rich. I misspelt your name.

Thank you Rick. But F9 and me.Refresh don't work too. Please help anyone.

I have a very similar problem with you. I use two sendkeys statement to reopen the form. SendKeys "%VD%" SendKeys "%VF%" It work for me but it is very annoy users when they see the form open in design view and then reopen in form view. I try other method to requery and refresh the...