Search results

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

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.

Try it

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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