Need Help with Acces

Today I found out that my task in acces needs to be fully written in capital letters. (so with shift).
The only way I know is to retype everything with shift, which would take ages.
Does anybody know a command that can put normally written words into WORDS WRITTEN WITH SHIFT LIKE THIS?

Edit: Someone advised me to try: shift + f3....which didn't work.

 

You may try Ucase() function, which makes every letter in a string captial.

 

Export your data to a csv, open the csv in Microsoft Word, select all the text, use the change case command, import everything back into Access.

 

Could you specify what a csv is? I can only export to excel, word, pdf, exe, and so on.
I tried exporting to word, then shift + f3, but I can't import it back since word is not on the import list.

edit: I also tried exporting to excel, but when I pres ctrl a and shift + f3 I get some kind of window where I need to type numbers (so I typed 1 and 131 since those are the first and last files), witouth any change.

Argh...I hate microsoft office...

 

csv=comma separated value. A CSV file is s text file with all fields separated by commas.

OK, do it this way....it might not make immediate sense, but follow these instructions.

Export your table to EXCEL

Save the EXCEL table as a CSV

Open word and choose FILE > OPEN, change the value type to all files (*.*)

Open the csv, select all the text and change the text to all caps.

save the file

go back to access, import txt file, choose the csv file. Import

BE CAREFUL WHEN IMPORTING THAT YOU SELECT YOUR OWN PRIMARY KEY RATHER THAN LETTING ACCESS create a new one,

 

It worked but I have a small problem. When I exported the acces file to excel, a few colums got the words: TRUE or FALSE in them, instead of the original lil square which you needed to click on to confirm. Do you know if I can put the true or false back into a square which is or is not selected? We all need to deliver a uniform acces document to merge it into a database for common use.

 

It sounds like we are dealing with something a little more complicated than a flat database table. It is difficult to say what is happening here without seeing the file.

How large is it? How many fields (columns) need to be entered in all CAPs? How is the data entered?

I need a better understanding of what this is to make a good suggestion

 

Wel there are 130 files (migrating files from 1865) and each file consists of one horizontal line. Each one of those file contains information which is spread out over several (vertical) colums, like the date of birth, the place of birth, and so on. There are 68 of such fields/colums.
A few of those fields, ask to click on the square if (for example): there is an external word file which contains extra information, or if its a standard file, or if one of the parrents passed away.
Its those fields which ask to click on a square (to confirm whatever statement) that turned into 'true' or 'false' when exported to exel, and remained in this form when imported back to acces.

 

I'm not following you....I think your terminology may be wrong.

Do you mean records where you say files?

How many fields (I think you mean this instead of columns) need to be changed?

A picture is worth a thousand words.

You can, for example, select the entire "column" of fields by clicking the field (column) header, copy them (CTRL-C), then paste (CTRL-V) it into MS Word, change the case, then copy and paste just those fields back to leave the non text fields untouched---just be careful because when you choose the entire field (column) you will get the field (column) header. So when you copy from WORD to go back to access, you should omit the field (column) headers or every record will be off by one.

 

Ok I think I got it, all I need to do is select a field/column, copy it to word, press shift + f3, delete the upper 2 bars (with the field name), go back to acces, completely remove the field, insert a new one, and paste from word back into the new empty field, and rename the field into its original name. If I do this field by field I can avoid the 'squars' turning into 'true' or 'false' words.

edit: Thx for all your help, i'm sure this knowledge will help other of my fellow students aswell.

 

You can actually just paste over those fields (save a step), but yes.

Still not entirerly sure how your data is getting put into the database--should probably make a data entry form that requires data be input as capitals only.

Also, your database sounds criminally designed....if it is a flat table only, there is no reason to work in access to begin with.

But, that's a topic for another time....

 

Yea I see no reason why we use acces anyway, but hey...maybe its just to see how we handle a more complicated database when working with 19th century migration files.