I have a continuous form with information on it, I want to send the email to individual student whom I should clicked with option box, I can see the email address on the form, name of students, and also want to include all amounts field (which are 3 also showing on form), one student can have...
I have found the Solution:
Just use one line code:
Application.FollowHyperlink "directory and dbname.mde"
and set the opening form in the specified db as autoexec.
i have one access db, where i have created few buttons, when i click one of the button, it opens to new db and specified form with this code:
Dim ObjAccess As Object
Set ObjAccess = CreateObject("Access.Application")
ObjAccess.Visible = True
ObjAccess.OpenCurrentDatabase "Here comes the...
so should i take the last month as enddate and minus other months, but i have to take the first of each months and both row and columns Headings are dates as i showed above.
my dates are monthly but first of each month, and FAQ703-5466: Dynamic Monthly Crosstab Report. is for 12 months in my case there are 5-6 years worth months - this is big problem, how to represent so many months
I am attaching source table, which has to change to Crosstab query and then to Crosstab report. but considering in future that more rows for new dates would be added:
Date1 Date2 Amount
3/1/2008 3/1/2008 $64,172.42
1/1/2008 1/1/2008 $54,007.65
2/1/2008 2/1/2008 $52,832.55...
But in dynamic report i have to create labels and text boxes on report design before run that report, though it is easy to find out the number of columns in advance, but point is that i have to design this and give to users to run, it is not my hand to add more labels every month after counting...
I want a report from a crosstab query. The Crosstab query which has RowHeading- Date, ColumnHeading - Date and MoneyRecv - Amount.
I dont know the dates (number of columns, could be sometimes more than 40 and every month it increased by one), Yes if i know the ColumnHeadings (Dates) then i can...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.