Search results

Cheers for your response guys. I'm struggling to see it but I know I'm a newbie and you are experienced - so I'm pretty sure you will be right and I will be wrong. I want to do things right as I know getting the infrastructure of the database right sooner rather than later is important. One...

Hi Rural Guy, I've gone about it a little differently than Allen did I think - I used the Access wizard to make the button and link it to the append query, so i didn't do any coding myself. I've gone into the event procedure for the click of the button and here is what it shows: (the append...

Hi Stopher, Thanks for replying! I've very briefly read through the post you made and I'm replying quickly to hope I can catch you again and briefly explain something. I have approximately 2000 different products, but not all of them are from the same brand. For example there are 75 Stihl...

Hi Rural Guy, Thanks for your help - after your first post I started looking into performing an append query. On my quote form I've managed to make a command button that appends the current record on the form from the "quote" table into the "orders" table - and I hadn't even thought about...

Hi Rural Guy, Thanks for replying. I've looked through the link and I think it may be a little over my head, and I'm not sure whether this method would suit what I require... "Archiving is best reserved for cases where you won't ever need the old data, or there are overriding considerations...

Hi, I’m using Access 2000. I use access to process orders for my company. I have two identical forms, one which I use to quote a customer a price, and another to actually process the order - one is called “QuoteForm” and the other “OrderForm”. Both forms are completely identical; they both...

Hi, I’m using Access 2000. I have various tables that contain the details, such as names and prices, of the different brands I stock. For example I have a table called “Stihl Products” which contains the names and prices of that brands product. I have another table called “Husqvarna Products”...

"Now when I run the query it brings up the list as usual, with various entries for dates rather than an individual one for each date - and when I try to "filter by form" it still brings up the list of multiple dates" Sorry I've just re-read the post and this line implies its doing something...

Hi Michael, I've created a query in design view, added the date and the sales columns, I then clicked the sigma icon and it added the totals row with "group by" entered for both "date" and "sales" columns. I then changed the "group by" on the "sales" column to sum. Now when I run the query...

Hi, Before I post on here I always try to look back through the posts for similar problems – however I don’t know where to start looking to solve my problem. I use access to store and record the details of my sales. As well as the prices, I also store the date of the sale. I want to be able...

Hi, I'm currently using Access 2000 and I'm having trouble with one of my forms. I have two sets of fields, one for "billing address" and another for "delivery address". I want to have a "delivery same as billing address" tick box on the form so when it's ticked the data thats been entered in...

Hi, I'm using Access 2000. I've created a table and form to input data for my receipts. I'm using autonumber to assign a number for each receipt. However I would like to start the numbers from a high number, such as 0002354, 0002355 rather than 1, 2, 3 etc. is there anyway to do this? Any...

thanks pbaldy, sorry, i dont quite know how to do this?

Hi, I'm using Access 2000. I currently use two forms, one to enter my [customers] info, then other to enter the [products] they want to buy. Once I've entered the customers details, I want to be able to press a button and it open up a new record in the [products] and already show the customers...

Hi, I'm using Access 2000. I have two fields in my data entry form that are side by side, one is a price including tax, the other is the price excluding tax. The raw data that I get is the price including tax, so I enter it in. Currently I use a calculator to find the pre-tax price. (The tax...

Hi, This is probably the easiest thing in the world to do but I've been beating my head against the wall for some time now. I'm trying to print out my customers information in a letter, using a report. For example, a customer asked for a price on a product, I enter the data on my form and when...

BINGO!!! Thank you ever so much for your help guys! I went back through it and I hadn't created my report properly, it wasn't linked correctly to the query I'd made, gonna have a tinker now and try to remove the empty spaces using that code. Thanks again guys, you've really helped me out!

Thanks for you help guys, I'm almost there!!! GaryPanic... I've followed all your instructions, but I don't know how to link the print button to the query, and the query to the report! At the moment when I double click the query, it asks me to enter Parameter Value, so I enter one of the...

Thank you MicroE, entered the code and it works perfectly, thank you very much indeed!

Hi, I'm using Access 2000. I use a feedback form on my website to receive my customer details by email. Currently I print out the data and type it into my form. I can alter my feedback form so the data in the email is seperated by comma's. Is there anyway I could import the comma seperated...