Search results

I have created a list box on my form, and the results of the select are 1, 2 and 3... but I want to add a tool tip showing an explaination of what they mean... Firstly is this possible? if so how? Im using Access 2002 Thanks in advance

I have a combobox on my form, the combobox has 3 values (1, 2 and 3). Is it possible to set the colour of the text within the combobox? 1 = Red 2 = Orange 3 = Green

I have a form in MS Access and want to add another column at the end of my student list called 'Notes' As this field will contain sensitive and private information, can it be restricted access to specific named staff?

I have a form which the user would select a option from the combobox, but what I have noticed is that users are writing in this field instead of selecting the options from the combobox... Is there anyway I can stop allowing any entries in this field? and only allow users to select options from...

Is it possible to check if the fields and drop down boxes are all complete before the records are submitted from the form? I am using a COMMAND button on my form that will save the entries from the form into a database, but i want all the entries to be completed before it is submitted, so i...

I've added my email address in a text box on my form, for users to contact me if they require any assistance... but when i run the form and click on the email address, i get the following error message Unable to open email.address@hotmail.com. Cannot open the specified file. I've added the...

SOLVED - Removal of grey bar How do I remove the grey bar on the left hand side of my form? thanks

I need some assistance in creating a form that will allow a user to enter a staff id and the form should return the forename and surname of the staff member... I have created a textbox that would allow the user to enter the staff id. I have also created a query that will search the dataset and...

I have a form that has two Option buttons (IP and OP), And I have a command button which runs a macro which then displays a report. How can I link the check boxes to the command button so that if 'IP' is selected then it should run Macro 1 and if 'OP' was selected then Macro 2 will run...

I have created a query to work the age bracket from the Date of Birth to date of visit, both fields are date and time below are some example of this. Note that the age bracket of 0-16 isn't a correct result. what is wrong with the query? Date_Of_Birth DateofVisit Age Bracket 06-Oct-1907...

how can i write a query so it picks up all the dates that occured on a Sunday? so i have a date field with over 300 records, i need to highlight which of those records (dates) are on a sunday

Ive created a UserForm that allows users fill out a questionnaire.... Every question has a option of 'Yes', 'No' and 'N/A' How can i add a validation so, the form cannot be submitted unless all answers are answered.... for example, a selection in a combo box is entered... otherwise, I want a...

I have created a UserForm in Excel, to gather data for a questionnaire. For each question, the user must select an answer from a radio button (Yes, No and N/A) When I add the record (answers) to the sheet1, the results are shown as all being false. I want to show either ‘Yes’ or ‘No’ or...

I am creating a questionnaire in Excel, I’m using the template to populate the results. I’m finding it difficult to produce a graph for the results. I want a number of graphs produced– Graph 1 (Trust core standards) Questions 1 to 14 Graph 2 (Demographics, reason for referral & consent_...

I need to create an update query. I have two fields - Operation Date Cancelled Date I want to create a field or do an update query, if there has been a operation date after 24hrs of the cancellation date I have tried starting writing the query - IIf([Operation Date]>=([Cancelled Date]+1))

I have created a table called - "Test" The properties of the table is listed below Table Name: Test Field Name: ADMDAT2 (Text) DISDAT2 (Text) Operation Date (Date/Time) I have written a query to populate a field where the Operation Date is between the ADMDAT2 and DISDAT2 Expr1...

In the attached Excel workbook, I’ve created a Pivot Chart. I keep on losing the percentages that sit on top of the bar charts, every time I change the filter on the service pivot Is it possible to maintain them for each individual service, so their percentages are as clear as possible?

When my database is opened, I want the form to be displayed in the middle of the screen and I want the tables, query, macro section hidden from view, but can only be accessed, if F11 is pressed…. How do I do this?

I have a command button that runs a query, which uses a date range that the user enters…. I need to write a piece a code where if there is no date entered… a message box appears saying “Please enter date range”…. If there is a date range entered, run command button as normal… Thanks in...

I am designing a form in Access… I have a query already set up in the background that appends data from table_1 to table_2…. Using the month and year criteria…. How do I create a form that allows the user to select the appropriate month and click on the execute button – which alters the...