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...

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, 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...

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...

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...

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...