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

    Criteria to return ALL including Null values

    Got it, thanks. If a job's worth doing, it's worth doing twice!
  2. gallas

    Criteria to return ALL including Null values

    Hi PHV, Gave yr code a try. Bombs out with a Query too complex error. Creates a mass of entries in the design grid. Tks anyway, Garry. If a job's worth doing, it's worth doing twice!
  3. gallas

    Criteria to return ALL including Null values

    ...help greatly appreciated. Your suggestion works fine (I should have read yr first reply more carefully). My code is now: SELECT qryCompanyData.* FROM qryCompanyData WHERE (((qryCompanyData.CountryCode) Like...
  4. gallas

    Criteria to return ALL including Null values

    Sorry Remou, not sure how to use that bit of code in the query with the criteria string. Garry. If a job's worth doing, it's worth doing twice!
  5. gallas

    Criteria to return ALL including Null values

    ...the query I get a parameter prompt for Forms!frmCompaniesSelectionFilter!cboCountries. Here is the complete original code SELECT qryCompanyData.* FROM qryCompanyData WHERE (((qryCompanyData.CountryCode) Like...
  6. gallas

    Criteria to return ALL including Null values

    ...(Null) this means return all. The code I have uses an asterix as the criteria if the user enters nothing. However, to find all fields I need to use * OR IsNull otherwise Null value fields are not returned. The problem is I cannot get both from my statement. Its the IIF that I'm having trouble...
  7. gallas

    Cannot Re-install WSUS 3 - Can I Restore System State?

    Close thread - problem resolved. Carried out a system state restore. Different problems with re-install. Ran Windows Install Clean Up (from msicuu2.exe). This fixed the windows installer and allowed a re-install of WSUS 3 sp1. :-D "If a job's worth doing, it's worth doing twice!"
  8. gallas

    Cannot Re-install WSUS 3 - Can I Restore System State?

    We have a Win.SBS 2003 R2 SP2 server with 7/8 clients. In SBS 2003 WSUS is integrated into the Server Management console (and it seems to work fine!!!). Attracted by the benefits of WSUS3 sp1 we made the install which disabled the integrated version. The new version seemed overkill for our...
  9. gallas

    Report Count Query Results to a Form

    Thanks PHV, Very simple solution. Works fine.:-D "If a job's worth doing, it's worth doing twice!"
  10. gallas

    Password Protect Design View

    Hi andegre, Freznel's solution is good. We are working in exactly this way. But it does mean that you have to setup User Level Security. If your database is very 'clean' ie. all good code, etc, etc, then the mde option will work. If not,then you risk unexpected crashes caused by running errors...
  11. gallas

    Report Count Query Results to a Form

    ...very easy. But! I have a form with a record source that is a count query. The sql looks like this: SELECT DISTINCTROW People.SpecialMailout, Count(*) AS [Count Of People] FROM People GROUP BY People.SpecialMailout HAVING (((People.SpecialMailout)=-1)); On the form is one textbox control...
  12. gallas

    Correct Syntax for Between Dates Criteria in Query

    Thanks guys, that works fine. Odd because that's what I thought I tested originally - must have made a small un-noticed typo. Stars all round! Thanks again. [thumbsup] "If a job's worth doing, it's worth doing twice!"
  13. gallas

    Correct Syntax for Between Dates Criteria in Query

    I'm trying to collect two date values from text boxes on a form and then set these as the start and end dates for query criteria. I can't seem to get the syntax right. I'm building it in the Access query design grid. Here is an example. Between "#" & [forms]![frmQuoteRptChoice]![StartDate] &...
  14. gallas

    Table Relationships Join Types?

    Just a bit nervous when messing with our main db back end! [Bigsmile] "If a job's worth doing, it's worth doing twice!"
  15. gallas

    Table Relationships Join Types?

    Thanks all. The only real meaning to defining table relationship Inner and Outer join types is to set defaults for queries, the form wizard, etc. So when you create queries or use the form wizard, etc, they will inherit the join types set at the table relationship level (as well as the...
  16. gallas

    Table Relationships Join Types?

    We are currently designing additions to our data model with some new tables, etc, etc. Something that we've previously ignored is that in the MS Access Tables Relationship window it is possible to set join types of table to table. What is the significance of this? It seems to have no relevance...
  17. gallas

    Fill Word-document fields from Access database

    Hi Manners, You might also like to use something like the following to find out if Word is already running. Otherwise your users could open multiple instances of Word which could confuse. Dim appWd As Object On Error Resume Next Set appWd = GetObject(, "Word.Application")...
  18. gallas

    Fill Word-document fields from Access database

    Hi gransbpa, We are working on something like this at the moment. We open a Word Template that has Bookmarks set. Find the bookmark and paste in the data. Like this: ' Move to each bookmark and insert text from the form. .ActiveDocument.Bookmarks("YourFieldName").Select .Selection.Text =...
  19. gallas

    Using IIF and Like in Query Criteria

    ...in my qryCompanyDataListFilter as a source of all the fields that my report needs. In the design grid it appears as one field ie qryCompanyData.* and this makes available all the fields the report needs. Then I need a few other fields showing including CountryCode to set my criteria against...
  20. gallas

    Using IIF and Like in Query Criteria

    Thanks Tom, Everything working fine now. Resetting the combo box to null using code on the cmd btn works perfectly - I'd never have thought of that. Garry. [Thumbsup] "If a job's worth doing, it's worth doing twice!"

Part and Inventory Search

Back
Top