Recent content by Duplicity

That's an interesting idea and might just do the trick. I'm going to think about it a bit more and see if I can imlpement something along those lines. Many thanks for your input. It's given me a springboard to start from and simplified the database design enormously from the concept I'd been...

Each table corresponds to specific tests or overchecks performed on those items listed in them. A record in table "A" may be flagged for attention for a certain timespan. If the necessary work has been completed on the record within that timespan it will be moved to the next stage of...

Easy for you to say but for an infrequent and often confused Access user, any further hints ? Thanks for the very rapid reply though, if I only knew how to implement it...

Here we go: Imagine three tables, called A, B and C respectively. Each table has the same fields: ID [autonumber], Field1, Field2 and Field3. If I wanted to move information out of one table and into another, then again into another, then possibly back to any one of the three, I would like to...

OK, with respect, "a dozen tables and a few queries" does not constitute serious rocket science unless your tables each have millions of fields and your queries are seriously convoluted. Let's try and break this down and see if we can't make a big thing into a more manageable series...

I'm from the UK. While these aren't necessarily my prices, for static pages you could do worse than start at around £35 per page (not including dedicated graphics design). Dynamic PHP/MySQL sites start at £800 to £1000 (very simple data driven site) and costs go up from there. Graphics design...

Some designers who do a lot of work, especially where they host many sites on their own servers, write their own CMS for this kind of thing. It can be useful and sometimes even necessary to have quick and easy access to generate new pages, update existing page text copy or add/remove or...

The PHP Freaks site I gave you the link for above has more tutorials, walkthroughs and fully working examples than you can shake a stick at, all using PHP either on its own or in tandem with MySQL. http://w3.phpfreaks.com/ Any one of many other PHP sites will have similar articles. If you...

PHP works a treat if you know how to use it. Take a look at he excellent PHPFreaks site w3.phpfreaks.com for some examples of user log in. If you want people to register, depending on which country you are in you'll have to pay to join one of the data protection policies where you register...

You'd need two inter-related systems; an emailing app and user authentication. The user authentication would be used to allow initial account setup and to require subsequent logins (username and password) to access the webmail app. This would help prevent abuse by spammers but it seems to me...

More web hosts support PHP/MySQL which is also easier to learn than ASP. I am not going to argue the case for or against ASP since it is indeed a seriously powerful option and I do use it. It has to be said though that I normally go for a PHP solution in most cases, if for no other reason than...

Thanks people and yes, the code worked perfectly. It may seem simple to you but it had me bamboozled ! I'll learn, or so I keep telling myself... Thanks once more for your kind help. Best regards

I'm playing with Access (relatively new to it so bear with me) and I have a form with a "New record" button on it. What I'd like is to include a command button to save the newly input information typed into the form fields and close the form, all at the same time. I can set up the...

I can't get the above suggested method to work (my lack of knowledge in that area - I have no doubt about that). An Access append query I managed to come up with is as follows: INSERT INTO TransferTable ( Name, Surname, Company, Address1, Address2, [Town/City], County, PostCode, Phone, Fax...

I can do this in Visual Basic but on an Access form it has me flumoxed. (Why is VBA so completely different to VB in so many regards ?) What I have is a common dialog that allows me to select a file and copy its filepath to a textbox on a subform. That part works just fine. After the above...