Search results

  1. expublish

    Combo Search - Results on diff form

    Hi All, I hope someone can help ... I have a form which is like a menu page. It has a few combo boxes that open various other forms. It also has a combo box. This form is called Employee Main. The combo box needs to look up the field Employee Name in the table Employees and then display the...
  2. expublish

    Animated Gifs

    I just tried it the simple way by inserting the image but it doesn't work. Dunno if there is any other tips & tricks that may help you.
  3. expublish

    Animated Gifs

    Try it
  4. expublish

    I'm still stuck on this combo box

    A new morning and new outlook on this *£@%$^& combo box. Thats what I thought until I opened the database and realised that I am not really getting anywhere further than yesterday! Hayley did you have any luck with the sample I sent you? Anyone else looking at this thread with any ideas at...
  5. expublish

    I'm still stuck on this combo box

    I have exported the relevant form and table into a new database file and zipped this up. Hayley, can I email this to you for you to look at? If so, pls send me your email address if you don't want to post it. Use: margaretkombakono@hdvfoundation.org.uk rather than the one I have on my...
  6. expublish

    I'm still stuck on this combo box

    I have reverted back to my old form now seeing as the new one didn't get me any further. My old one is like a menu page. It has this (cursed) combo then has 5 command buttons below. The command buttons all have on Click events that run macro's to open other forms. I can't see why they would...
  7. expublish

    I'm still stuck on this combo box

    I have copied your code, changing names, no luck. Last through of the dice was to start a completely new form, with Just this combo on and nothing else to interfere. IT DIDN'T WORK! Before I curl and cry like a baby who has lost his candy, please can you confirm that I have the following...
  8. expublish

    I'm still stuck on this combo box

    Hayley, Did what you said but it has made no difference. Still same problem. Could you c&p your code so I can compare. Also, any more ideas? Cheers Scott
  9. expublish

    I'm still stuck on this combo box

    Didn't have any luck with code. It brought up a compile erorr: syntax error. So I started again using the wizard doing the following: Find a record on my form based on a value I selected in my combo box > Selected Employee Name as the field I want it to look up > Adjusted width of column to...
  10. expublish

    I'm still stuck on this combo box

    OK, did that and now the selections are not responding at all. Just to confirm, the event AfterUpdate in the properties box on the form it set to [Event Procedure] - that is right isn't it? The code now looks like this(last time I c&p too much): Private Sub Combo14_AfterUpdate() ' Find the...
  11. expublish

    I'm still stuck on this combo box

    I have a combo box (called Combo14) on a form. It is looking up a field (employee name - employee id is the p/k but i don't want that listed - just employee name) in a table (employee) and when the user selects a name it takes them to the relevant record. Now, the values are listed OK, but...
  12. expublish

    Mail Merge Again

    I am setting up a mail merge based on a query that filters data from a table. I have it setup mostly correct apart from one bit. I think it is this bit thats wrong: objWord.MailMerge.OpenDataSource _ Name:=CurrentDb.Name, _ linktosource:=True, _ Connection:="QUERY...
  13. expublish

    auto fit to screen forms

    Was about to ask you for the same but I won't. To all you lazy farts, ready the thread and you'll see that you can download the code from http://www.anauz.clara.net/access.htm DOWNLOAD it, STOP harrassing the poor bloke. Someone had to stick up for you
  14. expublish

    Text Box & Combo Search Function

    Thanks for the suggestion. I gave it a go, but it was a little too complicated for what I need. I tried modifying it a bit which made it better but I couldn't overcome the problem that my actual tables and query names where displayed. This is not very professional to the end user. Anyone know...
  15. expublish

    Text Box & Combo Search Function

    I need a form with a search facility on it. Simple, you may be thinking ... there is a complication that has thrown me. I need it to be in this format: [Text Box] [Combo Box] [Command Button] The text box will be where the user types in the search term they are searching for. The combo box...
  16. expublish

    Auto E-Mail Form Contents

    Any idea how to do this with a report (email a report)? I have a form setup with a list of report. At the moment there are command buttons for viewing the report and printing the report. I want to add one for emailing the report, so the user simply clicks the button on the form and their email...
  17. expublish

    New use for combo box ...

    In the end I took Fizzios advice. It looks like this: -- Create a table with Autonumner and Command description. Type in command descriptions you want availale in the table (remember the ID number assigned to it) Set the rowsource to SELECT [tlkpCommands].[CommandID]...
  18. expublish

    New use for combo box ...

    On all my forms the user needs to be able to print record, add record, delete record and save record. I alrerady have command buttons for go to next/previous and exit form. I don't like the idea of having a row of 7 command buttons along the bottom of every page. Anyone know how to put all those...
  19. expublish

    Combo Box Trouble Again

    Thats done it - many thanks. I knew it would be something silly
  20. expublish

    Combo Box Trouble Again

    I have a couple of combo boxes on a simple form showing field from 1 table. On a couple of fields I have setup combo boxes with my own list of possible vales. An example is gender. The poss values are male or female. Now when I enter the form and fill out a record, selecting male or female it...
Back
Top Bottom