Search results

Please could someone help me with my Relationships!!! I think there is something wrong with the Relationship between tblFinance (where all the money transactions in and out are recorded) and tblContract???? Currently the tbl.Contract.ContractID (PK) is a one-to-many relationship with...

Alan, That tip is absolutely awesome. the report looks superb. However, the report prints ALL the records and not just ONE record. Otherwise it would be perfect.

thanks for your input, davep56

Problem solved!!! Not sure why it is solved, but I made the original rectangles by copying and pasting 9so they woudl have all the same attributes. Only when i deleted them and made "new" rectangles, was i able to drag and drop the text boxes onto the rectangle.

I have just tested it using a Text Box (disguised as a rectangle) and I can drag and drop the Text Boxes onto it. So i could change my rectangles to text boxes.....but I wonder why a simple rectangle will not let me do this. A rectangle is just used for design and good-looks purposes, yes?

Yes, I have decided on a specific layout so that all my Forms look the same. I just want to drag and drop the text box controls into the Rectangles, so starting with a blank form isn;t really what I am looking for. I thought it would be simple just to drag the text box control onto the top...

I have made a template Form which has Rectangles which contain certain Text Boxes. I have set the Rectangles to 'Send To Back' and they are in set positions. However, when I try to drag and drop a TextBox control onto the Rectangle, the Rectangle moves away. Does anyone know why this...

thanks for the suggestion, alan.

and here is how to do it easily... Select the Textbox icon in the Toolbox (Acess 2003) or onthe Controls group of the Design Ribbon (Access 2007 and later). The title of the Properties box reads "Default Text Box". Set the properties that the new text boxes (and other controls) that they should...

That is because all the data is on the Form page already. I can't see why I would need to create and design reports which would look identical to the Form? This seems to be duplicated work?

Yes, I do want the option to print a Form. I am not able to find a resource which advises what width to design a Form so that it prints on standard A4 paper? At the moment, my Form is 9" wide and it prints on 4 pages :( Please could anyone direct me to which settings i should change...

thanks for the clarifications

could do. but with more than 50 fields per form, it would take a long time to change the Control Source of each text box?

Yes, I understand the controsl are re-sizeable. But I was wondering if they could be 'dragged' onto the Form already to the required size of my database? I want them to fit snugly into a Box.

I have been searching for a way to customise the height and width of a Control when I drag and drop it onto my Form. Is there such a setting rather than the standard MS setting?

thanks again, Alan. have i understood correctly that an update query will update all records? in this instance, it is only the current record that needs to be checked?

Thanks very much for your comments, Alan. Yes it is a good suggestion to hide the WorkOrder control until the TransactionID says WorkOrder. I will probably go down that route. But, I was also thinking of potential conflicts when the WorkOrder control is populated:- a) How to remove any data in...

I wanted to share with you another way of doing this, using a one sided join. First I created a query to joins Contract, Renter, Property and Owner. In frmIncome1 (Copy of original) I then added the new query as part of the recordsource using a one sided join. I finally added the extra...

On frmExpenditure I have the following ComboBoxes:- TransactionTypeID ContractID WorkOrderID (eg. maintenance work) I am trying to think if there is a user-friendly way to enter data into only 2 of the comboboxes, instead of entering data into all 3? Note: all the Tables have a...

That's fantastic, JBJ. It works a treat. Oh my database looks so coooool!!! Thanks very much for your help.