Recent content by GregP

Thanks George. I originally tried to make this form with the form wizard but it didn't give me the option of creating a subform during the wizard process. So I had to end up designing it from scratch and manually adding the subform, which seemed to work until I hit this. Must admit my greenness...

Hi guys, I have a form with a combo box, and when you select an item from this combo box it displays all the records that match that item in a subform. All OK so far. Trouble is, once you've selected an item and the matching records are displayed, when you then click in the subform the first...

Anyone?? I can't imagine the solution is rocket science, but without the right syntax I'm stuck. Thanks in anticipation!

Gday, I posted this in the "Word" section since it's a Word document I'm working on, but I'm guessing it relies on VBA anyway, and the lack of response there has led me here. I'm doing a mail merge and I want to instruct Word to retrieve the contents of the previous record, not the next...

Is there some way to adjust the vertical alignment of text in a text box in a Access 2k2 report? It seems to do top alignment by default, but I want to change this to bottom alignment.

Display most recent record when multiple records for an item exist Hi, I have a table which stores a list of all our loan computers and their loan history. Each time a computer is borrowed, a new entry is added to this table, and when it's returned, a checkbox is cleared to show it's no longer...

Hi Pat, Yes, that worked! I had tried something similar in my early investigations, but kept getting an error message about an ambiguous outer join (there are three tables in my query) which only came when I changed the matching join on the 2nd and 3rd tables to a left join. But when I changes...

That works, but again only if the child form has a record matching the machine currently shown in the parent form. I need the child form to take the field value and display it from the parent form, regardless of whether there's a matching record or not. Another thought, can the parent form maybe...

Hmm, still no go. I get a runtime error when I put: Me.TestEE = Forms ("frmInventory") ("EE_No") in the Form.Load property, and it doesn't do anything in the TestEE.BeforeUpdate (Cancel as Integer) property. I also put the same thing in the control source of an unbound text box, but that...

I don't want to use a subform in this case, because the information won't be needed that often, so I'd rather have it accessible by just a button rather than a permanently displayed subform. It's also neater for the form layout I have. I couldn't actually get either of those methods to work...

Hi, I have a parent form which contains information about PCs on our network. In this form is a button which, when clicked, will open a second form and display any licensed software installed on that PC. The heading on the child form is 'Licensed software on <asset number of the PC in...

Hi Pat, Yes, as you suggested, my scenario was like scenario 3. Translating this into my situation, I can't really see how it worked the way I described. Every time I entered data into tblB.Datafld (tblInventory.EE_No), a new record would be added to tblB (tblInventory). Maybe I am insane...

Now I really feel I'm going crazy. After what I thought was a success, I got to work this morning and found the changes I'd made to the database were all gone. The results I now have are different. I have two tables: tblLicenseIssue and tblInventory. The purpose of this query is to add...

Great, thanks! :) Greg

Hi Pat, Yes, thanks for what you said - I realised why my 2 table example didn't work, and it did what I wanted it to, but there had been a couple of earlier suggestions about how to fix it, so I was very interested to know whether the key is wholly and solely the join type, or whether some of...