Hi Jim,
I Made this sintax for DLookup to include the criteria. If I select range in the form then provide the Stores Numbers in that range but this no working.
This is the sintax I made for DLookup:
Dim look As String
look = DLookup("[StoreNum]", "tblStore", "[ReportDate]>=#" & [Forms]![frmDateRangeSto re]![BeginDate] & "# And [ReportDate] <=...
ElTipo
Last Activity: Sep 16 '11, 04:29 PM
Joined: Jul 27 '07
Location:
-
Yes, the table have many rows..Leave a comment:
-
Sorry for my late to response & my English Jim,
I try the two steps with case an if and not work really. The function goes to the else and show me only the message box and skip the do command send object. I proceed to check the data in the table and the stores numbers exists in the table.
Thanks for your time Jim,
If any idea for this please write thansk again!...Leave a comment:
-
Cancel Send Objects Command while Null Values exists in Table
Ok,
I have 3 stores to send a one report on click command botton. I need to write in the VBA if the store 1 is Null in the table then proceed with other.
...Code:Dim look As String look = DLookup("[StoreNum]","tblStore") IF look = "1" then DoCmd.SendObject acReport, "1", acFormatSNP, "[EmployeeName]", "[SupervisorName]", "[ -
Thanks ADezii for your time the sintax work but only showme the first line result (1) for this nested IF and not change for the second IF situation.
Ex:
...Code:If IsNull(Me![Datefield1]) And Not IsNull(Me![Datefield2]) Then Me.[ResultTextbox].Value = 1 Else If Not IsNull(Me![Datefield3]) And Not IsNull(Me![Datefield4]) Then Me.[ResultTextbox].Value = 0.5 Else Me.[ResultTextbox].Value = 0
Leave a comment:
-
Unbound Text Box = 0 in Form
Great People!
I need some help in this instruction. Ok I have two fields text boxes dates and one text box showme any result but the result text box only show me a zero 0 as result. I need in this result 0.5 if the two fields are Not Null.
All this is in VBA in a Form nested If with the same instructions but other results example 0.75 or 1.
Ex:
...Code:If Me.[Datefield].Value <> Null And Me.[Datefield].Value
-
So, it's possible to put these fields in one in a query and show the greater date?Leave a comment:
-
Is Posible to create in the Query Column?...Leave a comment:
-
Multiple Date field and Obtain the Maximun Date
Hello People!
I have 3 fields dates. Example: Date1, Date2 and Date3. I don't know how obtain in this 3 fields the greater date.
Ex:
If Date1 = 01/01/08 and Date2 = 01/02/08 and Date3 = 01/03/08
then the field show [Date3].
These fields are for a data entry and the query I made most show for these fields the maximun date field.
Any One!!!
Th... -
DCount() Usage
Here is the real example issue:
I have a table named [products]. I need to count only one in list.
[ID] [ProdName] [price]
1 paper $1.00
1 paper $1.00
2 pencil $2.00
=Dcount([tblproducts],[ID], [ProdNamed]="Papaer") - This is correct? I need to count in the text box report only the paper product. But no work the Dcount to diference count.
¿How?
... -
Thanks! Sorry I can't explain clearly.
Here is the real example issue:
I have a table named [products]. I need to count only one in list.
[ID] [ProdName] [price]
1 paper $1.00
1 paper $1.00
2 pencil $2.00
=Dcount([tblproducts],[ID], [ProdNamed]="Papaer") - This is correct? I need to count in the text box...Leave a comment:
-
Dcount field
Hi People
I need to count different products in a report textbox or put the expression in a query for example:
=Dcount([productsID]).
¿How i can't this? -
Send two objects by e-mail
Hello !
I Try to send two objects reports with this code
DoCmd.SendObjec t acReport, "TEST1", "TEST2", acFormatSNP,
The reports are Test1 and Test2. But don't work because the comma passed to the format and the code no permit to write other object.
How this code permit to include two objects for send in a command botton?
Thanks everyone! -
Thanks Again Neo,
Is possible to write an SQL Code in the text box? If I create a textbox like
=Min[Start Date] to Max[End Date]
and this show the minimum and maximun for type user range.
Sorry for my english.
I try the code to view the resultLeave a comment:
-
Query Date Parameter Write in Report
Hello People,
Is possible to write in reporte a query parameter? example
Between [Start date] and [End Date]
I need to put in report the Start date and End Date if the user put this date range in the popup parameter.
Is possible? -
Thanks Neo
- I determine credits and debits with this formatt $#,##0.00[Black];($#,##0.00)[Red];\0;
- Yes I want to count....Leave a comment:
-
Thanks, but the field have amounts. If the amount is in black color like debits then count 1 else 0. Otherwise if is in red like credits count 1 else 0. I only one field for amounts the formatt I used to determine credit o debits in the text box report is $#,##0.00[Black];($#,##0.00)[Red];\0;...Leave a comment:
-
Count Debits or Credits Amounts
Hello People
I need to know if is possible to count Debits or Credits Amounts for example:
IIF([field] = debits then 1 else 0
or
IIF([field] = Credits the 1 else 0
To count the portion in debits or Credits.
I need to type this IIF in a query to determine de calculation but i dont know how is the correct formatt for this..
Thanks every one -
History Data in Access 2003 Report
Hello People,
I need some help,
I need to know how I made a report with old data like a history data. For example if you need to see anual data from 1/1/06 to 12/31/06 for any amounts. If any know a site for reports examples please let me know.
Thanks!! -
Hello Scott, thanks for your answer.
Yes, where users can do this repeatedly. They use the reports and agree with their password....Leave a comment:
No activity results to display
Leave a comment: