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 Chriss Miller 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. SimonCleaver

    Connections folder outside public_html

    Many thanks for that. I thought it was incorrect, I just wanted confirmation. Many thanks for the advice.
  2. SimonCleaver

    Connections folder outside public_html

    Hi all, wonder if anyone can help a newbie. I have created Mysql database on webserver. Using Dreamweaver 8 and made a connection to the db, created php connection file which is in Connections folder. But the folder is located one level up (outside) from my public_html folder - is this correct...
  3. SimonCleaver

    advice on Table/form setup

    Thanks Ken, Sorry to keep using your time like this !!! The database is used by 2 users on a network. It is not split in any way. If you like I can send you a copy of the real database I have created - so you can see all my novice like creations/actions, ha, ha. Thanks very much for you help
  4. SimonCleaver

    advice on Table/form setup

    Hi Ken, Thanks very much for the help. Just one more thing, if I'm not being to cheeky. If I wanted to have the brochures selected via a lookuop box (combo or list) - would I need to make another table to store the brichure names or can this be included in the existing one?
  5. SimonCleaver

    advice on Table/form setup

    Thanks again Ken, I wouldn't dream of interrupting, ha ha - Im not that brave!!!! I think my wife is hoping for similar !!!!! I have created a brand new database using your ideas (I will then use the concept on my database if I can get it to work how I want - my live database is quite big and...
  6. SimonCleaver

    advice on Table/form setup

    Thanks again Ken, When I try to make these relationships, the CustomerID to Customer Id will set as a One-Many, but the BrochureName to BrochureName will only link as a one-one relationship, whichever of the 3 options i choose, it still says one - one. By the way - do you know if you can you...
  7. SimonCleaver

    advice on Table/form setup

    Thanks Ken, I thought I might need more tables. This may be a daft question, but when I create a new table for brochures sent - how do I create/specify the link to the CustomerID and the brochurename? I tried to use the Relationship but, but seem to go wrong somewhere. Thanks for the help
  8. SimonCleaver

    advice on Table/form setup

    I have a form for my customer details. I need to record when a brochure was sent to a customer. I have more than 20 different brochures and a customer may receive one, all, some or none of these. I also need to be able to run a report/query for each brochure manufacturer to tell them which...
  9. SimonCleaver

    Create new record with same company information

    Brilliant Thanks very much Paul - it now works like a dream!!!!
  10. SimonCleaver

    Create new record with same company information

    I tried both of the methods and both times it stopped on the first field that had a null value? Private Sub cmdNewCompanyContact_Click() Dim strCompanyName As String Dim strAddress As String ............(and so on) strCompanyName = Me.CompanyName strAddress = Me.Address ............(and so on)...
  11. SimonCleaver

    Create new record with same company information

    Hi Ken, Thanks for the advice, but it still gave me an error. Also the table is already set to accept nulls. Below is the complete code that gives me the error if a field is blank - what do you think? Private Sub cmdNewCompanyContact_Click() Dim strContactID As String Dim strCompanyName As...
  12. SimonCleaver

    Create new record with same company information

    Thanks Paul, This works well apart from one thing - If a field is blank on the original record, I get an Error saying: Runtime Error 94 - Invalid Use of Null" Do you know how I would get around this?
  13. SimonCleaver

    Create new record with same company information

    Hi All, Can anyone point me in the right direction? I have a form called Contacts and I wish to create a command button to create a new where some of the current record information is copied to a new record. Exactly the same as the "Create new contact from this Company" menu item in...
  14. SimonCleaver

    ensure text is entered in a field

    Hi - sorry if this is a dumb question but it has got me stumped. I have a field in a table (and also on a form from this table) for a "Description". I want to ensure that some text is entered in this field by a user. I tried the "Required" property set to yes - but the error...
  15. SimonCleaver

    Links in field on form to files on hardrive

    Thanks for the advice - I tried the new table method but received an error message saying there was a problem with the OLE Server or ActiveX control and I should restart it outside of my database and the re-open the database. Does anyone have any ideas what may have caused this - I have search...
  16. SimonCleaver

    Flash needs to reinstall after system is "cleaned"

    Hi, I use a program called Window Washer to clear internet history, temp internet files, etc. My problem is I think it also clears Flash Player. After I have run the Washer program and then visit a page needing Flash Player I am told to install the player. Is there a way of installing Flash...

Part and Inventory Search

Back
Top