Search results

Thanks I will toy around with your solution. Cheers Charlie

Hello, I have created a database in Access 2002 which on opening starts up a menu form containing buttons linking to the other forms in the database. I have a macro setup on each form to maximize the size on opening, my problem is I want the previous form the menu to close when the...

Thankyou You have my eternal gratitude. :)

Im composing a letter to be attached to a button on a form to preview a letter about a debt. The thing is when I open the letter, the data that I have entered is repeating and I dont know why, I know I can finish this letter if I can only find out why the data is repeating so I can stop it...

LOL Thats a good one! I just made several more text boxes and cut the text into parts and put the date field in one of its own. It works for me. Thanks Charlie

Its OK I found a way to achieve this, probably not the correct way but it works for me. Thanks anyways. Charlie

This seemed simple enough to do but upon trying it I cannot get the date to appear in my letter. I have included the whole text from the letter so you can see where I want the date to be, as you can see the date part is entirely wrong, how can i correct this error. ="If we have not received...

The Problem The problem is I get an error message stating that I cannot save the record at this time when I enter a code, it seems to convert to UCase but there is a problem.

I am trying to make a macro that i can assign to the after update property of a text box on a form, I have tried this in the macro: Set Value Item :[Forms]![frmTenants]![Credit_Ref#] Expression: UCase([Forms]![frmTenants]![Credit_Ref#]) The trouble is this wont work, what am i doing wrong...

Tried the advice Great, I found the solution thanks to you. Charlie

OK I have created a form which shows tenants details, I have also created a report which shows a breakdown of all the tenants rent details. What I wish to do is create a buttton to link the report to the form so that the report will only show the relevant rent records of the tenant being viewed...

I think so too Yeah Rich I think the problem lies in the one to one relations myself. The reason I want to use an append query is plain and simple, I am learning about append queries at the moment so I want to include one in my database. Charlie

Tried This This is as close as I can get to what you said: This still doesnt work, I dont know if this is exactly what you recommend, I am beginning to think using an append query for this is impossible. I know I can do it with an update query but I want to use an append. Charlie

Yeah An Append query is what I want.What puzzles me from your post is that the append So which table do I get the tenant ID from tblProperty_List doesnt have that column. Charlie

Tried It I tried adding a column called Tenant_Id to the Property_List table and running the append query to update the amounts of rents in the rents table and got the same error message. Am I taking your advice or have I screwed it up once again? I have updated my file.

Ahh Thanks mate, I think you mean tblProperty_List requires a Tenant_ID because the tblRent has one already, at least Im hoping thats what the problem is. Charlie

Im trying to make an append query to add the weekly rent amouts from one table called tblProperty_List to another field called Amounts in another table named tblRent. I made the query thinking oh this is simple enough, but upon running the query I received an error message stating the records...

AaaAAAaAGGggh Ive got it I didnt realise the =Sum([Amount]) had to refer to a column. The column that I want totalled is called Warranty Charge, so I simply changed the subform control to =Sum([Warranty Charge]) and my original vers works. =[frmWarrantyList Subform].Form!txtWarrantySubform :p...

I still get an error I used =[Forms]![frmProvider]![frmWarrantyList Subform].[Form]![txtWarrantySubform] I thought it would work that time. I also tried =[Forms]![txtWarrantyMain]![frmWarrantyList Subform].[Form]![txtWarrantySubform] Oh god this cracks me up. Thanks for the advice anyway Rich

Ok I am trying to do a calculation on my main form totalling some amounts. On my sub form the control source is =Sum([Amount]) my subform is named frmWarrantyListSubform, the Textbox on the footer of the subform is named txtWarrantySubform. My main form is named frmProvider, my control source...