We are currently struggling to cover the operational costs of Xtremepapers, as a result we might have to shut this website down. Please donate if we have helped you and help make a difference in other students' lives!
Click here to Donate Now (View Announcement)
Hey man so far i know you need to go through the webpage and read through the sections given and then write 1 of 2 points on the given topicsi have problem in this question too ....let me knw if you find ne solution to q 16 in m/j 2011
I believe u talking about of june 2011 aswell You need to change format of Avail_1 and other Avails into Yes/No format while your in "Import Text Wizard" from the option "Advanced".. it will comes us -1 or 0 which means ur going right.how do we change Y and N to yes no format ?
thnks man! but in which format do you import ?when i choose to import in yes/no in import text wizard there is error...I believe u talking about of june 2011 aswell You need to change format of Avail_1 and other Avails into Yes/No format while your in "Import Text Wizard" from the option "Advanced".. it will comes us -1 or 0 which means ur going right.
And then while making the query, Click on the properties of field Avail_1, from General, click on Format and make it Yes/No. On next to General is Lookup click there, make the Display Control to "Text Box". make it same for others
Screenshot of where u find the General and Lookup.
did u finish yours...if you did can you give it to me by email or nething at all ?Hey man so far i know you need to go through the webpage and read through the sections given and then write 1 of 2 points on the given topics
Reallly? :-O cause im not getting any errorsthnks man! but in which format do you import ?when i choose to import in yes/no in import text wizard there is error...
did u do the activity in book?
i use microsoft access 2007 and i convert my csv to workbook and then import it with import excel file option in access and during import.i change it to use yes/no data typeReallly? :-O cause im not getting any errors
Anyway tell me the steps how u do it then i think i can help you!
it does not show in 0 or -1 format but it just shows Y and N format i thinkt here is the problem.but i dont how to change the Y and Ni use microsoft access 2007 and i convert my csv to workbook and then import it with import excel file option in access and during import.i change it to use yes/no data type
Instead of doing all that, you can click import and from the drop down choose "text file" and then try doing it again !!it does not show in 0 or -1 format but it just shows Y and N format i thinkt here is the problem.but i dont how to change the Y and N
You mean AS Applied ICT?then yeahany 1 has source file for 2009 mayjune ppr 2 ict ?
tYou mean AS Applied ICT?then yeah
thnxYou mean AS Applied ICT?then yeah
ok butInstead of doing all that, you can click import and from the drop down choose "text file" and then try doing it again !!
how do we change Y and N to yes no format ?
I believe u talking about of june 2011 aswell You need to change format of Avail_1 and other Avails into Yes/No format while your in "Import Text Wizard" from the option "Advanced".. it will comes us -1 or 0 which means ur going right.
And then while making the query, Click on the properties of field Avail_1, from General, click on Format and make it Yes/No. On next to General is Lookup click there, make the Display Control to "Text Box". make it same for others
Screenshot of where u find the General and Lookup.
upload one of your file(zip the file first and then upload).. make sure there's no virus in it... a virus caused me fare bit of trouble recentlywhenever i close my excel all the formulas goes away its not there anymore....wht should i do so that they do not vanish ?
For almost 10 years, the site XtremePapers has been trying very hard to serve its users.
However, we are now struggling to cover its operational costs due to unforeseen circumstances. If we helped you in any way, kindly contribute and be the part of this effort. No act of kindness, no matter how small, is ever wasted.
Click here to Donate Now