Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. experienced

    Cannot view own www site

    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...
  2. experienced

    Docmd.RunSQL problem... Access 2000

    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...
  3. experienced

    Query trouble with nulls!

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

    Query Criteria Help

    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...
  5. experienced

    Account Totals in a Query Sub-Form?

    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.
  6. experienced

    not certain I can explain this but please read

    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...
  7. experienced

    Adding records to a table through a form

    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...
  8. experienced

    Access 97 / 00 front end connecting to 97 back end

    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
  9. experienced

    Comparison with null

    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...
  10. experienced

    Comparison with null

    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...
  11. experienced

    Updating a combo box

    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...

Part and Inventory Search

Back
Top