Search results

Hello, imagine this. I have form made direct by table. In this form I have also one field, call it ValueCriteria, what have value from one other form. All field are input one, and only one is combo box. This combobox take list of value from one other table "filtered" to show just value defined...

I believe all my problem is bad reference. Look this name: Mainform name: Lavoro nuovo subform name: Lavoratori In subform is show form name: Lavoro nuovo sub In "Lavoro nuovo" is combobox name: nuovaedizione To filter in Combobox Ruolo in "Lavoro nuovo sub" I put this criteria: Forms![Lavoro...

Hello, I try to connect combo box of main form define combo box list of subform. Le me explain. I have four table. Table 1: job list with field: jobId, jobname, job description, job date Table 2: job name: simple list of possible job used by Table 1 Table 3: work list: it have workID, jobid...

Hello, find in attach part of my datbase connected with Dynamically search multiple fields. To original one I add two different data filter. First one, Scegli le date is to filter jobs between two date, datainizio (start date) and datafine (end date). This work perfectly. Second possiblity is...

Well I have simple table to search. It have field about date, job, job comment. Word search is made for field job and job comment. And this work perfect. Then I add new criteria: start date and end date. Both have default value. With it also "below" list arrive correct. Problem arrive after...

Thanks for your replay. Your linked db have just little possibility. My one have lot more, problem is how to implement it with date criteria

Hello, I see your question on: http://www.access-programmers.co.uk/forums/showthread.php?t=195899 This is just what I am looking for. Before I made my question about this on: http://www.access-programmers.co.uk/forums/showthread.php?t=208726 Do you made some progress with it? This is great...

Hello, I use great form on link: http://www.access-programmers.co.uk/forums/showthread.php?t=188663 It's make great and fantastic seach. I look way to add addition possiblitiy. Or better I look way to add time seach. So to search with enter range of date: start date and end date But also to...

Hello, I have one old Ms Access 97 program that go to change and "modernize" It have generally four table. Table 1 and Table 2 are input one with general staff Table 3 are in relationship with Table 1 as one to many Table 4 are in relationship with Table 3 as one to many, but also with Table 2...

Hello, I have list of subscriber with last number+year of subscribe. I look now to find correct query formula to receive list of subscriber what expire when in input have period of time delimited by startnumber, startyear and endnumber and endyear Little example. If I have this subsriber (with...

Hello, I see in one old Borland Paradox program something what I am looking to copy in Access but have no idea how. Let me explain. Report is made in few A4 paper. Paper in divide in 10 box, 2 columns with 5 row each. This boxes is filled by subscriber of one magazine. List is order by city...

unfortunate problem is little more complicated. In subscriber table I have something like this subscribername fromnumber fromyear tonumber toyear subscriber1 1 2010 10 2010 subscriber2 8 2009 7 2010 subscriber3...

Hello, I go around one query problem but can't see solution. Let me explain. I have list of person who made subscription to Arcobaleno. Arcobaleno have 10 number in one year. When I made query I want to see what subscriber are subscribe to single number of Arcobaleno. For example subscriber1...

Thank you very much. Sorry I just see never replay here :( It resolve all my problem. Great solution

Hi, thanks for your fast replay. I paste your solution, change name to real one but still receive mistake or better: "Run-time error: 438, Object doesn't support this property or method". I simple on main form add bottom with Openform method and call it "Izracunajbrojprimjeraka". Then delete...

Hi, I look for this solution but without solution. Problem is that dependent of number in one field (from 1 to 5) cliking bottom will open new form with openform. Problem is that if field criteria=1 will open Form1, if field criteria=2 will open form2 etc. So complete different form. And all of...

Hi, I have an idea but no idea if it is possible. In form1 one user input one of two criteria: 1. from start date to end date 2. from start magazine number to other magazine number To calculate number of magazine I made bottom who open form2. Here is a query who calculated independent of...

Hello, This is in big part what I looking for. HitechCoach example file is great. But how to receive just number of holidays between two date in query?

Hello, This is in big part what I looking for. HitechCoach example file is great. It is possible in query to receive just number of holidays between two date? My original thread is here: http://www.access-programmers.co.uk/forums/showthread.php?t=192021.

Hi, I know problem can be simple. I have start date, end date, table with holidays. Problem is I have addition criteria, day(s) of week. For example from January 1, 2010 to December 31, 2010 I will work for example Monday, Friday and Saturday. Question is how many days I will work excluding...