Search results

Hi lightray I am populating a table with information entered on the form. So at the moment, when I click on the "Employee" text box, it brings up a dialog box prompting to enter the criteria for the "Section". If you type in "legal" as the section, then all of the employees for the Legal...

Hi Lightray Sorry, still can't get this to work....what i need to do is when the dialog box comes up on the screen to prompt for the query criteria, there is a drop down list to choose from? Maria

HI Sorry, you have lost me completely.... can you try and explain it in a different way? Thanks :)

Hi, I want the user to be able to pick from a list the criteria that they can put in when prompted by a query. At the moment, when you run the query, I have it set up so it prompts for the criteria: [Enter Section:] - so the user has to type in the section. I want them to be able to pick the...

Hi I want a query to generate a "1" if someone ticks the Yes/No box, and a "0" if they do not. This doesn't work: Expr2: IIf(IsNull([Q2(i)]),"0","1") and neither does this:Expr1: IIf([Q2(i)]="Yes","1","0") ???? Arrhh ta

Hi Pat That's great thanks - that has done the trick! Maria

Hi Pat Once the record has been saved into the table (by filling in the form) - I want the table to update one field to today's date each time it is opened Maria

Hi I have a table which has a date field in it, where the default value is Now(). How do I get this field to automatically update in the table to "today's date"? Thanks Maria

Hi Rak Sorry, I don't understand (probably my fault not yours :) - I want to make sure that Ben cannot go in an make an entry for the "Benefits" section for the week commencing "15/10/06" if Sally has already made this entry? Maria

Thank you Neil & Statsman :) Neil: If I create a table which states which sections Jill deals with, Tom deals with etc...how do I create a query so that the form only shows the sections they have to look after?

Hi I have made up an Access database form for our Sickness Administrators to fill in when someone is off ill. I want the form to only show (on the drop down list of names) the people that that particular SA deals with - for example, Jill would enter sickness records for the Democratic, Legal &...

Hi I have a table (which is populated by people filling in a form) which contains two fields: Section WeekCom (e.g. week commencing) I want to make sure that the form will not allow someone to make a double entry. For example, if Sally goes in and says enters "Benefits" as the section and...

Great thanks Uncle Gizmo - will give it a try! M

Hi bob Thanks - yes, I have small tables with the exact same fields, so I will do the append query as suggested - thanks again!! Maria

Thanks :) perhaps I should ask someone in IT if they now how to do it!!

Hi I want my database to update field in a table each time the database is opened. The field in the table that I want to update is today's date: so that if I open the database today, it will be 12th October, if I open it tomorrow, it will change to 13th Oct? Can I create a macro to do this...

Hi I have several small tables that I want to make combine into a big table. How do I do this - is the only way by using a query? Maria

Hi I am developing a system where I need to give people a logon username and password, so they can only access certain areas of the database. For instance, if there name is John Smith and they work for the engineering department, they can only use the engineering form. Any ideas? Thanks! Maria

Thanks Rborob and Rich - I will see what happens when I log in tomorrow!

Hi I have a form that people have to fill in to report when someone is off sick. The first notification they have is that the person is off sick - so they can only enter a start date on the form, and have to leave the end date blank I want the end date to always be "today" - and to...