Recent content by SimonCleaver

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

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

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

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?

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

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

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

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

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

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

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

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?

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

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

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