Solved

Arrays

Posted on 1998-09-19
161 Views
I have a form as follows.
The top row headings are periods(9am-10am,10am-11-am ..... upto 4pm-5pm).
in the column headings i have my various activities or meetings should vary.
i want a grid say 9x6 to record whther any cell of this grid ocupied or not. i think arrays will do it, but i cant even start it. I am Using VB5.

thanks
0
Question by:abidsml
• 3

LVL 2

Accepted Solution

wj7ster earned 40 total points
ID: 1435659
You can create a multi-dimensional array variable as follows:

Dim MyMeetings(0 to 8, 0 to 5)     As String

MyMeetings(0,0) = "Some Value"
MyMeetings(0,1) = "Another Value"
' ...etc

I presume the 9x6 array is for 9 hours/day for 6 days.

If you want to refer then to the 10am-11am meeting on the 3rd day, you can use:

Meet\$ = MyMeetings(1,2) ' because the array is 0 indexed, starting from 0 to n-1.

0

Author Comment

ID: 1435660
THANKS,
ACTUALY THE GRID FOR ONE DAY ONLY, HORIZ-HRS, vERT. ACTIVITIES.
hOW CAN I SAVE THE CONTENTS TO A FILE AND RETRIEVE THEM FOR A PARTICULAR DATE SERCH.
0

Author Comment

ID: 1435661
hi, i wish u can guide me to complete this in simple steps
0

Author Comment

ID: 1435662
hi, please send me your email, i will email you exactly what i want. my email is sml41@hotmail.com
0

Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…