Recent content by Cillies

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.