Search results for query: *

I had the same problem, but in my case I did make the mistake of naming our domain as our web domain. So, I am not sure if my solution to our problem (suggested by someone in this forum earlier) would would work for you, but nobody so far mentioned it, so why don't you try it anyway? I went to...

Yes, it is a reference problem. All you have to do is to refresh the references. This is how to refresh the references: 1. Open the references at Tools in VBA module 2. Add any new reference (you will remove it soon) 3. Save the references 4. Open them again and remove the one you just added 5...

CROROCK, Use Nz function as Count: Nz([InspCount]) This will return 0. "0" is a string, not 0 (zero).

Newbee2 Step 1. You should try to create 12 queries that have the same fields. Step 2. Make a Union query of 12 queries. (This is a bit advanced for a newbee, but check with Union Query Help. It is not that difficult.) Step 3. Create a cross-tab query using Query Wizard. At one point, it will...

Beshawn, Assuming your sub-form is a continuous form and is linked to the main form by the account number, you should create an unbound control, TotalPayment, in the subform's Form Footer and enter =Sum([Payment]) in the Control Source of TotalPayment.

This is how I would do it. 1. First, create a query using this table. The first 2 columns are the same as those in the table. The next 2 columns should be NumLen: Len(strIndexNum) LeaderLen: IIF(NumLen=1, 0, IIF(NumLen=2, 2, IIF(NumLen=3, 4, 6))) where strIndexNum is the field name of the...

Dear Fox, Isadore's suggestion should work. I would add a few things. First, if you are new to Access, do learn ADO, not DAO. DAO is a dying technology. Write your codes in ADO. Another point is that if you want to make sure the foreign key is present, you want to use the OpenArgs property of...

If you have a mixed environment of Acc97 and 2000, make sure that your back end database is in Acc97. Then, both Acc97 and Acc2K applications can open it without any problems. If the back end database is in Acc2K, you must convert it to Acc97. Cheers

You can discuss philosophical aspects of NULL, nothing, and its meaning for hours. It is a confusing issue and it is not Miscrosoft's fault. One source of confusions comes from the fact that there are variables (in modules) and there are controls (on forms), and you can mix them in your...

You can discuss philosophical aspects of NULL, nothing, and its meaning for hours. It is a confusing issue and it is not Miscrosoft's fault. One source of confusions comes from the fact that there are variables (in modules) and there are controls (on forms), and you can mix them in your...

Here are the answers: 1. "GotFocus" of the form works quite differently from that of a control. What you should use instead is "Activate" and "Deactivate" properties of the form. But, you don't need them to update your combo box if you do 2 below. 2. You can...