Search results for query: *

many thanks is it possible to do the same with a Data Access Page do you know? Thanks

Solved it.....ignore me

Hi I have a table called Images with fields PartNo & ImageLocation I have a form with a Combobox that the user will use to select the right part, and I then need to display the ImageLocation in a text box when the user changes the part I've tried the DLookup method among others but not having...

Hi, We've got a PC on our network which won't open some CSV attachments. One email has two attachments - it will open one of them ok but the other produces the following error "Can't create file: 823.csv. Right click the folder you want to create the file in, and then click properties on the...

Hi Not sure if this is the right forum, but I have a problem with Outlook 2000 One user occasionally gets an attachment appear in his Attachment line. It isn't a file the PC recognises as it is the Windows format file icon, but sometimes we have had people reply to the emails saying that...

Hi I have two tables, the first table as follows.... TempTable ProductGroup unit make A £25 CustA and the second.... RebateLevel ProductGroup CustA CustB A .21 .25 I'm trying to get a column on the first table to show the rebate...

Hi Figured as much, but just thought I'd explore the possibility. Cheers

Hi May be a simple question but....Does anyone know an SQL statement to run a query, insert results into a table and then open the table automatically. I thought something like CREATE VIEW would work, but doesn't seem to Many thanks JB

Hi I've normalised the table, but can't get a query that works from this for some reason The table looks like Part Supplier Price E SuppA £24.99 E SuppB £29.76 Many thanks again, JB

Many thanks for the replies, both methods worked fine With the Normalisation idea, it works well when I specify a part, but when I try to run the Query for all parts Access takes an age before hanging. Is there a quicker method, as I need to run a query to show all parts Thanks in advance

Hi I have a table which lists parts and then the part prices for each supplier I need a query that will select the cheapest one, and also display the name (field heading), so we can work out the cheapest supplier quickly. I thought this would be relatively easy, but not getting anywhere...

Great - managed to get this far with the second CD, but still problems - I can't install it on the Server as I don't always have access to it I've tried installing it on my own PC but it only runs the client services and most of the functions don't work. Is it possible to install/run it on a...

Hi This is probably embarassingly simple.... I've got Small Business Server up and running on the server at work, and I need to start using SQL Server 2000. How do I go about this - I can't find anything on the server which looks like it might start SQL Server. Do I need to install more...

Hi, I've got a database set up for printing different letters depending on which one the user selects. The letters display the customers address (taken from the customer table) as well as other details (taken from the warranty table) For some reason, when the customer code "C001" (a...

Thanks, that worked fine Cheers

Hi, Probably a very common/simple question but I'm trying to validate the entry of a Text Box from a Form. The data input must be on another table (Customers) to ensure the correct information is entered I've tried various Validation Rules, but with no luck I had thought the followinf would...

Thanks for your help, I was getting it right but for some reason some of the Server Variables return nothing(and it would be the ones I want) Must be something to do with my server/client settings I'll have to try another method Cheers

Thanks, I can get variables such as HTTP_USER_AGENT and REMOTE_ADDR to work, but still can't get the User name. Sorry to be a pain but I'm new to this and trying to teach myself ASP - where do I find the documentation relating to the Environment Variables? Thanks again in advance Jez

Hi, hope someone can help I need to take the USERNAME and a few other details from Environment Variables. The code below works for some of the variables, but not others, like USERNAME, LOGONSERVER and COMPUTERNUMBER - do I have to do something different to get this to work? Thanks in advance...

Hi, My code and db design works fine, except for one problem.... I've used several temporary tables, which once a query has been run from get deleted using docmd.delete acTable, "templines". Access seems to be storing this data soemwhere, even though it doesn't come up on the...