Search:
Type: Posts; User: VBFnewcomer
Search:
Search took 0.24 seconds.
-
Is this actually referring to my post??
My post was like this..
I open a form say F1 which accepts two dates (or it could be some other thing as well..) I click OK button on it. The event attached...
-
I tinkered with the queries as suggested by ECniv..
QCaseLatestStage
SELECT QryRetrieveLatestStage.caseID, QryRetrieveLatestStage.caseDate, [caseStage] & IIf(Len(Trim([remarks]))," - " &...
-
QCIPanel = QryCounselInPanel.
SELECT A.*, *
FROM EmpanelmentTran AS A LEFT JOIN [SELECT EmpanelmentTran.counselID, MAX (EmpanelmentTran.empanelDate) AS md
FROM EmpanelmentTran
GROUP BY
...
-
Yeah...
probably MS hates the name of the query :bigyello:
yes connecting with counselMaster does give out the CT..but..
There are 2 imp things...
We need the details of only the cases which are...
-
thanks Ecniv
those things in quotes were just to invite attn of the objs used in the process and not the actual obj name. Don't worry I always stick to the naming conventions as you might have seen...
-
somehow just before posting post #11 the CT came out successfully!??
When I ran a couple of times to be sure, it bombed with the same error in #1
-
I used QryCounselDetails instead of CounselMaster as that contains formatted names..
so now the qryCDtoCounsel looks like this:
SELECT QryCounselDetails.counselName, CaseDetails.caseID,...
-
Ecniv one small thing..should we not play with counselID than name???
and this may not be reqd data
Avg([CountOfcaseNum])
We need to count or total the number of cases (typewise) with each...
-
-
Milk
sorry..but gys are genius...you'd easily guess what it means (no sweat..)...we are going off topic of OP
you meant #11 I presume (#15 is your post)
-
After several days of fighting with DTP I dropped the idea of using it.
Instead I used 2 textboxes and a calendar control 11.0
calendar would be invisible and will show up on mouse down & keypress...
-
They are summarised illustration..
Yes I'll upload
I presume there was typo caseTypeID was missing (or I think so)
SELECT QCounselDetailsOnlyInPanel.counselName
FROM QCounselDetailsOnlyInPanel...
-
Iam reminded of the days when my TV goes kaput..I call the mechanic...mysteriously the TV comes alive again, :bigyello::bigyello: :rolleyes:the moment he steps in!!! I serve him Tea & Biscuits and...
-
see if I give any date of any week this code will not give desired result..Am I correct..
-
seenu
does it mean we cannot retrieve the Monday (or any other day for that matter) of a given date??
-
Thanks Ecniv for responding...
I am not following you...sorry...can you guide me in simpler terms..
Is there some other option to summarize in the way I want...
counsel Name ...
-
Iam trying to make a Crosstab Query of the cases which each counsel has casetypewise..
QCounselDetailsOnlyInPanel ->contains names of all counsels who are currently in the panel...
-
seenu have a look at snippet below...
Sub myDay()
Dim dt As Date
Dim dt2 As Date
dt = #6/15/2011#
dt2 = DateAdd("d", (dt * -1) + vbMonday, Date)
Debug.Print dt2
End Sub
-
Hi,
can someone have some patience and let me know what does (varToday * -1) in do..
DateAdd("d", (varToday * -1) + 2, Date)
BTW this code snippet was for outputting the date on the first day of...
-
I have this code....
Sub hyperlinkAddSpaces()
Dim hyp As Hyperlink
Dim rngHyplinkText As Range
With ActiveDocument
MsgBox .Hyperlinks.Count & " Hyperlinks found"
If...
-
Well I don't think its possible...so I changed my approach..
Now I started from Report..
This 'report' will call the 'form'
form will open a 'query' and supply the parameters to the query,
the...
-
Thankz anhn
could you tell me more about this portion..
Date + vbMonday
also let me know if the below code is equally good or not..
Me.txtStartDate = Date - Weekday(Date, vbSunday) + 2
BTW...
-
Hi
Iam in need of a function (VBA-Access) to return the date on Monday & Saturday of the current week.
May somebody help... :eek:
-
Hi
I have a form (F1) which has 2 txtboxes to hold dates and a OK button.
On cliking OK the parameters from the txtboxes gets passed to a Query (Q1) which runs something like this
SELECT *...
-
could you post the settings reqd..
-
guys any more inputs.........
-
you may need to provide more details for our members to work on..
-
Mind sharing with us the solu.
BTW pls mark your thread as resolve using the Thread tools at the top of the page
:wave:
-
-
Welcome my dear child to the forums...
Why don't you simply make a crosstab query/report from the database/table (BTW what db are you using) if its MS access a wizard will guide you to make one)....
-
This is the code Iam having..
Dim hyp As Hyperlink
Dim i As Long
Dim ch As String
Dim sl As String
sl = " " & vbCrLf & vbTab
With ThisDocument
For Each hyp In .Hyperlinks
...
-
-
Dear Anhn & west,
I did understand what you were saying and already implemented it in the same order as suggested by you....Thanks for your expert guidance.
Ive included a sample file for your...
-
Solaris, there is no option .Text under oField
west,
something like this....
Dim hyp As Hyperlink
For Each hyp In ThisDocument.Hyperlinks
If Not...
-
What I gave was an illustration...It could (and generally is) like this:
For a good programming experience visit thislinkyou would love it.
-
I added your code in a sub just for the 0-9 case (at present) and ran it..nothing happened. Then I put the break point at "Case 0-9" and found that the loop does not enter the line next to it....
...
-
I have a word document which has quiet a few hyperlinks inside the document. It so happens that these hyperlinks literally kiss :p the words before or after it. How about a Macro or something by...
-
The current issue is slightly away from the main topic...but related...so please bear with me...
Yes, but only if it already has no space.They are taken care of..
Take a look at this...
so here...
-
VB Report or Access Report???
why don't you try to make the query you want in access itself and generate a report in access then adopt the same....
-
|
Click Here to Expand Forum to Full Width
|