Recent content by colmoore

Thanks! Sergeant Thanks for the "plaster" It works fine now, doing exactly what I wanted. Basically what I'm trying to do is make the form print a receipt for the competitor to take away with him so he can remember which teams he selected. I take your point about the structure of the...

Hi Sergeant, Thanks for your help. I response to your reply: I don't presenty have any record source specified on the report. I DO have the selected teams stored in a table, as you supposed. I'm afraid I don't get the part about how to transfer them. The report is called RECEIPT The form...

Hi All, I've attached a picture which shows the problem. I need to know the expression required to transfer the name of a football team (selected on a form with a combo box) onto a report. The teams all have ID numbers, and so far its the ID thats getting transferred, not the team name. Any...

Thanks Thanks Bat, but what is it I need to change to get rid of the box???

Hi all, Just put some buttons together, and I notice when I click on them I get a box appear on the button itself. Strangely, some of the boxes are solid likes and some are dashed. Just wondered what they are, and how to change/get rid of them. See sample below Thanks Col

Hi there, I'm making a report detailing competitors final finishing positions in a competition. The columns are (1) Place, (2) Name and (3) Points I have the data for their names and the points they have scored, but how do I make the table enter the record number (starting at 1) in the first...

It ZIPS down to 312kb. Is that small enough?

Ken, Oh, now you've lost me. I only have a limited understanding of Access and only got the box to work in the first place using the Wizard! Could I perhaps send you a cut-down version of the database by email so you can have a look at what I've done? Then you can find the answers to those...

Ken, No, the combo box is unbound. Should it be bound??? :confused:

Hi all, I've designed a stock control form which enables the user to view stock bought and sold simutaneously. I have a combo box at the top of the form to select the item the user wishes to view. Then, on two seperate subforms, I have records of stock bought and sold. The thing works fine...

Thanks Pat, Thanks so much, your advice has solved the problem Regards Col Moore

Error Hi there, I'm just getting #Error where the email address should be. Any ideas???

Hi all, Successfully managed to get the following to work: =[SALUTATION] & " " & [FIRST NAME] & " " & [SURNAME] But when I try a similar trick with the email and Date of Birth fields it doesn't work. I'm using: ="Email " & [EMAIL ADDRESS] and ="Date of Birth " & [DATE OF BIRTH] ??????????

Done it! Richary, Thanks very much Cheers Col

Hi there, I am making a report which details the title, first name and surname of members of a club. I have 3 fields TITLE,FIRST NAME,SURNAME. I have them displayed on the report, but the problem is because each is in its own text box, the words are spread out, like: MR<big space>JOHN<big...