Search results

Try this SELECT Count(IIf([QRY_Japan_0306]![MARKET VALUE]>25000 And [QRY_Japan_0306]![YTD2006 REVENUE]>10000,0)) AS Total FROM YourTable; It should work

When you are in VB select from the menu bar tools , preferences And select the Library from the list

before the call to open the form Dim nodata as string nodata = nz(dlookup("[yourqueries field]","[Yourqueryname]"),"") If nodata ="" then (your query has not returned data) stop your form from opening end if

I would create a query that selects the the Id and usernames from your table and sort it on the usernames field use this query as the row source of your combo box

In your query add a new column and in the field section type Sequence: (Select Count(1) FROM Yourtable A WHERE A.yourfield <=yourtable.yourfield)

can you post a copy of your DB to have a look at ?

You could write query selecting the fields you require and in the criteria section of the column that you want to use 'Find' type [ please enter value] change the query to a make table query When you run the query it will prompt you for your parameter and make a table with the data returned...

It looks as if you have called DoCmd.SetWarnings False with out setting it back to true DoCmd.SetWarnings True Once you have set the warnings to true You will be asked if you wish to save your changes or not

I have attached a copy of a browse database posted by a member Run the form fFindopenImportFile This form allows you to browse for a file and uses several modules You could copy the Form and modules to your dbase . Open the form browse for the file select it and it appears in the blank field...

Me.AA1 = Aaa1 / Counter Me.AA2 = Aaa2 / Counter Me.AA3 = Aaa3 / Counter Me.AA4 = Aaa4 / Counter Me.AA5 = Aaa5 / Counter Try using the Nz Function around your code like so Nz(Me.AA1, 0) = Aaa1 / Counter I tried it on your dband it didnt fail until it reached the code without the NZ Hope...

Select the field you want to apply the conditional format to then from the condition drop down box select expression is then type the following in the adjacent box [txtCriteria1].[Text]="" And [txtTypeNum].[Text]=1

you could create a new query and add to it each query that the reports are based on (don't forget to link the queries) Then use this new query as the source for the report

Please tell us how

RE:RE:COMBOBOX problem Create a query that selects the data you would like to see in the combo box (don't forget to sort the query) create a combo box (using the wizard) and select the query you have just created. open the form and click in the combo box type a letter and the first occurrence...

when in conditional formatting change condition from field value is to expression is Then in the next field type [yourfieldname] Is Not Null That should do the trick

In access you can in a query type [Please enter name] in the criteria section and when the query runs it asks for a parameter. My question is how do I achieve this with a view in SQL? (I know how to achieve it with a stored procedure) Any Help gratefully received Thanks

I have a number of combo boxes each based on a query ot table if i type a letter the first occurrence of any value with the letter appears in the combo box (don't forget to sort your query)

if you create a macro and in the action column select transferspreadsheet Transfertype = Import Spreadsheet Type = Microsoft Excel8-10 (type of spreadsheet) Table name = tablename (table name in the database it will created for you) Filename = c:\a\aaatest.xls (the pathname of the spreadsheet)...

Try conditional formatting In your report select a field then on the menu bar select format , conditional formatting

Create a query that uses the values in the combo boxes as parameters forms![yourform]![combox1] forms![yourform]![combox2] Base your listbox on the query in the after update of combox2 type me!listboxname.requery