Posts by Andrey Queiroz Minorelli • 29 points
4 posts
-
0
votes1
answer25
viewsA: Dsoma using form as source
I was able to figure out how to solve the problem. I fed my text field via VBA itself. Dim txtReceitas AS Currency Dim txtDespesas AS Currency txtReceitas = Nz(DSum("[valor_total]", "t_registros",…
-
-1
votes1
answer25
viewsQ: Dsoma using form as source
Halp! I need a text field in my form to show the sum of a given field, where the form is the source using a criterion. I can get Dsoma to run with the code below. However, as the source is the…
-
1
votes1
answer110
viewsA: ACCESS VBA - Consultations with several periods
To whom it may interest... I have solved my problem with date formatting. Follows code: If Not IsNull(Me.cboPeriodos) Then If Me.cboPeriodos = 1 Then strWhere = strWhere &…
-
2
votes1
answer110
viewsQ: ACCESS VBA - Consultations with several periods
Good afternoon! I’m creating a chart query form. Inside the form I have some comboboxes store a string in a variable and when the client clicks to filter this string is inserted inside the "WHERE"…