Search results

  1. S

    automated import data from other file

    yes exactly, my file 99% is the standard output and it does not have a 100% unique identifier for each record, so it depends on the attention of who import In general, there is tthe montlyu report which is imported in one sheet. Next month in another sheet For what i know this is the standard...
  2. S

    automated import data from other file

    let me clarify the file that come from the bank don't have duplicate, for sure Duplicate may occur if i import more than once data from the original bank's file. si don't think there is a problem with it just need how to make asemiautomted import
  3. S

    automated import data from other file

    i don't know how to do it! :) for the report, i must ask for original one, i have one file but i am not sure it is original or it is in some way edited already
  4. S

    automated import data from other file

    it is a bank report, there are 4 column: date1, date2,ampount,description..it's difficult that duplicate come..not impossible though. also it depend on the wise of who import.. when import the montly (and this is what normally happen) report no problem..each month has its own sheet; problem can...
  5. S

    automated import data from other file

    Hello i want to build an automation that would let me import data from another file The file is a bank report, so it has several column First i need to filter what records to i mport: looking at the money amount i should import all records that have a - before the amount. Like -100. -120, -70...
  6. S

    fetching multiple data from other file/sheet

    Hello, i need to do basically this task. From fileA, fetch through a dropdown or whatever else if better, data from fileB I can do that, bu to me it is not nice, as i need to have both open..so i might copy this data to fetch from withen the same file A, if there are not other way to do Now...
  7. S

    link record to another record in the same table

    I am not sure we understand each other.a user in the website.need.a code to enroll in.this code belong to an agent, and this code cannot be simple as a only 1 digit number. So he.cannot use the id if the agent for example as it is too simple and might lead to unexpected behavuour
  8. S

    link record to another record in the same table

    i have thought to use one of those fields, agent id or pk..but they are too easy When a user go to register in the site it canno thappen that register for a mistake If a code is 1,or 2 or 3...it is easy to input a wrong code and having working the same Thte code should be a bit more complex..at...
  9. S

    link record to another record in the same table

    ok for the "bug" i suspect it could be that actually FOr the modification..how would you do that? I am doing all the edit needed for my pourpouse and it is working fine though there is a point..i really need to use the code instead of the name in SALES..in all other forms, i want to see NAME...
  10. S

    link record to another record in the same table

    i am not sure if we are talink the same thing. Let's make it simplier I want to use a code instead of agent name for the operation in the db Instead to put the sale to , let's say, Paul, i want to use his code..let's say ABC. Of course i want to see the nalme also, but i'd rather input data...
  11. S

    link record to another record in the same table

    if my idea i have explained can work i think i can do it by myself also
  12. S

    link record to another record in the same table

    one question, it will require a bit of edit if it can be done is nice otherwise can stille manage Datas that are feeded in the db comes from the website where final clients register using a code So for example the client STEFANO if register through the invitation of the main agency (CAPITAL1)...
  13. S

    link record to another record in the same table

    i thought also that is open but really cannot find anywhere. Also why it does like that only after that small edit?anyway with this command it works..it open it full size which is not very nice but it opens!
  14. S

    link record to another record in the same table

    something funny, at least for me, happen with this report rptProcessedBySale This report has a field too small "OrganizationEffectiveDate", so i mve a little to the right the royaltyes note field, iand i enlarge a little the effective date After that the report don'open anymore... i don't do...
  15. S

    link record to another record in the same table

    let me understand..if i use the form clear old data now..do i delete all at once now?
  16. S

    link record to another record in the same table

    by the way, just discovered that the new mask which is supposed to delete the whole database infact don't delete it all I upload the db which contans my last edit..and see the table that are still populated after i have delete them with the delete mask
  17. S

    link record to another record in the same table

    hello i am trying to resize for laptop use..which is very different for the size of mask First question...is there a general rule to make the mask look good for a desktop and for a laptop? I have set the mask to "customizable" dimension, and i can make it smaller or bigger....but if i make i...
  18. S

    link record to another record in the same table

    acrtually better to move the 2 windows in processed sales in a new page before report..so thesales will have more room(i am thinking to latop user)
  19. S

    link record to another record in the same table

    ok i se the issue with the organization is when i made more change the same day of work...they are not reflected. ig i change the pc date to tomorrow and male a change then i see it-.-.but if i make another change without changing again the pc date to the next daythis chage is not shown... i...
  20. S

    link record to another record in the same table

    aahh yes..of course i know name must be the same..just made a mistake. I think this was the only problem as the inactive date was earlier then the sale date and processed date. Now works..just correcting the name Why the details organization of the structure is not shwown anyway? One more...
Back
Top Bottom