User Profile

Collapse

Profile Sidebar

Collapse
pkj7461
pkj7461
Last Activity: Jan 28 '08, 04:10 PM
Joined: Oct 7 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • pkj7461
    replied to Query by Form to search
    in Access
    Hi,
    If you could provide me an example of this, it would he helpful.
    I did try something like this, but no luck.

    IIf([Forms]![Search Form]![cboperator] Is Null Or [Forms]![Search Form]![txtdate] Is Null,Null & [Forms]![Search Form]![cboperator] & [Forms]![Search Form]![txtdate])

    Thanks,
    Prasanna.
    See more | Go to post

      Leave a comment:

    • pkj7461
      started a topic Query by Form to search
      in Access

      Query by Form to search

      Hi,
      I was working on this form to search based on criterias. I added a combobox with the value lists of <,>,=. Now, I also have a text box control to enter date.
      How would I bind the value lists to the text box control?
      Like If I want to retrieve all records for anything >1/2/2008....
      How would I achieve this? Any help will be appreciated.
      Thanks,
      PKJ
      See more | Go to post
      • pkj7461
        replied to Saving Access Query in Excel
        in Access
        Hi Nic,
        Thank you very for your response.
        I wanted to work use Excel Functions after transferring the data. Like formatting and making the spreadsheet presentable.
        How can I make this happen after transferring the data with DoCmd? This was reason behind me sending the data in x1Ws so that i get the Excel Application object.

        Thanks,
        Prasanna....
        See more | Go to post

          Leave a comment:

        • pkj7461
          started a topic Saving Access Query in Excel
          in Access

          Saving Access Query in Excel

          Hi,
          I was using Docmd.Transfers preadsheet to to populate query data in Excel.
          My code so far
          Code:
          Dim xlApp As Excel.Application
Dim xlWb As Excel.workbook
Dim xlWs As Excel.Worksheet

Set x1App = New Excel.Application
xlApp.Visible = True
Set xlWb = xlApp.Workbooks.Open("C:\Daily Open Report Template.xls")
Set x1Ws = x1Wb.ActiveSheet
DoCmd.TransferSpreadsheet acExport,
          ...
          See more | Go to post
          • pkj7461
            replied to Crosstab queries to be exported to same worksheet
            in Access
            Hi Nic,
            I want the queries to be populated in the same sheet. However, there are three different queries to be populated at 3 different places on the worksheet.
            Can UNION query be used for this sort of situation? If you can provide me some online links or throw me some idea to achieve this, it would be great.
            Thanks,
            prasanna....
            See more | Go to post

              Leave a comment:

            • pkj7461
              started a topic Crosstab queries to be exported to same worksheet
              in Access

              Crosstab queries to be exported to same worksheet

              Hi,
              I have three crosstab queries to be exported to the same excel worksheet. How can I achieve this? If there is any link that would explain the form details behind crosstab queries, it would be helpful.
              Thanks,
              Prasanna.
              See more | Go to post
              • pkj7461
                replied to VBA Code to Add function while retrieving data to Excel
                in Access
                Hi, This seems to be not working. I am sorry If i haven't explained this properly.
                My original select statement in Access retrieves one of the columns through module like this: PQRAge:DateDiff W([Create-date],Date()). This works fine when I add them to the select statement in Access.

                However, I am retrieiving the same column with the VBA Code and place them in Excel sheet. The code fills allother data except the PQRAge.
                ...
                See more | Go to post

                  Leave a comment:

                • pkj7461
                  started a topic Adding Column Headers with ADO.net
                  in Access

                  Adding Column Headers with ADO.net

                  Hi,
                  I am running macro code to retrieve data from Access to Excel using ADO.
                  My code is working fine except that I could not add Column headers(that come with SELECT statement of SQL) to the Excel sheet.
                  Thanks,
                  Prasanna.
                  See more | Go to post
                  • pkj7461
                    started a topic VBA Code to Add function while retrieving data to Excel
                    in Access

                    VBA Code to Add function while retrieving data to Excel

                    Hi,
                    I have a column in my Select statement of query that retrievies data based on a Function that is defined in a Module.
                    Like this: PQRAge: DateDiffW([Create-date],Date()).
                    This DateDiffW is defined in the module

                    I am retreiving this data into Excel sheet using ADO.Net.
                    How do I add the module in my select statement.?
                    Thank you for your time,
                    Prasanna.
                    See more | Go to post
                    • pkj7461
                      replied to Crosstab Querty to return all blank fields
                      in Access
                      Hi,
                      Thanks for your suggestion. I have a table which lists last 8 days. How do I outer join and create the query? I am sorry If my question is simple and query might be complex :).
                      Thanks,
                      Prasanna....
                      See more | Go to post

                        Leave a comment:

                      • pkj7461
                        started a topic Crosstab Querty to return all blank fields
                        in Access

                        Crosstab Querty to return all blank fields

                        Hi,
                        I have a crosstab query that always displays last 8 days worth of data(Date(),Dat e()-1,Date()-3, etc)).
                        Some of these columns are blanks and MS Access, by default, returns only those columns that has some values in it. How do I make sure that it displays even the blank columns with the dates in "yyyy/mm/dd" as column headers.My base query is like this.
                        I tried adding Date(),date()-1, etc in the Column headings in...
                        See more | Go to post
                        • pkj7461
                          started a topic Splitting Strings
                          in .NET

                          Splitting Strings

                          I want to split a string based on a pattern. my string is something like this.

                          10/8/2007 5:03:06 PM thakurab *************RE CIVED MAIL FROM MIKE FOR THE PQR AND DPS CRETION******** *************** PQR Start Time: 10/08/07 16:29:09 New PQR State: Assigned Respond Due Date: 10/09/07 00:29:09 Resolve Due Date: 10/10/07 16:29:09 Resolved On: 10/8/2007 5:23:40 PM pandeyra



                          usually, there is...
                          See more | Go to post
                          • pkj7461
                            replied to TimeSpan between Business Days
                            in .NET
                            Hi Shashi,
                            I was working on weekend with the code. I changed the input to
                            Start Date = "10/4/2007 3:26:00 PM"
                            endDate = " 10/7/2007 9:24:00 PM"

                            I ran the code and changed the format of output to "hh:mm"
                            My output was 29:58
                            and the actual output should be 32:33.
                            I noticed one more thing. The output seems to be changing every minute even during weekend.
                            ...
                            See more | Go to post

                              Leave a comment:

                            • pkj7461
                              replied to TimeSpan between Business Days
                              in .NET
                              Hi,
                              Sorry for delay in replying.
                              This seems to be not working. It gives the timespan including weekends.
                              Thanks,
                              Prasanna...
                              See more | Go to post

                                Leave a comment:

                              • pkj7461
                                started a topic TimeSpan between Business Days
                                in .NET

                                TimeSpan between Business Days

                                Hi,
                                I was looking for the code to return Timespan between any two days. The days should exclude weekends, saturday and sunday.
                                Like, for example,
                                startdate = "10/5/2007 10:00:00 AM"
                                enddate = "10/9/2007 11:30:00 AM"

                                The function should return the Timespan between these two days excluding Saturday and Sunday...
                                Timespan ts = 1:12:30:00

                                Thanks in Advance,
                                P...
                                See more | Go to post
                                No activity results to display
                                Show More
                                Working...