Search results

  1. S

    how could i do that with access?

    what i mean is that the operator will input some data, in the image above are the Lines I001 I002 ecc.... Those should contain string of caracters, one for each corrispondent column When the conditions that "activate" a column are found then that column is an output to consider. I have called it...
  2. S

    how could i do that with access?

    hi i have an excel table which explain the thing I tell you more about the datas, they are for grafology studies on the row are the input possibility , and each line describe a feature of a calligraphy on the column are responses so each row can give an X, or an A,or B or C.. Can give a NO or...
  3. S

    how could i do that with access?

    i know it is difficult to explain i'll try to add some more I have a number of event that can be activated according to the content of the input i supply I write down an examplke with 10 output 001000 1X A 002000 1X 003000 8X 004000 1X A 005000 1X A 006000 3X A...
  4. S

    how could i do that with access?

    sorry about fabrik, that is an joomla app for database, should not nbe mentioned here, was a mistake So you think i could do that with excel? I have around 150 Input string and normally i can supply to the calculation around 20 how wil i supply to elaboration xx input string?
  5. S

    how could i do that with access?

    Hello i am trying to develop a calculation, it seems to me complicated to do it techinically speaking not so much as a concept. I'll try to explain what i need, let's see it from a starting table On the X axis i have several input I1,I2,I3....ecc On the Y axis i have several (around 200) output...
  6. S

    open a record from a sheet view form

    it does! :)
  7. S

    open a record from a sheet view form

    wonderful!! tthanks ! :)
  8. S

    open a record from a sheet view form

    ok the things is that i want to open the form at the record specified if i click on the 3rd record of the list, let's say Paul, id 3 I want to open the form at paul, id 3
  9. S

    code for opening a report

    great! thanks a lot!
  10. S

    open a record from a sheet view form

    thanks, could you telle me more exactly what to do..i am not that good in code thank s alot
  11. S

    open a record from a sheet view form

    Hello i have a form with seacrh parameter and a submask that will display the seacrh result Generally i have few records, each one is a patient with datas I would like that when i click on one record shown i will open the form where all the datas are displayed in details So let's say the first...
  12. S

    code for opening a report

    hello i need to pen a report from a button i use this DoCmd.OpenReport "Report", acViewPreview, "Report" i would like to open the report in the same format as when i actually open the report , not in the print preview mode Hod o i do that? thanks
  13. S

    search record within time interval gives trouble

    seems ok, i will do some more test For now i really thank you, your help has been really good, apreciate that!
  14. S

    search record within time interval gives trouble

    i have tried this WHERE (((date_trattamenti.dal)<=[Maschere]![Ricerche]![dataa]) AND ((date_trattamenti.al)>=[Maschere]![Ricerche]![datada]) AND ((anagrafica.[id Anagrafica]) Like [Maschere]![Ricerche]![id] & "*")); i put translation for better understanding date_trattamenti.dal= treatment...
  15. S

    search record within time interval gives trouble

    don t know how to do that...sorry my knoledge is not so good :(
  16. S

    search record within time interval gives trouble

    no probably i write bad the sql, it should be as you thought at the beginning, as it reasonable, want to know who is been treated within the 2 date i specify. this is easy but this is not the point, what is not working is puitting together the date filter and any other filter i don t...
  17. S

    search record within time interval gives trouble

    i had a go to try if it works.. WHERE (((date_trattamenti.dal)>=[Maschere]![Ricerche]![datada])) OR (((date_trattamenti.al)<=[Maschere]![Ricerche]![dataa]) AND ((anagrafica.[id Anagrafica]) Like [Maschere]![Ricerche]![id] & "*")); don t work anyway, it only select the dates, nothing about...
  18. S

    search record within time interval gives trouble

    i think you rfer to this dal<=[Maschere]![Ricerche]![dataa] al>=[Maschere]![Ricerche]![datada] i am not sure it has the same effect though, i must make sure that when a patient has been tretated from-to (dal-al) it will be taken out if my 2 dates coiver that time i am noit able to understand...
  19. S

    search record within time interval gives trouble

    i am thinking might it be a matter of priority between operators AND OR? i have a filter between date managed by OR (1st date [datada] OR 2nd date[dataa]), and i have an AND that mix the date filter with another filter, in this case the ID WHERE (((anagrafica.[id Anagrafica]) Like...
  20. S

    search record within time interval gives trouble

    i am doing some test if i set a filter to only one of the 2 date field everything is fine When i put the filter "first date OR filter second date", then problem start and other filters stop workingwhile date filtering is ok
Back
Top Bottom