Search results

Hi, Please be gentle with me…..J I would be extremely grateful if anyone would be willing to spend a little time to give a critique/review of the Tables & Relationships and highlight any areas that need to be improved. Brief Requirements At this stage, I have done everything within my...

Hi, I have read that AutonumberID's should NOT be shown to the User? But are there any exceptions to this rule? I have tblFinance which, hopefully, will have hundreds of different income and expenditure transactions every day and thousands over the month? I was thinking that a simple...

Please could someone advise how I can change the backcolor of a Control to a specified colour when a different Control receives the Focus, APART from when the Form is first opened? I have the following Controls on my Form:- ContractID ContractDetails When my Form first opens, ContractID...

Hi, i haven't seen any threads that request an overall database review? i am at a point in my DB development where the number of Forms will increase and i wondered if an overall DB review has been suggested before? thanks

Hi, I have a simple two-box Cascading Combo on my Form (see attached database and/or coding below). It seems to work fine, so far, but needs some fine tuning. So what I am trying to do next, is to work out a simple solution for the following situations:- 1. When TransactionType is...

Hi, I was wondering how people keep all their Report designs the same? I mean, how to make it easy for every Report to have the same text font, text size, logo header, same footer message etc etc???

I have a Sub Form Menu (with various Command Buttons) in the Footer of my Forms. But at the very top left hand corner of the Sub Form Menu is a dotted square box. It is the same size as my other Buttons, but it is not actual Button. Please does anyone know how I can remove/hide/exterminate...

Private Sub cmdExitForm_Click() On Error GoTo Err_cmdExitForm_Click If MsgBox("Do you want to Save the record?", vbYesNo + vbInformation, "Please confirm:") = vbYes Then If Me.Parent.Dirty = True Then Me.Parent.Dirty = False DoCmd.Close Exit_cmdExitForm_Click: Exit Sub...

When Combo1 is updated, I check if TextBox1 is empty. And if TextBox1 is empty then I do NOT want Combo1 to be updated (eg. I want the original selection to remain). Please could anyone help me how to do this?

Hi, I am very new to VBA coding and would really appreciate any guidance you can give. I have a Combo Box (MethodMoneyInOut) and if anything apart from "Cheque" is chosen, I want to lock and disable a control called "Cheque No". But I do not want the new selection in MethodMoneyInOut to be...

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

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

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

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?

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

I am trying to lock one Control based on the value of another. But my coding does not seem to work. Any ideas on what I am doing wrong? I put this coding in the After Update event but get "Syntax error" =IIf([AmountReceived]<10000,[Commission Percent].[Locked]=True,[Commission...

Currently my Forms are set at 6" width. The left margin of the Form starts on the far left of the screen. The right margin is approx half way across my wide screen (with high resolution). Is there any suggested standard width for Forms which make it look OK on most screens at most resolutions?

Hi, What code do i need to change the backcolour of a control to light yellow when it has the focus? I know how to do this using the Conditional Formatting Manager, but what code goes in the On Go tFocus event? Would I also need to put code in the On Lost Focus event as well...

Hi, I have been trying to add a ComboBox (on my Income Form) with data from tblTransactionType. My problem is that the ComboBox seems to be duplicating most of the records. Please could someone let me know where I am going wrong? Thanks if you can?

Hi, I have just found out about Anchoring. Now I have managed to stretch my Logo and Page Titles across the screen (whatever the screen size). But I have two columns of controls (text boxes and combo boxes) in the Detail Section which I want them to keep the same width and height and do not...