Recent content by chris davies

Hi there, I found the solution, by creating a new macro and selecting maximise and then naming the macro autoexec, then by calling autoexec on the onload event, which I finally found by right clicking on various parts of the form. The most irksome part was finding where the onload event was...

where is the form's onload event?

well I've tried all of these to no avail, any further input please?

Sorry to take so long to reply, have fixed my form. Where exactly do I put the DoCmd.Maximize command? I must have misundertood originally because I tried to put it in the op open event via the form's properties. The Db has grown somewhat in size and is now too large to upload

errm, put DoCmd.Maximize in the on open event, now the form refuses to open arrgh, thank god for back ups lol

I have looked but can't seem to find a method to make my form open at full size. Is this possible, what may I be missing here. Any and all answers gratefully recieved. thank you.

Are your form fields connected to a table or query? If not add an SQL statement to the button. Turn your form into design mode, right click on the button and select build event and paste your sql. something like this: Dim strSQL1 As String strSQL1 = "INSERT INTO Person (FirstName, Surname,)...

this always works for me Forms.Item("formname").Visible = False :O)

OK peeps, I'e nailed the problem. After taking a long hard gander at the northwind database (an excellent piece of work that is I must say), I notice that some of the foriegn keys, which were numbers, didn't actually display as numbers, but as the actual records (eg product as opposed to...

OK peeps, I'e nailed the problem. After taking a long hard gander at the northwind database (an excellent piece of work that is I must say), I notice that some of the foriegn keys, which were numbers, didn't actually display as numbers, but as the actual records (eg product as opposed to...

HI there again, I tried what you suggested, but if I create a form this way, it adds the persons name again and the role and film and character data, all I want to be able to do is add the ID's to the intermediary table (characterId, roleID, filmID and personID) to avoid any replicating data...

I'm not 100% sure here, but looking at the properties for testbox/visible, all I see is a Yes or No option. Have you tried the word No instead of False?

ok, I been having another go at this problem, and and followed the above instructions regarding subforms etc,while the relationships look ok to me, and appear to work well if the data is entered manually, if I add a another entry for a person already existing in the database, the database add...

I see what your saying, but the thing that is niggling me the most is that all the tables are set for cascading updates and deletes so if the main tables have data posted/written to them, shouldn't the intermediary table be updated automatically? I was hoping that I wouldn't have to use...

Hi I want to Insert four values which are primary keys from other tables into an intermediary table