Search:

Type: Posts; User: VBFnewcomer

Page 1 of 13 1 2 3 4

Search: Search took 0.24 seconds.

  1. MsOf03 Re: Access 03 - Pass parameters/values from Form->Query->Report

    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...
  2. Re: Crosstab - MS database engine does not recognize 'a.counselID' as a valid field/e

    I tinkered with the queries as suggested by ECniv..
    QCaseLatestStage

    SELECT QryRetrieveLatestStage.caseID, QryRetrieveLatestStage.caseDate, [caseStage] & IIf(Len(Trim([remarks]))," - " &...
  3. Re: Crosstab - MS database engine does not recognize 'a.counselID' as a valid field/e

    QCIPanel = QryCounselInPanel.

    SELECT A.*, *
    FROM EmpanelmentTran AS A LEFT JOIN [SELECT EmpanelmentTran.counselID, MAX (EmpanelmentTran.empanelDate) AS md
    FROM EmpanelmentTran
    GROUP BY
    ...
  4. Re: Crosstab - MS database engine does not recognize 'a.counselID' as a valid field/e

    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...
  5. MsOf03 Re: Access 03 - Pass parameters/values from Form->Query->Report

    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...
  6. Re: Crosstab - MS database engine does not recognize 'a.counselID' as a valid field/e

    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
  7. Re: Crosstab - MS database engine does not recognize 'a.counselID' as a valid field/e

    I used QryCounselDetails instead of CounselMaster as that contains formatted names..
    so now the qryCDtoCounsel looks like this:

    SELECT QryCounselDetails.counselName, CaseDetails.caseID,...
  8. Re: Crosstab - MS database engine does not recognize 'a.counselID' as a valid field/e

    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...
  9. Re: Crosstab - MS database engine does not recognize 'a.counselID' as a valid field/e

    by all means..
  10. Thread: Code Help

    by VBFnewcomer
    Replies
    19
    Views
    838

    MsOf03 Re: Code Help

    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)
  11. Re: Access 2003 - Passing Parameters to Query from a form

    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...
  12. Re: Crosstab - MS database engine does not recognize 'a.counselID' as a valid field/e

    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...
  13. Replies
    8
    Views
    983

    MsOf10 Re: Excel - Problem running VBA Code

    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...
  14. Thread: Code Help

    by VBFnewcomer
    Replies
    19
    Views
    838

    MsOf03 Re: Code Help

    see if I give any date of any week this code will not give desired result..Am I correct..
  15. Thread: Code Help

    by VBFnewcomer
    Replies
    19
    Views
    838

    MsOf03 Re: Code Help

    seenu
    does it mean we cannot retrieve the Monday (or any other day for that matter) of a given date??
  16. Re: Crosstab - MS database engine does not recognize 'a.counselID' as a valid field/e

    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 ...
  17. Crosstab - MS database engine does not recognize 'a.counselID' as a valid field/expre

    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...
  18. Thread: Code Help

    by VBFnewcomer
    Replies
    19
    Views
    838

    MsOf03 Re: Code Help

    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
  19. Thread: Code Help

    by VBFnewcomer
    Replies
    19
    Views
    838

    MsOf03 Code Help

    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...
  20. Replies
    9
    Views
    1,275

    MsOf03 Re: Hyperlinks Add Space before & After

    I have this code....

    Sub hyperlinkAddSpaces()
    Dim hyp As Hyperlink
    Dim rngHyplinkText As Range

    With ActiveDocument
    MsgBox .Hyperlinks.Count & " Hyperlinks found"
    If...
  21. MsOf03 Re: Access 03 - Pass parameters/values from Form->Query->Report

    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...
  22. MsOf03 Re: Access - Function to return the Date (Monday & Saturday date of current week

    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...
  23. MsOf03 Access - Function to return the Date (Monday & Saturday date of current week

    Hi
    Iam in need of a function (VBA-Access) to return the date on Monday & Saturday of the current week.
    May somebody help... :eek:
  24. MsOf03 Access 03 - Pass parameters/values from Form->Query->Report

    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 *...
  25. Replies
    50
    Views
    116,341

    Re: vb6 - send email with attachment using smtp

    could you post the settings reqd..
  26. Replies
    17
    Views
    1,342

    MsOf03 Re: Find Replace - With wild cards

    guys any more inputs.........
  27. Replies
    3
    Views
    829

    Re: problem splitting values

    you may need to provide more details for our members to work on..
  28. Replies
    4
    Views
    725

    Re: Wrong Number of Arguments error

    Mind sharing with us the solu.
    BTW pls mark your thread as resolve using the Thread tools at the top of the page
    :wave:
  29. Re: create crystal report on the basis of query

    What's this in #1???
  30. Thread: reporting

    by VBFnewcomer
    Replies
    1
    Views
    560

    Re: reporting

    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)....
  31. Replies
    9
    Views
    1,275

    MsOf03 Re: Hyperlinks Add Space before & After

    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
    ...
  32. Replies
    9
    Views
    1,275

    MsOf03 Re: Hyperlinks Add Space before & After

    what's sl for??
  33. Replies
    17
    Views
    1,342

    MsOf03 Re: Find Replace - With wild cards

    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...
  34. Replies
    9
    Views
    1,275

    MsOf03 Re: Hyperlinks Add Space before & After

    Solaris, there is no option .Text under oField
    west,
    something like this....

    Dim hyp As Hyperlink
    For Each hyp In ThisDocument.Hyperlinks
    If Not...
  35. Replies
    9
    Views
    1,275

    MsOf03 Re: Hyperlinks Add Space before & After

    What I gave was an illustration...It could (and generally is) like this:
    For a good programming experience visit thislinkyou would love it.
  36. Replies
    17
    Views
    1,342

    MsOf03 Re: Find Replace - With wild cards

    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....
    ...
  37. Replies
    9
    Views
    1,275

    MsOf03 Hyperlinks Add Space before & After

    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...
  38. Replies
    17
    Views
    1,342

    MsOf03 Re: Find Replace - With wild cards

    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...
  39. Re: retreive value from textbox to crystal report

    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....
  40. Re: create crystal report on the basis of query

    Naw must be a twin bro
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width