Sweeda
Last Activity: May 18 '12, 08:44 PM
Joined: Mar 6 '12
Location:
-
I correct myself, i'm SURE that the problem is not the simultaneous work on the same record, I tried it, and it works perfectly -
Error 3197 on Access 2010 apparently with no reasons
Hi guys, as you read in the title, I've got problems with more than one record in a table:
On opening the form that displays the field it appears the error 3197
"The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time"
I've lost data of those fields and it looks like there's no way to get them back.
Apart... -
Thank you very much, it works, could you explain to me the "passages" of the calculation?
Without the "minus" it should give me something like: (-1) + (-1) + (-1) = -3
but it didn't, it gave me just another true or false.
What does -sum() mean?
Thank you so much, very kind as always
have a nice dayLeave a comment:
-
Are you sure that is possible to SUM records of a "Yes/No" field? It doesn't look working..
Ok, I post some detail:
...Code:SELECT DISTINCTROW Count(Estrazione_mese.Trasporto) AS ConteggioDiTrasporto, Count(Estrazione_mese.Banchina) AS ConteggioDiBanchina, Count(Estrazione_mese.Attesa_Ritiro) AS ConteggioDiAttesa_Ritiro, Count(Estrazione_mese.Anagrafica) AS ConteggioDiAnagrafica, Count(Estrazione_mese.Efficacia)
Leave a comment:
-
How do I count how many "Yes" are in a "Yes/No" field through a query?
Hi everybody,
I'm trying to make a selection(?) query that counts how many "true"(or "Yes") are in several "Yes/No" fields. I've read something about a "dcount" function but I didn't completely get how to use it in the SQL code of the query. Could you please help me? Other solutions?
Many thanks
Matteo -
The problem were the quotes " . In VBA they must be ' * ' instead of " * ". It works.
Thank you everybody guys, you've been very kind and usefull
@ChrisPadgham i'll study how to use this nz funcion to semplify very much my code, thanksLeave a comment:
-
And % or _ are not accepted, they give errors. It's strange 'cause " * " doesn't give error, but the query is created empty :SLeave a comment:
-
Ok, the problem is: SQL= ".... Like "*" ....;" I can't use it in vba. Alternatives?Leave a comment:
-
Thank you Mihail, it doesn't give me any error but the final new query "Estrazione " is still empty (SQL code that i find is: "SELECT;"). . :(
is this correct?
Set qdfNew = CurrentDb.Creat eQueryDef("Estr azione", codiceSQL)Leave a comment:
-
Mihail, thank you but i don't think i can understand that post.. i'm quite a noob. And I hope to find something easier :)Leave a comment:
-
MMMh.. i tried this as you suggested but the new query is always empty, is it a problem with a too long string or what else?
...Code:On Error Resume Next Dim codiceSQL As String Dim qdfNew As DAO.QueryDef 'DELETE the pre-existing Query (may/may not exist) CurrentDb.QueryDefs.Delete "Estrazione" If (IsNull(Me![Forms]![Estrazione]![Text9]) And IsNull(Me![Forms]![Estrazione]![Text11])) Then
Leave a comment:
-
How do i use an IF condition in a SELECTION query?
Hi everybody,
i'm trying to write a selection query that filters a list of records which the "date" field value is BETWEEN a minimum and a maximum values. These values must be taken from a form IF they are not empty. If they are empty the query must return the whole unfilterd list.
I don't know how to insert an IF condition in a SELECT....WHERE function.
Many thanks for your attention
No activity results to display
Leave a comment: