• We need your support!

    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)

Computers & ICT: Post your doubts here!

Messages
124
Reaction score
49
Points
38
i have problem in this question too ....let me knw if you find ne solution to q 16 in m/j 2011
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
 
Messages
124
Reaction score
49
Points
38
how do we change Y and N to yes no format ?
I believe u talking about of june 2011 aswell :p 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.
 

Attachments

  • Captureict.JPG
    Captureict.JPG
    50.1 KB · Views: 10
Messages
183
Reaction score
18
Points
28
I believe u talking about of june 2011 aswell :p 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.
thnks 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?
 
Messages
183
Reaction score
18
Points
28
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
did u finish yours...if you did can you give it to me by email or nething at all ?
 
Messages
124
Reaction score
49
Points
38
thnks 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?
Reallly? :-O cause im not getting any errors
Anyway tell me the steps how u do it then i think i can help you!
 
Messages
183
Reaction score
18
Points
28
Reallly? :-O cause im not getting any errors
Anyway tell me the steps how u do it then i think i can help you!
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 type
 
Messages
183
Reaction score
18
Points
28
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 type
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
 
Messages
124
Reaction score
49
Points
38
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
Instead of doing all that, you can click import and from the drop down choose "text file" and then try doing it again !!
 
Messages
8
Reaction score
4
Points
3
csv files are actually text files, so they are imported as a textfile.
You don't need to convert them.
 
Messages
350
Reaction score
64
Points
38
how do we change Y and N to yes no format ?
I believe u talking about of june 2011 aswell :p 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.

well you can make Yes/No appear in the tables through this way.
Do the step shown in the picture when import the files in access:
Y_N_format.JPG
and then select as shown:
Y_N_format2.JPG
 
Messages
183
Reaction score
18
Points
28
whenever i close my excel all the formulas goes away its not there anymore....wht should i do so that they do not vanish ?
 
Messages
183
Reaction score
18
Points
28
@xenon -did you give your exam .
could you upload your word part from m/j 2011 question 16 ?
 
Messages
350
Reaction score
64
Points
38
whenever i close my excel all the formulas goes away its not there anymore....wht should i do so that they do not vanish ?
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 recently
 
Messages
8
Reaction score
4
Points
3
The files that are given to you are .csv files, and they save values only (hence the name, comma separated VALUES)
It's always recommended to you save your file as excel workbook (Save as --> excel workbook).
 
Top