Suggestions/thoughts on this form layout

[Ambyr via AccessMonster.com]

I'm kind of stuck on the best layout for a form. It started as one table, one
form. This form had TraderName, DateOfTrade, Item1, Item2, Item3, Item4,
Item5, Return1, Return2, Return3, Return4, Return5, Completed, Rated, Cost,
and Profit/Loss. Each of the Items and Returns have 1 picture and a link
associated with it.

Realizing that most trades are not for 5 items, most were less, and some were
quite a bit more, I broke this into 4 tables; Traders, Trades, Items, and
Returns. Trades has everything on it that didn't fall into the logical
categories of the other 3 tables.

Having said that, I am having such a hard time setting this up to look right.
I can't use a datasheet, because the pictures must be on the main trade form.
I tried doing it as a main form, and having Items and Returns as Multi-Item
subforms, but can't get rid of the header without destroying the layout of
the columns.

Any thoughts or suggestions on this? I've been stuck for 3 days now
deliberating this. Your comments are greatly appreciated!

 

[Peter Hibbs]

A Flex Grid Control will probably do what you want but you will need
to write a bit of VBA code, have a look at my Flex Grid Demo program
for some examples.

Go to http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=180

HTH

Peter Hibbs.

 

[Rockn]

The demo doesn't work. When you run the app it errors because it cannot find
"flxgrd32.ocx" which is not even supplied as part of the archive.

 

[Peter Hibbs]

Rockn,

It is supplied in the download, it is called Msflxgrd.ocx and should
be copied to the C:\WINDOWS\System32 folder. The documentation
describes how to register it.

Peter Hibbs.

 

[Rockn]

Nope, that is the file that I copied into the system32 directory and
registered it. The app is still looking for flxgrd32.ocx. We are running
Windows XP and Office 2003 Pro SP3

Wish I could do a screenshot in here. To quote the error message exactly:

"Cannot find the FlxGrd32.ocx file in your C:\Windows\system32 folder."

 

[Peter Hibbs]

Rockn,

OK, I see the problem (sort of).

The error message you are seeing is mine and I used the wrong filename
although it IS checking for the correct filename, it should say
"Cannot find the MSFlxGrd.ocx file in your C:\Windows\system32
folder."

What the code does is - when the main Switchboard form is opened it
checks if that file exists in the System32 folder and if it cannot
find the file it throws up the error message. So, for some reason, the
program cannot find the MSFLXGRD.OCX file in that folder.

What I suggest you do is this - open the Flex Grid Demo program with
the SHIFT key held down which will bypass the Switchboard form code.
Then open the Switchboard form in Design mode and look at the code. In
the Open event of the form there are a few lines of code which start
with :-

vPath = fReturnSysDir

This function (from Dev Ashish) is used to determine the pathname to
your System32 directory, maybe it is returning the wrong path or maybe
you have some unusual set up in your WINDOWS directory. You could just
Rem out those lines of code to see if it works OK then.

Also, with the VBA code window open, you could check the References
(on the Tools menu) to check that it shows up there OK. My reference
looks like this :-

Microsoft FlexGrid Control 6.0 (SP3)

You could use the Browse button to reset the path to the control if
necessary. Hope this helps, let us know how you get on in case this
problem crops up again.

Peter Hibbs.