Recent content by Ashfaque

  1. A

    Active Content in this file is blocked. Review your trust center setting

    FE was on local table. I had reinstalled Access and it worked but did not understand the real error. Thanks for all the help. Regards,
  2. A

    Active Content in this file is blocked. Review your trust center setting

    I think SQL server is stopping to run Macro and connections.....I dont know yet....
  3. A

    Active Content in this file is blocked. Review your trust center setting

    FE is on pc and the back end is on SQL Server. Upon opening log in menu, it connects tbl as required. FE in D:|Ashfaque and BE on SQL SErver
  4. A

    Active Content in this file is blocked. Review your trust center setting

    Hi, I have copied my db to new pc and and the above msg is appearing and db cant run. I opened trust center and selected "Enable all macros (not recommended.......) in Macro Setting also I selected "Enable all controls without restrictions and without promting...(last option selected) Still...
  5. A

    Running Sum Using Query

    How about if we need both British and USA date format to work....I mean "dd/mm/yyyy" or "mm/dd/yyyy" Could it be ?
  6. A

    Running Sum Using Query

    Thanks Gasman, that was the exact point I missed. My date format was different than the normally I used. Thanks for pointing ....very much appreciated.....
  7. A

    Running Sum Using Query

    Did some one run this form ? When we receive payment 130, it should clear first circled invoice and then of 290 and 50. The query is doubling amount at first record which I want to stop and accumulate from next same customer only then query result would be ok Any other thoughts ...
  8. A

    Running Sum Using Query

    Better I will attach here my FE and BE with min records and tbls etc so that it would be easy for you. Please enter in db with Shift +Enter to see the tbls, queries, forms etc. You may directly run form "F_CrSalesInvStatus_Master". This was created to clear OLDEST invoices as and when paid by...
  9. A

    Running Sum Using Query

    But at me it is strange....
  10. A

    Running Sum Using Query

    Hello, This query created to produce Running Sum of the invoices of same customer. But even it producing double amount when there only one invoice for that particular customer. Previous I used this query and it was working. May be there has been changed somewhere which I didnt clear about...
  11. A

    Want to know about "Select Top 1000 Rows"

    Hi, Since SQL Server commands are not that much familier I am with, I like to know about below to menu when I right click on my sql server tbl. Select Top 1000 Rows Edit Top 200 rows In second menu (Edit Top 200 rows) I can make changes in records as requires but records are more that 200 so...
  12. A

    Solved How to change date portion at beginning

    Yes, I did split formula as advised and as shown in sample db of Arnel. And it worked.... Thanks all of you guys.....
  13. A

    Solved How to change date portion at beginning

    If I use your first formula line in B2 then "#NUM!" is appearing. my data is in A2
  14. A

    Solved How to change date portion at beginning

    Thanks all of you gents. Let me clear it again: The date format I received in EXCEL sheet in one column is follows: 21:01:23*2021-04-24 I want this date to split into other 2 columns of same excel sheet: in first column 24/04/2021 23:01:21 and in second column day of this date with...
  15. A

    Solved How to change date portion at beginning

    Hi, I have following date data received from a website. I collected these dates in Excel. Basically this is Immigration Entries at the airport that show a person has immigrated on so n so date and time. But airlines date format is typical like below. 00:29:19*2008-12-25 14:25:20*2009-09-17...
Top Bottom