Search results for query: *

HiDj Well, the only way I got around it, was to let the user typr in the Skill because it more flexible to let the user enter what skill the trainer is able to do, rather than select from a list, there being more skills later. I haven't figured out and AND/OR search for a Town AND/OR skill. Ken

Many thanks for the link Tom. Looks like I'll have some fun trying these out.

Hi I have a simple question that I would like help on. I need a simple search form that consists of two text boxes and a cmdBtn. The user will type in a Town in one box OR a Skill in the other. Click the button and hey presto! All the trainers from that town or that skill will be displayed...

Hi All Thanks alot for the tips. Read back on the old archives, so I wil try them out. Hopefully one day I will get it sorted. ken

Hi Barbara Sorry about that. Just shows you how much of a newbie I am LOL Takes a bit of time for an oldie to learn new tricks. Ken

Hi I'd be interested to know your results on this problem as I have just posted a thread elsewhere for a very similar problem. I want to print a Single Record from a Form in a Report Ken

Hi All I am trying to learn Access and have come across a problem and have spent the day looking for an answer. There are 2 Tables, 2 Forms, one of which is a subform, and 2 Reports, one of which is a subreport. I checked out the Microsoft Website and came up with some instructions of How to...

Thanks a bunch Loomah Email is as follows .... KenATwizzwebDOTcoDOTuk Hope that's right. Tried doing the code bit several ways, but just keep getting a Compile Error .. the explanation of which is way beyand my grey cells!!! Ken

MMMMMMMM Guess I need help! Just tried both versions out, but get nowhere. I wonder if it would be possible for either of you to send me a sample so that I can look at what goes where. I have always found that I can learn by example better than wandering about. TIA Ken

Hi Paul Thanks for the code ..... I will certainly try it out. Looks like I have a lot to learn!! Still, at my age, it's better than sitting around all day vegetiting!!! Ken

Thanks for the Code Loomah. Not being too familiar with VBA and all dandy things like that, I take it that I post this code using the VB Editor under the Macro button? Ken

Hi all I have a workbook for each customer and a worksheet for each invoice for that customer. Is there a way I can increment each work sheet. For example: Sheet 1 would be Invoice # 2004/321 - Sheet 2 would be Invoice #2004/322 and so on? TIA Ken

Hi That is just what I wanted and all is working OK ... Thanks. BTW ... I am working in A2K, so I assumed I was in the right forum K

Roy, Well what can I say? You are a hero. I am sure the first two parts are the same as I used in the past. Many, many thanks. Ken

Hi all I have solved my problem in one of the ways suggested, both in this forum and others. The way I did it wa in a way that I thought was rather long winded, but appears to be working a treat. I created a Table: tblSkills and a field for each skill and set the data type for each field to...

Hi For cosmetic reasons, I want to place the Navigation buttons and recod numbers ON the form, rather than below. The Nav buttons are no problem, but it's the two text boxes with the records displayed that I can't remember how to do ... been over two years since I last did it and all I did...

Hi John Trying to get used to this Forum too!!! Thanks for the tip .. I have saved the message and will try it out later Will let you know how i get on

Thanks for the info John ... have to try and sort it all out in my head .... Can you explain what Link Table and Composite Primary Key are? As I am still new to Access, it is a foreign language to me. Too used to HTML and Java and such things. TIA

Hi Being fairly new to Access, I wonder if anyone can give me some advice, tips or instructions on the DB I am involved with at the moment. I am building a simple agent/employee type database consisting of the usual stuff ....... name address etc, but I also want to inculde a muliple choice...

Hi I have just updated to SP3 in MS Office 2000 and have no end of problems, the two main ones being Command Buttons, I can't get the wizard, and an error message when opening a Form .... 'Error Accessing File ...........' Both problems seem to stem around Vbe6.dll. Checking up on the MS...