Search results

Hi all, I have a DB in Access with numerous forms & tables. I now need a launchpad (startup) menu where i would have buttons to open each form, and a DB wide search facilirty. This is where im stuck, with the search facility. I need to get a text box where a user types the search criteria and...

Hi, How can I set read only attribtues to various textboxes, and only permit the data to be "edited" via my forms when a user presses an EDIT button, and then re-protects the textboxes by pressing another button, possiblty SAVE.

Can someone please tell me why i always get a Compile Error when i try to enter seaarch criteria in my search textbox. It was working perfectly, then all of a sudden, it gives me this error each time. Also when i press the Refresh button. Both the search textbox and the button refer to a listbox...

Hi guys, I want to include a command button on my form that will strikethrough the selected record. I will explain my from's setup..... I have a single form which contains a listbox displaying the records held in my table. However, only 3 columns are shown in th listbox. Once the user carries...

Hi, Where in a database would i find this code: Forms!frmCompanies!Search2 It keeps appearing when I try to open my form. It has been happening ever since I change my table/form names in the DB to better suit my new project. Where can I find this and what do I need to replace it with. My...

Hi all, I need to sort out the following: Whenever the user tries to enter a value that already matches an existing value (duplication) they get the standard MS Access message box telling them so. How can I: 1.Set my own msgbox to appear whenever they enter a duplicate value. They message...

Hi all, I can't get the following to work on my DB. I want to get a pop-up form the will appear whenever I press the ADD RECORD button on my Maion form. This pop-up form should contain the texboxes that are already displayed on the main form so that the user can fill in the new record, and that...

Hi, I have a query that contains expressions which sums the number of times a particular value is present in a table. I have this same query repeated four times (once per week) each having the same expressions and carrying out the same calculations. These calculations are: Worked, Absent,etc I...

I need to find out what criteria to use in my query. I have an expression that counts the number of entries in my records. These entries are all letters. I now want to specify what letter to count in each record. So, instead of telling me there's WWWHHU, i want it to tell me how many W's only ...

hi, i have columns that display letters (w,we,ul,etc). I need to include a final column that adds how many times the letter "W" is present in the range, and the same for each letter. So if there are 3 "w's" in the entire specified range, then the new column for "W" would show the number 3...

Hi, does anyone know how to use a listbox or combo box to navigate to a particular form. I want to use this in a main menu form. thanks (Y), 'D'

Would you know how to count the number of times a letter(s) appear in a row on a report or query? For example, the output from the query is Surname,Name, and all 7 days of the week. For each of these days, a letter is displayed to specify wether the employee attended or was away from work. After...

I have a form which displays employee records. Each record consists of a surname, first name,department. Ialso have a list box containing the names of all employees. How do i make the record for the employee chosen from the list box appear. Up to now i have only managed to get the Surname to...