Search results

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

Hi Folks, I am trying to create a subquery which populates an intermediary table using the primary keys from four other tables. Insert into Person_Character_Film_Role (PersonID, CharacterID, FilmID, RoleID) VALUES ('" & PersonID & "', '" & CharacterID & "', '" & FilmID & "', '" & RoleID & "')...

Hi Bob, The problem with this solution is that, with the add person data form, the user wants to add the persons details manually and not be selecting them from a combo box, as they will be populating the database. The reason that the film and role combo's exist is to save the user from entering...

Hi, It's late here now, past midnight, will look at this tomorrow, thanks, could you tell me how how BOUND the controls. I thought they were already bound when I created the form and the wizard asked what data source to connect to. cheers chris

If I bind the controls to the form, this wouldn't solve the problem, I can bind the control to the actual tables, but, correct me if I am wrong, but this wouldn't affect the intermediary table as nothing is bound to this table. From the solution from the previous post, I can now write the SQL to...

Hi There, Thank you very much for the reply, this looks like exactly what I need. One more question please if I may, while I now see that the table fields are now being populated directly from the fields on the form, how do I populate the fields in the intermediary table using the primary keys...