Search results

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

Hi Pat, Thanks once again for your help (I don't think this is the first time you've come to my rescue!) That worked fine. I do actually need fields from tblInventory, but I removed them from the example statement for simplicity's sake, to remove as many factors as possible which weren't...

I'm experiencing exactly this same problem, but I can't seem to get the query to be updateable even after following the instructions provided here. What else can be causing this? I have a two-table query which I can't update, but I have a three-table (unenforced joins) query elsewhere in the...

Pat, I've been trying to duplicate what you did so I know for next time. You mentioned that once the duplicate fields were removed, "you were able to fix the master / child links". I've got my queries looking the same as yours, but the form still doesn't work, I still have the original problem...

Yes thanks for doing that Pat, your message was obviously posted while I was writing my reply to Wayne. Has answered my problem.

Hi, Just noticed Pat's reply, and yes that does seem to work, thankyou to both of you for your help. To answer your questions Pat: The form is intended to show pieces of software in the main part of the form and associated information, while the subform is intended to show all the actual PCs...