Search results

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

cheers mate, that worked :-) your a genius

i get an error message Run-time error '6': Overflow once i debug the following line is highlighted in yellow Age = Int(dtmVisit - dtmDOB / 365.25)

just a quick question, if my date of birth field is blank, i want it to return a blank field... how can i modify the query below to show this? Age Bracket: IIf(([DateofVisit]-([Date_Of_Birth]))/365<=16,'0 - 16', IIf(([DateofVisit]-([Date_Of_Birth]))/365 Between 17 And 30,'17 - 30'...

thanks guys, couldn't do it without your help. you definately experts in my eyes ;)

so will this work?... in access? Age Bracket: IIf[DateofVisit]-[Date_Of_Birth]/365<='16','0 - 16', IIf[DateofVisit]-[Date_Of_Birth]/365 Between '17' And '30','17 - 30', IIf[DateofVisit]-[Date_Of_Birth]/365 Between '31' And '65','31 - 65', IIf[DateofVisit]-[Date_Of_Birth]/365 Between '66' And...

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

thanks guys for the quick reply....

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?

thanks mate:)

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

cheers zaeed

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