Recent content by Crackers

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

Reply to question from JimmyK Compile error: Expected: Case Also the SELECT line and the ORDER line are in red text

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