Recent content by *Pete*

Thanks for the help, that worked perfectly.

Hi, I can't seem to combine these to one button. I need to open a form based on the values in two fields. Seperatly they work, when i try to combine them using the AND function it comes up with the error data mismatch. Private Sub cmdEvidenceSummary_Click() On Error GoTo...

That is perfect thank you, that is exactly what i need to do. Thanks for your help. Pete

Hi, I'm trying to create a database that holds data on people and some questions. I have created two tables one for the people and one for the questions. Is there a way that i can link the two tables so that when one of the people answers the questions the answers are linked to that person? I...

You are a star! The second option worked. Thanks for your help. Regards Pete

Hello, After using the Beta Version of Office 2007 i uninstalled it and tried to use out look but get the message. "Cannot start Microsoft Office Outlook. MAPI32.DLL is corrupt or the wrong version. This could have been caused by installing other messaging software. Please reinstall Outlook."...

Hi, names that are the same as device names won't work. Con is short for console. Com1 won't work either. Regards Pete

Thank you very much for your reply, and thanks for the extra help on checking if the path exists. Thank you. Kind Regards Pete

Hello, I'm using the following code to create folders, which seems to work fine. Private Sub CmdCreateAreas_Click() strDirectoryPath1 = DLookup("Centre_DataLocation", "T_CentreDetails") & "\Files\Students Files\Stored Assessments\" & [MainFolder] MkDir (strDirectoryPath1) End Sub What i...

You could use a lookup field type in the Second table to lookup the values from the first table.

You would need to look for a common Feild in each table and set up relationships between them. That said, if you have 5 tables with the same data in each are you not defeating the object of a database? Can you give some more details on what the data is for? Regards Pete

Yeah, i tried that but it did not work.

Help!! I'm having real problems with forms in word... I have a drop down list named Dropdown1. I have a text box called Text1 with the function: {if Dropdown1="A" "Y" "N"} Whatever i try to do with this it will not display the correct result. Can anyone help or point me in the direction of a...

If you create a form from the query, you can select the text box from the column you want and format it to green.

If you go to the properties of the subform under the format menu you can select continuous forms rather than datasheet. Hope this helps. Pete