Editing in an MSFlexGrid

[SteveO]

I'm trying to edit the cells in an MSFlexGrid on a form using the common
technique of hovering a textbox (and a listbox) over the cell. This works
in VB6.

It does not seem to work in Access 2000. The listbox works, but the textbox
does not. The problem is that I can't move the textbox on top of the grid.
In design view Format/Move to Front works, but when I load the form the
textbox gets pushed to the back. There is no ZOrder method for a textbox in
Access VBA. There is in Excel VBA, there is in VB6, etc. Is there some
setting in Access I need to look at?

Thanks,

Steve O

 

[Albert D. Kallal]

Any reasons why you don't use a continues form?

If you take a look at the following screen, on the left side is a listbox
(multi column), on the right side is a continues form. I used a continues
form since I wanted a "check box" to be shown.

http://www.attcanada.net/~kallal.msn/test/gs1.gif

Further, on the right side the data is editable.

With a continues form, you can build a editable grid with no code!.

Futher, you can do things like repeating controls!

If you take a look at the following screen shots, you can again see the use
of continues forms, and note how the "buttion" to edit details repeats.

http://www.attcanada.net/~kallal.msn/Search/index.html

I would consider using a continues form. There is certainly some
limitations, but the code/time saving is very large if it can do your task.

 

[SteveO]

Sounds good, but what is a continues form? I don't see anything under the
help for Access 2000 or the MSDN web page.

Steve O

 

[Albert D. Kallal]

All forms in ms-access have 3 settings:

datasheet view, form view, and continues view.

So, while in design view, look at the forms property sheet "format" tab.

You want to set the "default view" setting.

From msdn search, I typed in: Continuous form access

And got a bunch of hits:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac10/htm
l/acprodefaultview.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac10/htm
l/acproviewsallowed.asp

 

[Hugh O'Neill]

Sounds good, but what is a continues form? I don't see anything
under the help for Access 2000 or the MSDN web page.

Steve O

Try searching for 'continuous' not 'continues'.

hth

Hugh

 

[Steve]

Ok, I've been playing with this for awhile and not making any progress.

I have 2 tables. The first is tblName. Primary key is NameID,
autonumber (long int). It has fields of FirstName, LastName, MI, and
CommonName.

The second table is tblAddress. Primary key is AddressID, autonumber
(long int) with fields of NameID (long int), street, city, state, etc.

I've set up a relationship between the two tables on NameID

I've created a form with a 2 column combo box. The combo box is filled
with the following SQL:
SELECT NameID, LastName & ", " & FirstName & " (" & CommonName & ")
FROM Name

This works fine.

I created a sub form using the Address table.

When I add the subform to the main form the wizard never gives me the
option to set the relationship.

If I add NameID as the Link Child Field (on the subform)
and Form_Form1!NameID as the Link Master Field
nothing happens when I select different names from my combo box.

Why doesn't Access recognize the relationship between the tables?
Or
How can I sync the combo box to the subform?

Thanks,

Steve O

BTW, Albert, I was in your neck of the woods in September. I was in
Calgary for two weeks on business. A very beautiful place.

I'm going to Montreal for 3 days starting tomorrow. (I live in Indiana,
USA).