Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Duplicity

    Recording dates and tmies of queries

    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...
  2. Duplicity

    Recording dates and tmies of queries

    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...
  3. Duplicity

    Recording dates and tmies of queries

    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...
  4. Duplicity

    Recording dates and tmies of queries

    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...
  5. Duplicity

    Needed expert opinions on MS Access Forms and Web Pages

    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...
  6. Duplicity

    UK designers - how much to charge & other questions

    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...
  7. Duplicity

    Macromedia Upgrade

    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...
  8. Duplicity

    Help creating user name and password to access page

    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...
  9. Duplicity

    Help creating user name and password to access page

    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...
  10. Duplicity

    email data base question?

    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...
  11. Duplicity

    Needed expert opinions on MS Access Forms and Web Pages

    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...
  12. Duplicity

    Do Command: Save & Close From

    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
  13. Duplicity

    Do Command: Save & Close From

    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...
  14. Duplicity

    SQL from Access form to Excel named range

    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...
  15. Duplicity

    Move contents of textbox to textbox-command button

    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...
  16. Duplicity

    SQL from Access form to Excel named range

    Wow. Thanks for taking the time to respond Rick. I'll take a look at your suggestion and try to apply my non-existent programming skills to it. Wish me luck (lots and lots of it) Thanks again.
  17. Duplicity

    SQL from Access form to Excel named range

    I’d like some help with an SQL query from an Access database to an Excel named range. The scenario is this: On an Access form that displays the usual suspects of customer information from a table called Clients; ClientID Name Surname Company Name Client type – selected from 3 possibilities in...
  18. Duplicity

    SQL from Access form to Excel named range

    I’d like some help with an SQL query from an Access database to an Excel named range. The scenario is this: On an Access form that displays customer information from a table called Clients; ClientID Name Surname Company Name Client type – selected from 3 possibilities in a drop down menu...

Part and Inventory Search

Back
Top