Search results

Are you a chamber member? If so it should be easy to find out what needs doing. I might be interested in doing the actual work but would need to know much more about it.

Thanks Guus. Thought that was the case. Nice to have it confirmed

Does anyone know a neat way of associating more than one label with a text box control? It doesn't really matter as everything will work anyway but it would make things more tidy for editing on a form I am working on.

I am trying to fund a very innovative database project with exceptional potential. Trying to raise funds in UK and do things in the standard way is proving a mite frustrating. I propose to look for funds in USA where people are more open to new ideas. Also I need a prototype for marketing and...

This sounds reasonable simple. If you only have four tables and don't mind how pretty the output is so long as you get the information you need then it should not be much trouble. You need to put in effort to set up the relationships - that will make everything else much easier. Then learn how...

You need to define the problem before worrying about the solution. The input side 1 What entities are they dealing with 2 What data do they have about each entity The output side What information do they need to run the business 3 What do they use the Excel to tell them about there...

Don't reinvent the wheel unless you want one with five sides

Just create another test form using a query and get that working with a combo box. Once you have got the idea you can introduce changes and see where the other form fell down. i would not play with your "good" form till you know what is going on Easiest way to do different fields is to you a...

The fun starts when the Manager table is used elsewhere. If you only have these two tables you will get away with anything almost. But an autonumber primary key starts to pay off as soon as the relationships get complicated. Also it is much easier for someone else to take over the database if...

Not sure - it should go to the record if that is what you asked the wizard to do. Is the form a standard Access form or have you set up your own record source? Try creating the form from a query, then add the combo box. This definitely works

Done a quick look up to find out what RSD is etc. This suggests that treatment is limited to controlling pain so presumably the Germans have something which goes beyond this? I am not medical but have a background in alternative health. How about trying B vitamins. B6 seems to favourably...

The usual way to achieve what I think you are looking for is to use a combo box in the form header. if you create it with the wizard it will ask you if you want it to find a record. This will mean your form comes up with some records showing but so what. Once the user has used the combo box...

I did warn you - this should do better strCc = Left(strCc, Len(strCc) - 2)

Sorry, It must go outside the loop For x = 0 To lstSiteContact.ListCount - 1 'Select sites If lstSiteContact.Selected(x) = True Then strCc = strCc & lstSiteContact.Column(1, x) & ", " End If Next strCc = Left(strCc, Len(strCc - 2))

I am the worlds worst at actual coding. Just plug away till the damn thing works, mainly because I have used to many different pieces of software. Anyway try this strSite = Left(strSite, Len(strSite - 2)) which should chop off the final comma and space

The elegant solution is to add the first site with no comma then put the comma in front of the site string in the loop. The quick and dirty way is to crop two chars off the string after the loop has ended.

Just so. or what I have contains an error

Hello again, I used to take part in this forum as dsigner. A change of job and computing environment means that the old email and password on that registration no longer are available. So here I am as dsigner1. Is there any way to retrieve my old identity as dsigner? The system still has that...