Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Cillies

  1. Cillies

    Open a subform in a form

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

    filtering a report using a form

    Thanks PHV.
  3. Cillies

    filtering a report using a form

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

    filtering a report using a form

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

    Adding an 'Open' button on excel spreadsheet

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

    Adding an 'Open' button on excel spreadsheet

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

    Adding an 'Open' button on excel spreadsheet

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

    Auto send email

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

    Creating an outlook email menu

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

    Message box in a form

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

    If And statements

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

    If And statements

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

    If And statements

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

    limit entries in a subform

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

    limit entries in a subform

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

Part and Inventory Search

Back
Top