Search results for query: *

Thanks Tony, Looks like what I was trying to do -I'll give it try. Cheers

I have searched the faq's and forums an connot find what I need so far. Please point me to an approriate one if you know of it. In Excel, I have a worksheet with four columns of data. The first column shows data for the first combo box and I have populated this by simply pointing the row...

I have an asp page on a website which holds the results of a questionaire form and I want to import this into an Access database. There will be several sets of responses on the asp, each with a header of 9 cols and the body of many lines and 5 cols. How can I get this to import into Access, or...

Thanks again Darkshadeau - I am using frontpage because I have it - I am thinking about just coding the whole thing by hand. I have used FP to build sites in the past but it has its limitations. Have also used Dreamweaver which gives more flexibility. I use something called EasyHTML (a...

Thanks Darksahdeau - I can see how this is to work. Couple of questions - I have put the combo in a form as it's the only way I can see how at the mo - is this correct? It does get populated by the option value code OK. In the Onchange line I assume the "this.value" is the name of...

I am trying to use a combo box to select links. e.g. select New York and the NY page opens. I have the combo in a left frame and want the page o open in the main frame. Have tried the FAQ's to no avail. Any help appreciated. Thanks

I am trying to inert and delete columns in a query using VBA rather than SQL. I have come across the AcCmdDeleteQueryColumns and AcCmdInsertQueryColumns in the object browser but nothing on the syntax for using them. Can anybody help please? Cheers

Many thanks guys for your help and suggestions. I have now fixed it and it was all too simple. Yes it was an association problem. After trying all your suggestions the browser opened but with no link. So.... I went to absolute basics and tried each option available and at last I hit the...

Hi Folks, more fun and games. I have tried all of the above and checked the associations etc, all to no avail. It still does not follow the hyperlink. Frustration!! #-) Any other ideas????????????? Thanks for your attempts

Thanks guys, I will try these suggestions when I get home. (This problem is on my home PC) I am currently using Word as the email editor. Will post and let you know how I get on [morning]

Thanks guys - thats about what I thought the answer would be but it is good to get confirmation. I am familiar with wildcards usage in queries etc so will run with that concatenated to a parameter box meantime. Maybe get energetic and write some code to do it through a form later. Cheers [morning]

Thanks, Jmat. However they seem to tell me how to put a hyperlink into an email. I have the opposite problem. I recieve an email with a text link and when you click on it nothing happens. Cheers

When I click on a hyperlink contained in an email nothing happens. It does not even open the browser far less go to the site. What have I missed? Is it a setting somwhere? I am using Outlook 2000 and IE6 Thanks

Does anyone know how to have "Plain English Queries" rather than ordinary Access ones - or if this is possible? I have a client who would like to be able to query in plain English through a form. I have suggested the wild card query such as *words queried* format but that is not what...

Put the "Force New Page" property in the last section, be it Detail or Footer, that you want to show on each page. Everything on that section and above will be on the first page, or pages if the data is more than a page long, and then it will start the next lot on a new page. Don't...

This is just what I have been looking for also. Thanks guys

Thanks TLB - works now George

Has anybody had any problems with these in Access XP? I can type what was a valid expression in 2000 but XP won't accept it. e.g. format([mydate],"mmm") worked in 2000 but not in XP. Also if I use the Label Wizard it brings up a parameter box with the word "Trim" in it...

Select the cells not showing correct results, go to the Format menu, Cells option and check that these cells have not been formatted as text rather than a number or general

I need to be able to click a button on a form in Excel which then selects a variable size range of data and copies it into a Word document. Selecting range is easy enough but I need to copy this, then open a Word document and paste the data into it. It must be done through code. Physically...