Search results

Hi I have created the following delete query, without a parameter DELETE [tblStudents&Classes].*, [tblStudents&Classes].StudentID FROM [tblStudents&Classes]; What I would like to be able to do is double click on a field in a form to invoke the deletion. Could someone please tell me how to go...

Just a thought, did you save your old word document in the new format also?

You could create your own icon and use that in place of the the standard word icon for the embedded document?

Your question is too vague. Why don't you upload a copy of what you are trying to work with?

I can see an easier solution to this problem. Why not use an embeded excel worksheet which will do the number crunching for you. good luck

I have had a look at your problem and suggest when you use the autoshapes that you place the order of them ontop of text and then change the opacity so that you can view the text. Tanya

The easiest way to mail merge automatically to associate the datasource with the template and use the mail merge wizard. cheers Tanya

Hi I have a db I have been working on for keeping record of student competencies and guess what I want to do will involve maketable queries and intricate forms. The db works at the moment but it is very tedious selecting each student, then allocating units, elements, competencies. What I am...

Paul I understand now, thank you for your advice. Regards Tanya

Paul Are you suggesting the Function ap_DisableShift() referred to in the webpage in my previous post is insecure? I am interested for myself because I was intending to use this solution on a database I am working on. I also lock the properties of my code with a secure password. Is this...

Hi I found this site which answers your question about disabling "shift" key on startup http://www.tek-tips.com/faqs.cfm?fid=93 goodluck

Hi Michael While reading one of the responses to your problem it occured to me that you may be simply missing ".value" from your code. May I suggest you add this i.e. objXLBook.SaveAs ("C:\" & Me.LastName.value & ".xlsm") Good luck Cheers Tanya

Hi huskies, I am no expert by any means but it did occur to me that if you create a new combo box with a list you provide [i.e. yes, no] and then assign value to your table field in question you may have more success with the code you are using. Also just a thought you mentioned you were unable...

I had a similar situation and got around this by not displaying the fields you wanted invisible to begin with. My form also allowed me to populate them through statements such as: Forms!Mainformname!SubformName.Form!FieldName = Forms!Mainformname!SubformName.Form!FieldName There is a copy of my...

Hi Chris Thank you for your support. I hope you have good day at work. I have finally found success!! After fixing the problem with the lost link I deleted frmCompetency and recreated it, then all worked as planned. I am self taught so this project continues to be a steep learning curve for me...

Hi Chris In an interesting development, the second statement does appear to work if you look at the table tblCompetency rather than the frmCompetency. I know it is rather strange but there it is. I think it has something to do with the lookup process. On a further note, after all this, it...

Hi Chris If you look at the tblCompetencies you should see that the first statement actually works. In this latest version, I have added a statement to update performanceID which works [this time I left it on the form so you can see that it updates the correct field] Which brings me back to my...

Hi Chris, I appreciate your hanging in there for me. If you look at frmCompetency in design mode, you will see that SubjectID is a field which is accessed by this form and this is working even though I have not displayed it in form view. txtstudent is used purely so the user can identify the...

Hi Chris In frmCompetency there is an unbound text box called txtStudent and it is updated with the following statement which works fine: Forms!frmAddComp!frmVETUnits!frmCompetency.Form!txtStudent = Forms!frmAddComp!subfrmAddComp.Form!Student With the second statement I have removed the...

Hi Stopher The first statement appears to be from what I can tell. ?? I'm not sure which form you were looking at to see this? The second statement like you said is looking at a missing table - couldn't work out how that could be, but have since rectified it. Still, I cannot see why the second...