Page 1 of 2 12 LastLast
Results 1 to 15 of 16

Can't import frx file.

  1. #1
    JRodko is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    80

    Can't import frx file.


    I have a macro that I can't seem to bring into Access, though I suspect it's more of a generic error I'm still hoping someone can assist.

    When I try to import an frx file I get the error is simply that it "Could not be loaded" and nothing else.

    Log files shows this

    Line 2: Class {C62A69F0-16DC-11CE-9E98-00AA00574A4F} of control OrientedDiskPlot_Ver4 was not a loaded control class.
    Line 0: The file C:...\OrientedDiskPlot_Ver4.frm could not be loaded.

    Any help would be appreciated.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,016
    Can you tell us more about frx file -- the who, what, where, how sort of stuff?

  3. #3
    JRodko is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    80
    Should I be able to view the contents in notepad? Because when I try to view the text it's totally scrambled.

  4. #4
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    6,029
    I think the file in question is for VB not VBA. Seems it's like .dll files that store multiple icons that can only be retrieved via code or an application interface.
    - "doesn't work" is no help. Post err msgs and where.
    - Use code tags for code/sql. Implement changes in copies of your database.
    Sometimes I talk to myself - like when I need expert advice.

  5. #5
    JRodko is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    80
    Micron,

    This is a VB3.0 program. Thank you for pointing out the difference! That is new to me.

    Is it possible my issue is most V3.0 programs cannot run on 64 bit windows? I have no idea how to fix that. VB3.0 can't even import the frx.

    Cheers

  6. #6
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    3,566
    VB 3.0 was released in 1993 for use on Windows 3.1 https://winworldpc.com/product/microsoft-visual-bas/30.
    Is my memory correct in thinking Win 3.1 was 16-bit?
    There is I would suggest ZERO chance of it running in 64-bit Windows. It may not even run in 32-bit

    Its so long since I've used VB, I can't remember what the frx file does
    According to this: https://whatis.techtarget.com/filefo...e-Visual-Basic it was also a FoxPro report file

    If is really that important to you, suggest you download a powerful text editor like Notepad++ and try and view it in that.
    If you succeed, try and save as a standard text file .txt
    Then try and import that into Access if the format is structured in a way that looks viable.
    However I very much doubt it will work

    If that fails, consider installing a 32-bit virtual machine running Win 3.1 and an old version of VB!
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  7. #7
    JRodko is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    80
    Thanks isladogs. I just tried to open it in notepad++ with the VB language selected. This is what comes up. I can't make sense of it.

    LB  и€€€| ƒ# –ѕа°±б >  ю€      ю€€€  €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€nal Inc.n X  5  €•  Tahoma1  ,  €  €Viewž {  u  €•  Tahoma1 €€€€€€€€€€€€€€€€€€€€€€€€€€€€ ‘ ( е € 4   cboWorkspaceO " ( х  € 2 H   Label12 І { $ е  € 4   cboTableO D ( х  € 2 D   Label13eІ Э , е  € 4   cboFldLocationr:O g ( х  € 2 P   Label14eІ ј
    , е
    € 4   cboFldAzimuthnr:O ‰ ( х  €
    2 P   Label15eІ в ( е € 4  cboFldDipmutO Ђ ( х  € 2 L
     Label16eІ  ( х  €
    2 p  Label17eІ ' , е  € <  txtNumberOfSide:O ќ ( х  € 2 h
     Label18eІ I ( е € <   txtRadiusOfSO р ( х  € 2 d   Label20eІ k $ ’  € #    Frame10eO ! $ е  €^ 8   cmdOK10e Њ5 ( е €_ H  €dlgDialogOfSƒ в , х €` 2 ,   lblStatusOfSO Њ5 ( е €b <   cmdCancelOfSu Њ5 , х €c 2 \   lblCopyright‘ і: $ е  €d 8   cmdVieweu
    9   у € €€€€€€€€€€€€€€€€€€€€€€€€€€€€€ ю€
    €€€€рi*∆№ќž˜ ™ WJO Microsoft Forms 2.0 Form  Embedded Object
    Forms.Form.1 ф9≤q €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€€€€€€€€€€€€€€€ ( H  d @ €€ " } ®# \< Rг ‘ПќЭг ™ KЄQ Р H Tahoma < k 3 Џ©VРЅ‘•€ …„зѕсдРЅ‘•€ …„зќсдРЅ‘•€ …„з ь — ( х  € 2 x  Label11 ‘ X ( F €Specify the following to calculate the coordinates of a given surface: Ї" І  5  €•  Tahoma  @€ ° 4  5  €•  Tahoma ( (  €1 - Select a workspace: Ґ І  5  €•  Tahoma  @€ ° 4  5  €•  Tahoma $ (  €2 - Select a table:aҐ І  5  €•  Tahoma  @€ ° 4  5  €•  Tahoma 0 (  €3 - Select the Location field Ґ І  5  €•  Tahoma  @€ ° 4  5  €•  Tahoma 0 (  €4 - Select the Azimuth field: Ґ І  5  €•  Tahoma  @€ ° 4  5  €•  Tahoma , (  €5 - Select the Dip field: Ґ І  5  €•  Tahoma P ( ? €6 - Enter the number of side of the surface you want to create: ? І  5  €•  Tahoma  @€ H€, €° 4 4 r  5  €•  Tahoma H ( 7 €7 - Enter the radius of the surface you want to create: I І  5  €•  Tahoma  @€ H€, €° 4 10ho  5  €•  Tahoma D ( 1 €8 - Please select the option you want to perform:reaI І  5  €•  Tahoma R o o t E n t r y   €€€€€€€€ рi*∆№ќž˜ ™ WJO 0к©÷щыћ  f  €€€€€€€€€€€€ £ o    €€€€  $ i 1 8  €€€€  n`фќ›Ќ ™ `Ž рM©÷щыћ u©÷щыћ   ю€€€
    €€€€ э€€€ю€€€ю€€€ €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€f   €€€€€€€€€€€€  u o    €€€€  X  C o m p O b j   €€€€€€€€€€€€  p  C o m p O b j   €€€€€€€€€€€€ : n   *     

            $  ю€€€     ю€€€ ! " # ю€€€% & ' ( ) ю€€€+ , - . / 0 1 2 3 4 5 6 7 8 9 ю€€€; ю€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€ €€€€€€€€€€€€€€€€€€€€€€€€€€? І  5  €•  Tahoma  @€ H€, €° 4 4 r  5  €•  Tahoma H ( 7 €7 - Enter the radius of the surface you want to create: I І  5  €•  Tahoma  @€ H€, €° 4 10ho  5  €•  Tahoma D ( 1 €8 - Please select the option you want to perform:reaI І  5  €•  Tahoma  ,  €  €OKbež  ю€
    €€€€ n`фќ›Ќ ™ `Ž Microsoft Forms 2.0 Frame  Embedded Object  Forms.Frame.1 ф9≤q 4 Fј€  € €  € €S 4 1 r All records  5  €•  Tahoma 8 Fј€  € €  € €S 4 0 r Specific record:  5  €•  Tahoma  (  €Field to filter:q ®  5  €•  Tahoma  @€ ] 4  5  €•  Tahoma  `#€   ќ ”  5  €•  Tahoma L H  ] ј   €€€ } ƒ ў Select records to process Rг ‘ПќЭг ™ KЄQ Р H Tahoma м …l , е
    €Y T  optAllRecords І ‘ 0 е  €Z X   optSpecificRecord l І O ( х  €[ 2 @   Label21 O   ( е €\ 4   cboFldFilterј
      ( е
    €] 8   lstRecordserO E   у € {  u  €•  Tahoma1 “≤ H   тWG _ e x t e n t x O  
    тWGа€€€_ e x t e n t y O  в {  5  €•  Tahoma1  ,  €  €Cancel1 ž {  u  €•  Tahoma1 < <  €$ €  © Gemcom Software Internatio

  8. #8
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    3,566
    I can read things within that like cbo (combo), label, opt (option group) and other form components/font info etc.
    The rest is 'padding' needed for that file format to work in its original environment

    You would see similar info if you looked at an ACCDB/MDB file in Notepad
    There is also reference to Microsoft Forms 2.0 Frame which is an ActiveX form control you can use in Access
    Have you tried converting the encoding type from ANSI to Unicode or UTF-8?
    There may be a REMOTE chance of importing this into Access as text in order to convert to an Access form but I don't have the knowledge to tell you how to do so. Someone else may know more than I do

    For info I managed to copy what you posted, save it as a text file and import it into Access as a table (with errors) - see attached
    Whether that will help you at all is another matter
    What does it contain that is so important some 20 years on?
    Attached Files Attached Files
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  9. #9
    JRodko is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    80
    Hi Isladogs,

    Sorry I have no replied. I am pretty stonewalled with this and have been trying to find time to come back to work on it.

    I have spent about 30 minutes trying to decipher it in Notepad ++ several different ways with no luck. Thank you for the info on the 'padding'. That makes sense to me.

    It works with an access database and modelling software to generate something called a 'diskplot' which would be quite boring for you if I were to explain it.

    I will be sure to update this thread if I find a solution, but I fear the age of VB3.0 means I will be SOL. The strange thing is that it occasionally runs on an earlier version of the modelling program (that runs on an Access DB) however there is nothing to suggest that the issue is with the program since I can't even import it to VB.

  10. #10
    Gicu's Avatar
    Gicu is offline Expert
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    850

  11. #11
    JRodko is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    80
    Thanks Vlad.

    I have been trying to get through these although they're far above my head. I don't even know how to run a program in VB.

    Cheers

  12. #12
    Gicu's Avatar
    Gicu is offline Expert
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    850
    It is a VB form, you will need to re-create it in Access. To open it in VB you can try any (older) versions of Visual Studio.

  13. #13
    JRodko is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    80
    I have downloaded VB 2008 (it's supposed to work with my original frx file but does not).

    When I open the provided string editor project, cls, and form, they just open in different tabs and I have no idea how to actually run it. Completely a fish out of water with this stuff.

  14. #14
    JRodko is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Oct 2018
    Posts
    80
    I have found this thread which looks like it has code that's ready to go?

    https://forum.powerbasic.com/forum/u...resource-files

    What do I import this into and how do I actually run it. Should it appear as an application when complete?

  15. #15
    Gicu's Avatar
    Gicu is offline Expert
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    850
    It looks like is a script in powerbasic, not familiar with that. I think you best bet is still VB 2008. Did you get any errors?
    http://www.profsr.com/vbnet/vbn1.html

    Is that project something that you can upload here to see if anyone can help you?

    Cheers,
    Vlad

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 11-21-2018, 05:53 AM
  2. Replies: 34
    Last Post: 08-09-2017, 09:57 AM
  3. Replies: 2
    Last Post: 02-28-2017, 01:34 AM
  4. File Selector And Import Selected File
    By jo15765 in forum Programming
    Replies: 7
    Last Post: 12-15-2016, 12:28 PM
  5. Import Excel file based on a date and time in file name
    By nhylan in forum Import/Export Data
    Replies: 4
    Last Post: 04-16-2013, 03:26 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums