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

Thanks PHV.

HI PHV, Thanks for that, it works fine, but do you know what I would need to do to use this in a parameter query? so the end user gets to select what to search for without having to change the query construct each time? Many thanks

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

The Problem is that I need the macro in a UserForm. I have created a spreadsheet with a button on it that states 'view image'. I also created a userform in VBA which holds the image, so when I click the button on the spreadsheet the image come up in the userform, when the userform is up, it...

Hi, Thanks but I have figured it out. I simply created a userform added an object then entered the very difficult text in the VBA editor of "userform1.show" end sub. But I now have another problem which I am sure is as simple, but as yet I cannot find the solution. I have added a print button...

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 PHV, Thanks for your help, that’s works perfectly, but is there anyway of bringing up a message box to further indicate to the user that a movie has not been returned. Sorry if I'm being a nuisance. Kind regards Cillies

Sorry about that. its for a subform based on a query. The two fields are from the same table [Loan] within the query

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

Remou! scratch that I was being silly. Its working fine. Thanks again for your help, I was thinking it was an automatic solution, as in when you enter three dates the same, a message box would appear informing the empolyee that only three video's per night are allowed.

Hi Remou, I tried that but it will only let me enter three videos regardless of date, do you know of any other way of doing this. "I have a Loan table with three primary Keys as you recommended, the VideoCount has a type of Number which I enter manually." Thank you very much for your help so for.

Hi Guys! Thanks for your responses both worked perfectly, but I have now discovered that it would be better if the limit of three video worked by relevance to the date taken out. I.E. the customer can only take three videos per night. Therefore the video store can keep a record of all the...

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

Sorry about this post, I've figured it out. And now I feel like a complete T**T

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.