Search results for query: *

Hi, I have one table with information about acronyms within it i.e. acronyms, description, details etc What I want to do is: create a form with a search box on it, which will accept user input i.e. entering acronyms. then I want a button to click which will search the table for the exact match...

Hi, I wish to open a report using a form with search criteria. But I only want to use the first letter of the required string. i.e. I want to enter a letter eg:'B' in my search box on the form, which should return all records that start with the letter B, and so on, for any letter I chose. Hope...

Hi, I am trying to add a button on an excel spreadsheet, that when clicked will open a grahic image. I can add the button to the spreadsheet, but don't know how to write the macro/VBA to direct the button, "when clicked", to open the image. Hope someone can help. Also where would I need to...

Hi, Is it possible to send an automatic email via a request? I have a word/webpage document containing certain brief topics of information. Some user request more information on a certain topic which they send me an email requesting more info on e.g. XYZ. I would like to be able to add an...

Hi all, I want to build an email that will consist of a split screen (top - bottom) on the left of the screen will be a menu consisting of headings, the right will be blank.(Screen proporation: 65/35) What I want to achieve is to create an email that will be sent to all employees, that...

Hi all, I am building a database in Access for a video store. I'm at the stage where I want a message box to appear if a video has not been returned before the specified return date. I am using the [Return Date] and a [Returned] Yes/no check box to register whether a video has not been...

Hi all, I am having difficulty writing an If & And statement I am building a DB using Microsoft Access. What I want to do is write an if statement that will tell the user that a video has not been returned by the customer that is currently trying to rent another video. My entities are...

Hi all, I have a database in microsoft access based on a video store. What I need to be able to do is limit the number of entries/ videos that a customer can take out i.e set a limit of maximun 3 videos per night. I have built a unbound text box in a form that the user can input the...

Hi all, Does anyone know what I would need to do if I wanted to create a keyword search function within a microsoft access project. I am creating a database to store various reports, with the end goal being, the user can open the database and search for a particular reports like: Snooker. The...

Hi, Does any one know if it is possible to make text boxes in a report automatically resize themselves, depending on the amount of text for that particular field. i.e. some text boxes will have more text than others.

Hi, I have a simple DB with two tables one with basic information on it like date, contact, action etc. A Second which stores values I want to use for a combo box (CategoryNameID & CategoryName). I designed a query combining the two tables. (See SQL below) I based a form on this query which...

Hi all, I have a simple question regarding Intranet searches. I have several hundred word documents that I want to put on a company intranet under one heading (CI Reports). I need to be able to add these documents to the intranet and search just the section of the intranet that contains...

Hi all, I have a simple question regarding Intranet searches. I have several hundred word documents that I want to put on a company intranet under one heading (CI Reports). I need to be able to add these documents to the intranet and search just the section of the intranet that contains...

Hi, I am having problem with counting records. On my form the user selects one value from a dropdown box (Which is controlled by a table). I want to be able to display all the values from the table on a report. And count the number of times they have been selected in the form. I will also need...

Hi! In my access database I have a field that requires the user to enter in a call back date. Now what I want to do is; when the DB opens the first thing it will do will be to scan the db and return a report with all records that display todays date. I.e. so if I entered a date to call back...

Hi! all. I have a report and I want to show the number of occurances of a particular value that appears in the report. The thing is that the value that I want to count in the report comes from a combo box value list. in this list I have certain values like "send letter", "sent email" and I...

Hi, I was wonder if anyone knew how to manipulate access on start-up to check a certain date field on a form, and if that date on the form is the same date as the day the database was opened a message would appear asking the user to take action or at least bring up the records with the same date...

Below is my code that I use for searching a query to display results on a form. The problem is that I want to add a second combo box [season], that links with the first [opponent] (name of second combo - cboseason) Does anyone know how I can change the code so that when I click OPEN it will...

Hi! I have a form that displays information using DLookUp. Now at present I am going into the query and entering criteria that I want the form to display. i.e. the form is for a sports team and I will enter in the team I want to display and the season I want displayed. therfore recieving the...

Hi, I have a form displaying information on individual rugby games. What I want to do is to use another form to select opponent and the season to display the results on the 1st mentioned form. Now I want to use 1 combo for the opponent and 1 combo to select the season. I just don't know how to...