Search results

I have a text box on 'Forma' & a textbox (named text3) on 'Formb'. I want to copy the contents of the textbox from 'Formb' to the textbox on 'Forma'. I have used the following code in the textbox on 'Forma'.... =Forms![Formb]![Text3].text This doesn't seem to be working whether both Forms are...

I have a check box that when selected will highlight another Text box which I then need to put in an amount ($). This amount I want copied into yet another Text box which contains other information I have provided. I have tried to use the IIf function but I am obviously not succeeding. In the...

I have a Text box on a Form that copies data entered into other Text boxes on the same form. I have used the formula =[Text2] &" "& [Combo26] etc in the main text box that I want all the information in. Sometimes there may be the odd text box that does not have any data in it. Is there anyway...

:confused: I have a Text box on a Form that copies data entered into other Text boxes on the same form. Sometimes there may be the odd text box that does not have any data in it. Is there anyway that I can put in code so that the blank text boxes are not copied into the main text box i.e. Only...

I have a Duplicates Query that extract the following information from my Table Name Surname DOB Joined The query then extracts info such as... Bill Smith 25:12:70 1999 Bill Smith 25:12:70 2005 Most of the time the 'Joined' field has the same year. But I need to find the...

When you enter a figure into a text box, is there any method that will lock that figure in so that it cannot be changed at a later viewing. Or is this pushing the envelope too far. Thank you in advance for helping.

I have text boxes on a Form that I need to update with figures each week. I have tried to have the entire field selected by right clicking with the mouse but I keep getting an error. The coding I am using in the 'OnClick event' is: Private Sub Ctl1_Click() Me!R1.SelStart = 0...

I have a Text Box on a Form that copies the data entered into other text boxes on the same form. (i.e =[NAME] & [ADDRESS] & [PHONE]). When the data goes into the main Text box it appears as such: BillSmith1HappyStreet5556159 How can I put spaces between the different fields, and can I start each...

Thank-you :) Thank-you very much, that worked perfectly

I have a Table that contains names of Players for a football league and relevant information pertaining to their football. I would like some advice on how to Filter certain information on a form that will call up only those Players that fit the criteria. The 2 pieces of criteria that must be met...

I have an AutoExec Macro that reads as follows:- Maximize Open Form [This form is a splash screen that comes up for about 3 seconds - Saying 'Welcome'] Open Form [This form is my password screen] Open Form [This form is the main Switchboard] My question is why doesn't the Password Form remain...

I have a Table [Players], that contains the following fields - Player....Club....U10I....U10B....U10R.....U10T The U10* fields are all Yes/No. Some Players have a Yes in more than one U10* field. My question is, how do I perform a query that will show Players that have a 'Yes' in any one or...

I have a Report which contains several sub-reports on the Report Footer. When I press Print Preview it shows me the Main Report information, which covers the first 6 lines of the page, then the Sub-Report information starts on the second page. How do I get the sub-reports to start directly...

Your suggestion was not just close, it was spot on. Thank-you very much for that.

I tried as you said, but I still only get 18, 18 and 17. I put '3' as the Top Values and then clicked 'Yes' for Unique values. What am I missing?

I have a Query that selects the total number of goals kicked by individual players for a season. [Aussie Rules Football]. The first field is the Total Goals which is sorted in descending order. The Top Values field is put at 3. I have 5 players who have kicked 18, 16, 17, 18 and 15 respectively...