Search results for query: *

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

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!

Thanks Remou, your 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...

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!

Hi PH, When I put the new code in 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...

Hi, I have a problem with returning all records. The query gets its criteria from a user form. If the user leaves a field blank (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...

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!"

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

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

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

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

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!"

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

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

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

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

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

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

Hi Leslie, I'm pretty much a beginner but I'l try to explain. I am setting up the query in design view and the SQL that you are seeing is what is behind it. qryCompanyData is a saved qry that I am using to bring all sorts of fields together from different tables. I use this query in my...

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!"