Search results for query: *

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

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

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

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

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, I am trying to collect values from a form and using these as the criteria in a query (which a report will sit on). To start simply the form has a combo box which the user selects the country to be used in the criteria. Not a problem at all. But what I'm trying to achieve is if the user...

Anyone please, Have built a new database for implementation here, imported our existing data and as the good book says split it into a front and back end for ongoing development. Did that, fixed the security, but now cannot see the relationships in the window. The window is populated with the...

I wonder if anyone can help? With some forms I am using the open acDialog parameter to stop the code running whilst on the form, then when closing the form there is code to requery a control on the original form and this works fine. However, I now have a scenario where I want to open one form...

I've been fiddling with this one for some time. We have a form showing company details which users apply a filter by form to find the records they require. From this form we would like to output all the filtered records to a report. Is there a way to open a report based on the current filter...

I have been having difficulty with Got / Lost Focus events on a Subfom. I have a ComboBox control on a Subform with a DblClick event that calls another form to add records to the table which the ComboBox refers to. This works fine. However, I want to requery the control on the subform when...

I',m sure it's a very easy question but I'm just starting with VBA. My code is as follows: Dim stCompanyLinkVal As String Dim stEventLinkVal As String stCompanyLinkVal = "[CompanyID]=" & Me![CompanyID] stEventLinkVal = "[ContactLogId]=" & Me![ContactLogID]...

I have a form which users can launch from a couple of places. The on update and close events of the form run code that causes a requery of another form (actually a subform on form). The code is: Forms!CompaniesForm!ContactLogSubform.Requery However, CompaniesForm might not be open in certain...

I have a subform which is for view only (Legacy Job Info for users reference) reading rows from an underlying query. (Subform not linked to main form)The query is based on a single table. Two fields which are not shown on the form but are in the query comprise the composite primary key. The...

I'm using Arcserve 6.6 with Netware5.0. Probably a very basic question. How is the tape expiry date set and can it be changed? I have tapes which are used on weekly or monthly backups and I don't want them timing out too soon. For daily tapes, okay they can go after a year or so.

I knew the answer once, but all the new stuff drives out the old. We have a small Netware 5 network with MS Outlook 2000 running on each work station. I want to give all Outlook users access to a common contacts list with e-mail addresses, etc on the server. We do not have MS exchange server...

We have a macro that opens a template runs some stuff and then opens the SaveAs dialog to give the user opportunity to save before starting work. We want the document properties dialog to pop up on save but cannot find out how to achieve this. Below is this part of the code. Even with...

I'm looking for VBA code to do the following simple task in Word. This is basically a fax form filler. In a document - Find a character (eg DOS pipe) delete it and pause for user input, re-start running code when return key is pressed. Of course you could search for a bookmark wait for user...