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

But why would the search work perfectly and only stop working when I have changed the listbox properties and added some command buttons. The actual code that represents the search has not been altered. I'm really puzzled now, and its not allowing me to hand in the DB as complete due to this...

ok, so how would i set a single button that sets the 'locked' feature to "YES" or "No" depending on what state it is when press. In other words, the same button to set the value to yes and to no. I dont want to have a button to unlock and another to lock. Its populating my form to much as it is.

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

That won't help. The thing is, is there not a way to change field/form/table names and so to all the objects related to that field/for/table????? I have sample DB that I got on here, but its proving murderous to change the fields to names that better suit my design. Please help

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

I think i got it. Will let y'all know how it goes. Cheers anyways

Please Help!!!! Hi, I have checked out the Search DB offered here but I am now having problems when trying to rename the forms and tables to better suit my scenario. I have changed the table names in the SQL statement in the form's unbound listbox, which displays the records held in the...

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