Recent content by world33

Thank you for all your help and useful input. To answer some questions: I tried to import the table not to create a linked table or through VBA. I used the standard Import Wizard with both a csv file and and an excel. For what is worth I managed to create a new access table with only the...

Ok thanks a lot. I appreciate your feedback

Hello, Can anyone please help me identify what is the issue I have been facing for a couple of days now while trying to import a text file (named Update), or the same text file converted into an excel file, into an Access new table? With the csv text file I get the following error message...

Hello, I am not sure if I can express this properly but I need to transpose and aggregate multiple field values (University programs) into 1 single cell for each University (UNITID) so that it lists all the programs offered by the University in one cell (with a manual line break Char(10)...

Thanks. How Do I combine them to generate random text?

Hello, Is there any module, function, expression or other way to mimic an Excel RANDBETWEEN function in a MS Access calculated query field? I read that it is possible to use Excel functions in Access but my level is too basic to be able to apply that option. I am looking for a query expression...

So is there any modification I can make to keep the same values?

Hi Mark, The UpdateID is a calculated query field using this formula: UpdateID: GenerateUniqueSequence(Rnd([SITES]![ID])*15+15) It is not present in any table so there is no point, correct me if I am wrong, to have UpdateID = Null . It is a complete new query field. The function is in a Module.

Thanks all for the feedback. I use the following string to call the module in the query Universities by Name: UpdateID: GenerateUniqueSequence(Rnd([SITES]![ID])*15+15) I attach 2 screenshots for those that did not understand the issue. I do need unique random strings but I do not need them to...

I have been searching for a VBA module to generate Unique random alphanumeric strings of random length (or length between X and Y number of characters) I found the following one: Source: https://stackoverflow.com/questions/22630264/ms-access-visual-basic-generate-random-string-in-text-field...

Hello, I would like to convert some UNICODE foreign languages special characters into HTML ASCII codes by using a function in an Access query. For example the following field text string Escuela Administración needs to be converted into Escuela Administraci & # 2 4 3 ; n (pls disregard the...

Thanks for the reply. I tried Function Export_to_text_delimited() On Error GoTo Export_to_text_delimited_Err DoCmd.TransferText acExportDelim, "Export Specification", "Table 01", "D:\Table 01.txt", True Export_to_text_delimited_Exit: Exit Function Export_to_text_delimited_Err: MsgBox...

Hello, I have a VBA module that export to CSV text and works perfectly on any table except for those that contain a multivalued field. Function Export_to_text_delimited() On Error GoTo Export_to_text_delimited_Err DoCmd.TransferText acExportDelim, "Export Specification", "Table 01", "D:\Table...

Thanks. Does that allow to export to multiple files? is there an example of code to see? Does that automatically replace the existing text as per point 2) Cheers!

Hi, I cannot find a solution to these two issues. 1) My Table "UNIVERSITIESOtherName" is made of University names in non-english characters: ID UniversityOther 87 "Երևանի ""Հայբուսակ"" Համալասարան" 190 جامعة الخليج العربي 191 الجامعة الخليجیة 192 جامعة البحرين 237 Белорусский государственный...