Search results

  1. J

    Cross Check table

    Thanks a lot Adding these two fields will fix my issue I didn’t think about it thanks again
  2. J

    Cross Check table

    Thanks for your reply Sorry that the problem was not explained properly its not an excel function at all Actually It was in excel and I moved it to a database for better results. And it’s not a prediction . I don’t know where you got this.. if it’s the columns that contain future dates, if I...
  3. J

    Cross Check table

    sorry I thought I replied i was saying The main challenge is that I don’t have an interface. I just run the sql statement in a code. I don’t have the list of quarter dates. That’s why I put future dates My first table has a range of date The second table not necessarily have the complete...
  4. J

    Cross Check table

    Hi I am trying to create a query but couldn’t figure out the logic. I need your help I have tow tables: Table A: Item Start date End date Table B : Item Date (first date of each quarter) I want to create a query to get me something like Column heads are the list of...
  5. J

    SQL to find the year

    Hello, I have a field that contains the date in this format 201109 integer Each row includes cost and that field I want to build sql that gets me the the amounts by year?
  6. J

    First record is showing

    I tried all options! I ended up excluding the first record by hardcoding it.
  7. J

    First record is showing

    I tried it It is brining the old record again Very strange Is there any other tricks
  8. J

    First record is showing

    Hi I am facing a very strange issue. I have a form Inside that form there is a subform When you click in any record in the subform. Some fields are filled in the main form I update those fields and save them through a save button the save is fine But when I refresh the main form It is...
  9. J

    Sql redundant values

    Thanks all It worked I used this one: SELECT Sum(Q.CountOfnum) AS SumOfCountOfnum, Sum([countofnum])-Count(*) AS Expr1 FROM (SELECT Table5.num, Count(Table5.num) AS CountOfnum FROM Table5 GROUP BY Table5.num HAVING (((Count(Table5.num))>1))) AS Q
  10. J

    Sql redundant values

    yes right for the first one the second one You count only the duplicates without the originals So you exclude one 9, one 2 And you count the duplicated values of them The first sql will do
  11. J

    Sql redundant values

    Hi I have a table with duplicate values. What is the sql that gets me the result 5 (total of values of redundant fields) from below table. And is there any way to get the redundant values only without keeping the original. In the case below, how to get the result 3 Number: 8 9 9 9 2 2 1 5 3
  12. J

    Subform locked fields

    I changed it to dynaset And it worked Many thanks
  13. J

    Subform locked fields

    Hi I have a subform container in a main form. That subform is locked I can’t edit the fields. After investigations, I found that the reason why I can’t edit them is because I am using a subform to read a query that uses sql join. I still need to use that subform and edit it. Is there any...
  14. J

    Enter Parameter value

    In my main form I have three subforms that I am loading That’s all But I checked each one of them They don’t include that field What do you mean by left over field name i checked the controls as well
  15. J

    Enter Parameter value

    Hi, I have deleted a field in one of the tables in my access file. Now when I run the interface main file I started ti see this new window asking me about parameters of other fields that I didn’t remove. I went through the code the queries I don’t see anything relevant to the field that I...
  16. J

    Run Excel Macro from Access

    Thanks a lot This is really helpful
  17. J

    Run Excel Macro from Access

    I want to call the excel and run the embedded code there in excel can you advise how to do that
  18. J

    Run Excel Macro from Access

    That’s a good idea Is there away to automatically opening excel and running the macro from access. i usually use a button to run the macro Can I run it once I open the excel
  19. J

    Run Excel Macro from Access

    Ok the code above worked correctly I added the latest activex library I also needed to add a delay of few seconds to be able to allow the table to refresh get the fields from excel. its working fine now Thanks all
  20. J

    Run Excel Macro from Access

    Public Function runExcelMacro(wkbookPath) Dim XlApp As Excel.Application Dim XlBook As Excel.Workbook Dim xlsheet As Excel.Worksheet Set XlApp= CreateObject("Excel.Application") Set XlBook= X1App. Workbooks.Open ("\Documents\R.xlsx") Set xlsheet= XlBook.Worksheets ( "Sheetl") Dim url As...
Top Bottom