User Profile

Collapse

Profile Sidebar

Collapse
didajosh
didajosh
Last Activity: Mar 5 '15, 09:59 PM
Joined: Aug 6 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • OK this I got this far:

    Code:
    Dim rng1 As Range
    Dim rng2 As Range
    
    'Finding last cell
    
      Dim lRealLastRow As Long
      Dim lRealLastColumn As Long
      Range("A1").Select
      On Error Resume Next
      lRealLastRow = Cells.Find("*", Range("A1"), xlFormulas, , xlByRows, _
                                                   xlPrevious).Row
      lRealLastColumn
    ...
    See more | Go to post

    Leave a comment:


  • Holy monkey this worked like magic!!!!
    Wow, thank you for helping me!!

    OK so I simplified my problem to easily explain here.
    And I thought I will get the hint and take it from there.

    I am sorry for pushing my luck, but I am clueless in VBA.

    Its slightly more complicated than that...
    My data range is inconsistent. And I have a file header and a file trailer.

    My excel file looks...
    See more | Go to post

    Leave a comment:


  • didajosh
    started a topic Export csv file from excel with line breaks

    Export csv file from excel with line breaks

    Please help me
    Here is what my data looks like in excel:

    NAME--ADDRLINE1--ADDRLINE2--CITY--STATE--ZIP--COUNTRY
    DJ----12 APT 2---EAST LANE--NEW YORK--NY--45658--USA
    MJ----13 PARK MAR--NORTH LANE--NEW YORK--NY--45658--USA

    I want to export this in a text/csv file so that it looks like:

    DJ
    12 APT 2
    EAST LANE
    NEW YORK
    NY
    45658
    USA

    ...
    See more | Go to post

  • didajosh
    replied to Merging result from three queries
    Hi,
    thank you for replying.
    Here is he kind of result I am looking for:

    01-Sam-001-AA-$10-10.00-01012009-DENTAL-$20-$30
    01-Sam-001-BB-$10-10.00-01012009-HOUSE-$20-$30
    01-Sam-001-CC-$10-10.00-01012009-HEALTH-$20-$30

    HOw can I get this kind of result.
    See more | Go to post

    Leave a comment:


  • didajosh
    started a topic Merging result from three queries

    Merging result from three queries

    I have three queries fetching data like:
    Query 1
    ID---NAME-POSITION
    01---Sam---001
    01---Sam---002
    02---Joe---002
    03---Zach--003
    -----------------------------------------------
    Query 2
    ID---EARN_CODE-----GROSS-----HOURS
    01----AA-----------$10-------10.00
    01----BB-----------$10-------10.00
    01----CC-----------$10-------10.00
    02----AA-----------$10-------10.00...
    See more | Go to post

  • didajosh
    started a topic Oracle certification question

    Oracle certification question

    Currently I am working as a data analyst.I write simple queries in TOAD to fetch data from Oracle database and then represent it in reports etc. By simple I mean all of them are SELECT queries.
    I briefly studies DBMS in my education.
    I am thinking of Oracle certification, but every time I look for information I am kind of overwhelmed.

    So far what I understood is, there are two paths to do this:
    -Developer Track...
    See more | Go to post

  • didajosh
    replied to Is this a Access 2007 bug or is it me
    @ Hype261
    Ok I got it. There is a way to reproduce it...
    Follow the exact same steps but for a NEW REPORT, not form.
    Also Thank you for trying this scenario at your end. Now I know it behaves alright in case of a form.
    I think this brought me really close to solving my original problem.Once solved I will update it in the forum.
    See more | Go to post

    Leave a comment:


  • didajosh
    started a topic Is this a Access 2007 bug or is it me

    Is this a Access 2007 bug or is it me

    -Open blank form in design mode.
    -Insert chart
    -It will ask for a source of data query/table, choose any.
    -Hit finish
    -The data displayed is I guess Northwind data!
    -More over, dbl click on the chart
    -It goes to Microsoft Graph, the data in the data sheet is noting like the data source you selected, again I guess its North Wind data.
    -In Form view, it will show you your data in hideous formatting...
    See more | Go to post

  • didajosh
    started a topic Combination graphs in Access

    Combination graphs in Access

    Hi,
    I am trying to represent the following information in the form of a bar and line graph.

    Category-------Market Value------%Val
    -----------------------------------------
    CASH----------21419982.09-------34.28%
    TREASURY------5578345.75--------8.93%
    OBLIGATIONS---14314905.48-------22.91%
    FOREIGN-------560301.5----------0.90%
    MUTUAL FUNDS--16721157.8--------26.76%
    ASSETS--------4171278.58--------6.68%...
    See more | Go to post
    Last edited by didajosh; Mar 30 '11, 09:37 PM. Reason: formating

  • I got a solution for this.
    My bad, the field Fiscal Year, had a lot of issues, and that was causing all the trouble. I fixed it and the report is working fine.
    See more | Go to post

    Leave a comment:


  • #Error-in Print Preview of report, Report View is alright

    Hi,
    I am working on a accounting report.it looks like
    -------------------------------------------------------------------------------------------
    Group code (group by)
    Org Code(group by)

    Account---Acct.Desc.---2009-2010Budget---Nov2009Budget---Nov2009Actual
    -------------------------------------------------------------------------------------------
    The 3rd,4th,5th column headings in this report depend...
    See more | Go to post

  • didajosh
    replied to Disable navigation button
    Hi,
    Thank you so much for the help.I am very grateful to you guys.
    I clubbed the two solutions suggested to me.
    It works perfectly.
    Its in the Current event of the form. And its for previous, next, first and last buttons.
    Code:
    With Me
      CmdPreviousRecord.Enabled = ((.Recordset.AbsolutePosition > 0) Or (.NewRecord))
      CmdNextRecord.Enabled = ((.Recordset.AbsolutePosition <> .Recordset.RecordCount
    ...
    See more | Go to post
    Last edited by NeoPa; Apr 21 '10, 08:13 PM. Reason: Please use the [CODE] tags provided

    Leave a comment:


  • didajosh
    replied to Disable navigation button
    Hi Pat,
    Thank you for your generous help. I really appreciate it.
    I need to try this and will get back with you.

    Dipali
    See more | Go to post

    Leave a comment:


  • didajosh
    replied to Disable navigation button
    Hi,
    I guess I found a solution.
    Code:
     Dim rst As Recordset
       Set rst = Me.Recordset
       If rst.AbsolutePosition = 0 Then
       Command28.Enabled = False
       Else
       Command28.Enabled = True
       End If
    It works perfectly. I just stumbled on "AbsolutePositi on".
    I am not sure if its alright to use it, or if this is the right way.

    -Dipali
    See more | Go to post
    Last edited by NeoPa; Apr 21 '10, 12:08 PM. Reason: Please use the [CODE] tags provided.

    Leave a comment:


  • didajosh
    replied to Disable navigation button
    Hi,
    Thank you for your time and suggestions.
    I tried to implement what zepphead80 told me.

    I don't think rst.BOF would just always evaluate to true, on the contrary its always evaluating as False. I put a couple of msg boxed to check if the condition is being satisfied or not (following code) but turns out "True" msgbox never appears.
    Code:
       Dim rst As Recordset
       Set rst = Me.RecordsetClone
    ...
    See more | Go to post
    Last edited by NeoPa; Apr 21 '10, 12:08 PM. Reason: Please use the [CODE] tags provided.

    Leave a comment:


  • didajosh
    started a topic Disable navigation button

    Disable navigation button

    I have made a form and added navigation buttons using the wizard.
    When the focus is on the first Record, I want the "Previous Record Button" to disable.
    So in the code in Click event I want to write something like:
    Code:
    If Current Record = BOF
    then Command82.Enabled = False 
    End if
    How do I write this...?
    See more | Go to post
    Last edited by NeoPa; Apr 20 '10, 01:02 PM. Reason: Please use the [CODE] tags provided.

  • NeoPa....
    this works...this works...this works...!!!!!
    i was loosing my mind...thank you soo much....i really appreciate it...
    See more | Go to post

    Leave a comment:


  • Subtracting the sub total instead of adding in Grand Total

    I am grouping a report on the basis of "Org-Code".
    There are two "Org-Code"- "601" Income and "602" Expense.
    It calculates sub totals accordingly.
    In the grand total, it simply sums everything. Instead I want the difference.

    I tried adding a Text box in the report footer field, and its control source as :
    Code:
    (IIf ([Org-code] = '601', sum (amount)) -
    IIf
    ...
    See more | Go to post
    Last edited by NeoPa; Feb 25 '10, 11:13 PM. Reason: Please use the [CODE] tags provided

  • didajosh
    started a topic Fields look black in Access form.

    Fields look black in Access form.



    http://picasaweb.google.com/lh/photo...eat=directlink


    Kindly refer to the attached screen. If that does not work, I there's the Picasa link.
    I have created a from in Access, why do these fields look black? It looks like it has mouse focus on it.

    Please help.
    Dipali...
    See more | Go to post

  • didajosh
    started a topic How to get rid of duplicate value

    How to get rid of duplicate value

    This is a report for Payroll.
    After doing a LOT of work on various tables, doing SUM and Left join, I have achieved the following result:

    ID-----NAME------POS-ID--JOB-DESC--------EARNINGS---------EMP-SUM
    01------DJ------------02--------READER----------100---------------10
    01------DJ------------02--------WRITER-----------122---------------10
    02------JM------------03--------CALLER-----------200---------------50...
    See more | Go to post
No activity results to display
Show More
Working...