Search results

I have a database at work that everyone uses. The database has been saved to each person's hard drive. The database is used to create a note for another system, whereby you put in the required information into the form and then paste that information, which has been collated into an Textbox...

I have a form that I am in the midst of creating. On this Form there are several football club names (e.g. A1, B2, C3 etc.). These buttons contain the Team List for the club. I have set a macro up to email the list to the relevant contacts for each Club. But if some club changes the contact...

I have a form that lists the winners of certain awards. As the Heading of that Form I have the following text (as an example): Best & Fairest Winner for [txtbox]. I have put the simple formula =Now() in the Textbox, but all I want it to do is show the year and not the actual month or day. I...

I have a Table that lists the Members of a local football League. The Table contains Surname, FirstName, Address, DOB, Club and Age. The table contains approx. 2,000 entries currently. In order to stop Players re-registering with another Club, I wanted to have a message come up when the same...

I have a Form based on a table of current Players in a football league. The Form is used to edit, but mainly add new registrations. The fields are... Surname FirstName Address Suburb Age Club YearRegd Is it possible in some way to have an alert or message come up stating that the Player...

Yesterday I posted a question and rec'd good advice but as usual I don't think I explained myself very well. As the attached picture of my Form shows, I have a checkbox for each Age Group under each Team. I originally had a query that would come up for each Team's particular Age Group and then...

I have a Form that currently contains a checkbox that has the following OnClick event... SELECT tblPlayerRegister.Surname,tblPlayerRegister.[Club],tblPlayerRegister.Age FROM tblPlayerRegister WHERE (((tblPlayerRegister.Age) < 11) And ((tblPlayerRegister.Club) = "Beaconsfield")) ORDER BY...

I have a form with a command button that when the Mouse is moved over the button I would like it to show a small image, or at the very least text. I know text can be shown with ControlTip Text but that does not give me much chance of variations, such as Multiple Lines. First of all, is this...

On my Form I have a comman button with ControlTip Text that advises the user of what will happen when they push the button. Could someone please tell me why the Text is now not appearing when I put the mouse over the Command button? Thank-you for any help given.

I have a ComboBox [cmb111] that contains a '+' & a '-'. Next to this I have a text box that contains a $ amount. The operatives are required to press the combo box indicating if there is an Increase or Decrease and then type in the amount in the text box. After this has been done, the cursor...

I have a Form named frmClearances that lists the name, age, Club Clearing From, Club Clearing To and the Date of Clearance... this is used for my local sporting Club. I have created reports that separate names into "Clubs Clearing From" so that each Club is aware of who has gone. The Reports...

I have a Form that contains a Textbox (txtSummary) which summarises all information that is contained on that Form. All I want to do is print the textbox only, as a quick reference for other people to look over. I searched this Forum beforehand to see if the printing of the textbox was possible...

I have a Form that I am doing for my local sporting Club that keeps a check of the games played each week by individuals. On my form I have a Textbox (txtGames) and a number of checkboxes that are to be checked if the player plays a game that week i.e. TotalGames....Wk1...Wk2...Wk3...Wk4 etc to...

I have a textbox (Named 'Text104') that contains the following formula: =[Text103]+10 Underneath this textbox there is a checkbox that on the odd occasion will need to be checked. Is it possible, that when the checkbox is checked, the textbox above will add an extra 1 as well as the 10 that has...

Yesterday I was advised by 'Smart' on placing a certain code, as follows: In the after update trigger of the combo box you can do the following If YourCombobox = "-" Then yourtextfield.ForeColor = vbRed Else: yourtextfield.ForeColor = 0 End If __________________ Please forgive my ignorance...

I have a form that has a Combobox containing a '+' and a '-' field. Next to the combo box I have a text box that when input will contain a dollar amount. The Form is used as part of my job and there are many operators that will use it. The operators are not the end users of the form therefore it...

I have two questionaire forms in a database. There are no tables or queries involved. The answers to each questionaire are compiled into text boxes, one on each Form. On the main form I have another text box that puts all the answers together so that this can be transferred to another program...

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