Search results

:confused:

Then will it work if you write [Forms]![Sökformulär]![Titelsök] ? ^

Does your Swedish version of Access use the word Forms? Just a shot in the dark, for otherwise the query is quite OK. ^

Both DateValue() and Like cannot make use of indexes. If the table is large, the best way would be to store the date and time in two fields and index the date field, for then the query can take advantage of the index and should run with lightning speed. ^

If the table name may contain spaces or special characters, add the square brackets. If ID is a numeric field, remove the single quotes. Don't think you need to put the ID value in brackets. db.Execute "DELETE * FROM [" & Me.tabl & "] WHERE ID = " & Me.Text10 & ";" ^

If your version of Access has the StrReverse() function, try this:- Needed: Left([LOCATION],Len([LOCATION])-InStr(StrReverse([LOCATION])," ")+1) & Val(Mid([Location],Len([LOCATION])-InStr(StrReverse([LOCATION])," ")+1)) ^

Actually you can if you follow Jon's Basic Criteria Format in the link. Default values and Null serve different purposes. ^

I'm afraid you can't accomplish that. When there's nothing to return, a query won't return anything at all. ^

Take a look at Note (2) in this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=103312 ^

Agreed. The etc. in the third condition does need elaboration by the OP unless what he/she meant is "If the first 2 conditions are untrue, then it's WIP." By the way, the following two should fall under the first condition: If at least 1 is fail, all fail. 1 Pass, 1 Fail, and 1 WIP. 2 Fail...

Try this: Create a table to hold the records. Do not use autonumber in that table; just set the ID field to Number, Long Integer. Then use 5 append queries to append the records from each of the five tables to that table. ^

fConcatenateFldGroupBy didn't concatenate anything on the given five sample records. The same five records were returned. ^

Week numbers ww in the Format() function apply to the year and not to the months in a year. Besides, most of the time, there are 4 weeks and 2 or 3 days in a month. You will have a hard time trying to number the weeks in a month as 1-4. ^

'Adding InStr([tblDescription].[Description], [tblCategory].[Term])>0 to the criteria for desired field' uses the Where Clause to link the table instead of using a join. In Access, a join is more efficient than a link in the Where Clause. And using InStr() in the link still makes the query...

Not that it would matter much given our computer speeds nowadays, but to remove "(", ")" and "-" from (123)456-7890, you need to iterate only three times instead of 13 times if you use Replace() ^

See Jon K's basic criteria format and his Notes (1) and (2) in this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=103312 ^

You can enter the criteria for the [Price] field in a new column in the query grid like the following (using the correct form name):- ................................................. Field: [Price] Between [Forms]![FormName]![Price1] And [Forms]![FormName]![Price2] Or...

I pasted the various names from your db into the DLookup expression in the text box Control Source and was able to change the text box value from 190 to 30 when I moved to the second record. I have attached two screenshot images. They display the DLookup expression and the number 30 in the...

I can't read the text in your version of db. It's all Greek to me. But it seems the DLookup in the top left text box needs to reference the numeric value in a text box in the subform. In English version, something like:- =DLookUp("[Expr1]","queryName","[queryFieldName]=" &...

The time is there. Formatting the column as short date doesn't remove the time. In your code, you can use the DateValue() function to extract the date values:- ................ dShortDate = DateValue(rst![SaleDate]) ................ I agree with Brian. Using an Update Query is the simplest...