Search results

  1. W

    Importing a text file or exel file causing errors both in csv and excel formats

    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...
  2. W

    Query that transpose multiple field values into 1 cell and categorize.

    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)...
  3. W

    RANDBETWEEN like function in Access calculated query field

    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...
  4. W

    VBA module to generate Unique random alphanumeric strings of random length

    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...
  5. W

    Convert Unicode characters into HTML Ascii with function in a Query

    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...
  6. W

    "Invalid Argument" error when VBA exporting to text a multivalued field

    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...
  7. W

    How to export multilanguage Unicode records to multiple text files

    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 Белорусский государственный...
  8. W

    automatically export each record to separate text/html files with VBA

    Hi all, I searched but i could not find any code for exporting each record of an access query to a separate text file using a VBA module as suggested in this Microsoft article Outputting one HTML file per record in an Access database at...
  9. W

    Undefined function <name> in expression. (Error 3085)

    Hello, I am a beginner in using modules and functions in Access and I have tried to find a solution for this problem without success. I have tried to use a Percentile Function and call it from a query but I always get this error: Undefined function <name> in expression. (Error 3085) The...
  10. W

    Max function in a calculated query

    Hello, I have a query problem and I have no idea how to solve it. In the query there are 4 fields: 1) ID 2) PageRank 3) PageRankNormalized 4) PageRankValue 1) ID is the Primary Key 2) In the PageRank field there are values from 1 to 10 3) In the PageRankNormalized there is an...
  11. W

    Excel Function PercentageRank in MS Access

    Excel Function PercentRank in MS Access ? 1) How can I use the Excel Function PercentRank in a MS Access module? What code should I use? I have already set the MS Excel functions as an Access object. 2) How can I call that function in a Query field? What code should I use? Please note that I...
Top Bottom