Solved

connect to columns after edit event for inserting records in a different database/table

Posted on 2007-04-10
14
224 Views
Last Modified: 2013-12-25
Hi, I am trying to hook up to a column's afteredit or afterpost event.  The purpose is to trigger a record insertion  in another database/table when the cell's value changes from NULL/BLANK to a datetime value.

have tried connecting to the columns change and updated events, but the code is not run.

0
Comment
Question by:Bianca
  • 7
  • 6
14 Comments
 
LVL 75
ID: 18886200
Should this maybe be in the SQL zone?

mx
0
 
LVL 34

Expert Comment

by:jefftwilley
ID: 18886216
Are you trying this from a form of some kind?

Private Sub MyField_AfterUpdate()
'if myfield isn't null then do your thing
If Nz(myfield, "") <> "" Then
'Do your insert thing here
End If
End Sub
0
 

Author Comment

by:Bianca
ID: 18889625
Sorry, more explanation is needed...
I am trying to connect to an event fired by MSFlexGrid when a certain columns value changes from either NULL or BLANK to any value. I don't care about the value, I just need to trigger a record insertion in another database/table. Business logic is: when a user enters a date in the complete column (msflexgrid) then insert the job into the manufacturing database/table.

0
 

Author Comment

by:Bianca
ID: 18889630
one more thing... this vbscript in an access database.  The grid is on a form.
0
 
LVL 34

Expert Comment

by:jefftwilley
ID: 18889702
Open that form in design view. Select the column, view it's properties....is there not an On_Change, or After_Update event for that column you're referring to?
If not, right click on the flexgrid object itself and select properties, there should be a build event option there also...come back and let us know.
J
0
 

Author Comment

by:Bianca
ID: 18890065
I do not have access to a column object, but the grid has an onUpdated event.  The grid is dynamically populated in the forms open event with sql queries.
0
 
LVL 34

Expert Comment

by:jefftwilley
ID: 18890313
so how about using the Matrix property?

it's used like so

Grid1.TextMatrix(3,3) = "55"

Where 3,3 is the row and column.

you can test values that way and compare on the onUpdate event?

Not sure exactly how you want to approach it.
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:Bianca
ID: 18890393
I am not sure what event to connect to.  the msflexgrid is activex and only has the on updated event.  it passes (code as integer).
I can test for the value with textmatrix, but how will i know it was the column whose value changed?

how about if I just connect to the forms on key up event, make sure I am on the desired column and the columns value is not NULL or blank and do the insert from there?
0
 
LVL 34

Expert Comment

by:jefftwilley
ID: 18890521
I created a small form with this kind of control on it. And there's just not much to it is there. I can set it's recordsource, I can capture when it's updated at the form level.
You think I can talk you out of using this particular control? maybe a subform control would work better? You can load a recordset into it...you have full control over each field...thoughts?
0
 

Author Comment

by:Bianca
ID: 18890593
we are in the process of migrating out of the access table/application. Problem is it is a legacy application and needs this enhancement until it is converted.  I found out the form events do not fire for the grid.  Is this something I cannot achieve with this object?  If so, I will report it and move on to my next task.
thanks
0
 
LVL 34

Expert Comment

by:jefftwilley
ID: 18890850
see if you have this event available with your control

Private Sub ActiveXCtl0_SelChange()
MsgBox "selchange"
End Sub

I'm able to pop the msgbox using that code for my control when I click into a cell....any cell.

Of use to you?
0
 

Author Comment

by:Bianca
ID: 18891100
I don't have that event to connect to... the grid (msflexgrid) only has on updated,enter,exit, got focus and lost focus events.  Besides, that would put me IN the cell, I need to process after cell contents have changed.
This looks like a lost cause to me... will have to wait until we rewrite that section of legacy apps.
What do you think?
0
 
LVL 34

Accepted Solution

by:
jefftwilley earned 500 total points
ID: 18891149
trash it...not worth the time. You still have the data, and there are other ways of presenting it. Just because you can do something...doesn't mean you should.
My .02
J
0
 

Author Comment

by:Bianca
ID: 18891252
thanks for your persistence Jeff...
Awarding on last comment
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now