Convert text file frm to a functional form

[shank]

I'm working on another MS Access / Quickbooks process. In the sample files I was given the below code in a text file: ShowItems.frm.


Is there a way to import the below into MS Access and create the form? Or otherwise a way to create the form?

Thanks!

VERSION 5.00
Begin VB.Form ShowItems 
   Caption         =   "Items List"
   ClientHeight    =   4530
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   7065
   LinkTopic       =   "Form1"
   ScaleHeight     =   4530
   ScaleWidth      =   7065
   StartUpPosition =   3  'Windows Default
   Begin VB.CommandButton Done 
      Caption         =   "Done"
      Height          =   375
      Left            =   2880
      TabIndex        =   1
      Top             =   3960
      Width           =   1095
   End
   Begin VB.TextBox ItemsList 
      Height          =   3015
      Left            =   240
      MultiLine       =   -1  'True
      ScrollBars      =   2  'Vertical
      TabIndex        =   0
      Top             =   720
      Width           =   6375
   End
   Begin VB.Label Label1 
      Caption         =   "Query result for the first 30 items in the current company file."
      Height          =   255
      Left            =   240
      TabIndex        =   2
      Top             =   240
      Width           =   5895
   End
End
Attribute VB_Name = "ShowItems"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'----------------------------------------------------------
' ShowItems.frm
'
' This form is simply used to display items which are
' returned from QuickBooks.  All interaction with QB
' takes place in the Main Module.
'
' Last Updated: 08/2002
'
' Copyright © 2002-2013 Intuit Inc. All rights reserved.
' Use is subject to the terms specified at:
'      http://developer.intuit.com/legal/devsite_tos.html
'
'----------------------------------------------------------


Private Sub Done_Click()
    Unload Me
End Sub

[CJ_London]

you can use vba to create forms (but only if your db is .accdb and executed in a full version of access).

see these links
https://docs.microsoft.com/en-us/off...ion.createform
https://docs.microsoft.com/en-us/off....createcontrol

you would need to parse through your text file to determine the various properties

But with just 4 controls, would be quicker just to create it manually

[shank]

What are the 4 controls? Not knowing VB I'm not understanding what should be on the form.

Thanks!

[CJ_London]

controls have properties similar to vb, you'll need to translate them to access. some will have the same name (e.g. width, top, height), some will be equivalent or you'll need to do some vba magic to get the equivalent

without know what the form is supposed to do, difficult to suggest anything else

if you are looking for an easy answer, I don't believe there is one

on closer examination, there may only be 3 controls, a button, a textbox (or perhaps its a list box) and a label. the rest appear to relate to the form

[Missinglinq]

...controls have properties similar to vb, you'll need to translate them to access. some will have the same name (e.g. width, top, height), some will be equivalent...

Also know that while some objects, commands, etc. have the same names...they do not do the same things in both languages!

...if you are looking for an easy answer, I don't believe there is one...

I agree with that...you can't simply import the VB code into Access and create a Form. If you're versed in VB code, you can use that provided code as a guide, but you're really going to have to basically create your Form from scratch.

Linq ;0)>