Search results

Hi, I have a DB which I would like to be viewed by all but only edited by one person. I have a form which hosts a reports menu; this is all the other users need to see. At the moment I have a very insecure password form, which basically uses a code to say "if password = password value then open...

Hi, I have a field which calculates a date in the form dd/mm/yyyy. I would like a msgbox to appear if the weekday e.g. monday is equal to a preselected weekday within a combo. The first hurdle is understanding how to define a date as a weekday, if possible at all. Thanks a lot for any help Nick

Hi, very simple. I have this code How do i specify if the value = nothing/zero/empty if you see what i mean. Thanks Nick

How do you create a memo box with those 3 little lines in the bottom right hand corner which allows you to stretch the box larger. Hard to explain but I hope you know what I mean Thanks Nick

Within my DB I have a form which has a field for the students email address. I have a button within this form which runs an embedded macro and opens MS outlook (new message) with the current email as the recipient. I would like a button on the switchboard that can send to ALL email addresses...

Hi, i am using the code created by "John Big Booty" to search a list box. I would like to add some option frames which will further filter the list box. I am using this code 'Create a string (text) variable Dim vSearchString As String 'Populate the string variable with the text entered in...

I have a subtable containing a name and a percentage (score). I would like all of the percentages above the average to be green and those below the average to be red. I have tried "field is greater than Davg" however this proved unsuccessful. Could anyone tell me the expression Thanks Nick

Hi, I wish to create a search box which will filter through the names in my sub-table list on the switchboard. I would like it to be similar to the itunes search function or the one which JBB created: it shortens the list after the entry of each character. The reason for not creating a listbox...

I have a sub table on my switchboard. I wish to have a button which opens a set of tickboxes allowing the user to select which fields are shown within the subtable. The "student template" ON MS Access 2007 features this. Thanks allot Nick

Hi, I wish to make a search box which will search through a table full of student names. I would like it to be similar to the "itunes" search function which only displays albums containing the typed letters in them. Thanks

Hi, I am creating a DB which is similar in concept to the MS "student" template shown on Access 2007. I am wondering how to create the "sub table-looking" student list on the "main menu" that they have. Specifically the open student record function. When looking in design view it seems they have...

Hi, I have a sub table within a form containing some dates. I would like to create a default value which will be 12weeks (84 days) after the LAST RECORDED DATE. *I can make this work for 84 days after todays date but am unsure of how to specify the last record/date. Thanks allot Nick

Hi, I am trying to create a code which will copy the contents of a "date/time" field to a "memo" field when the value of the "date/time" field changes. I am unsure of the code which i should use to copy this field to the other. I have attached a copy of the database to prevent confusion. *I...

Hi, I'm (trying to) create an access database containing a form with multiple tabs. My objective is to make a button with a module that will hide (make not visible or disable) one of the tabs if a combobox has a specific value. Essentially, I want to hide the tab 'qA' if the combobox has a value...