Microsoft Access

Re: Saving a field back to a data a source(Access)

m181354 — Thu, 27 Sep 2007 18:18:05 GMT

Was having the Data Source and manifest helpful to solve the problem?

Re: Saving a field back to a data a source(Access)

m181354 — Wed, 26 Sep 2007 19:40:20 GMT

The manifest is attached.

Re: Saving a field back to a data a source(Access)

m181354 — Wed, 26 Sep 2007 19:39:35 GMT

I have included my Manifest and 4 shots of my Data Source. Thanks again for all of your help! I am trying to get go into producrion asap and this is the last thing to get working.

Re: Saving a field back to a data a source(Access)

Clay Fox — Wed, 26 Sep 2007 19:09:43 GMT

Under the options Tab when replying you can attach your XSN or any other files. Sample to look at might help.

Re: Saving a field back to a data a source(Access)

m181354 — Wed, 26 Sep 2007 18:59:57 GMT

Could I email someone what my data sources look right so I can get the right syntax? The row number is stored in @AUTONUMBER, DetailId or DetailId2.

Re: Saving a field back to a data a source(Access)

m181354 — Wed, 26 Sep 2007 18:51:09 GMT

Apparently until I get the syntax right it will not work...but I have tried a dozen different ways. Is there a way I can get someone to help me get the syntax right? The field with the row number in it shows up on he form correcly...I hope it is getting passed the way I think it is.

<xsf:calculatedField target="/dfs:myFields/dfs:dataFields/d:LaborSummary/@NOW_ETC_HRS" expression="../../../my:FormData/my:NOW_ETC_HRS_USER_INPUT_TOTAL[../my:DetailId2 = ../../dfs:dataFields/d:LaborSummary/@AUTONUMBER]" refresh="onChange"></xsf:calculatedField>

Re: Saving a field back to a data a source(Access)

m181354 — Wed, 26 Sep 2007 16:34:41 GMT

When I add /dfs:myFields/my:DetailID as the filter my default value is removed on the NOW_ETC_HRS field. I have it getting its value from the NOW_ETC_HRS_USER_INPUT_TOTAL field.

My DetailID value is correct.

I think /dfs:myFields/my:DetailID is the right syntax but I do not know why the default value is removed from my NOW_ETC_HRS field after I make the change to the manifest file.

Re: Saving a field back to a data a source(Access)

Clay Fox — Wed, 26 Sep 2007 16:12:46 GMT

Ok.

1 thing would be to double check detailID is 2 or has the proper value. I am assuming so but always a good thing to check when debugging.

I think what you need is the full name for the DetailID field. the ../../ is relative to the positino and for the filter you may need /dfs:myFields/my:DetailID although I think you may have one more group inbetween but try putting in the full path on the target filter.

Re: Saving a field back to a data a source(Access)

m181354 — Wed, 26 Sep 2007 15:55:36 GMT

I am trying to get a Total Line (NOW_ETC_HRS_USER_INPUT_TOTAL) from a Repeating table and update one row (NOW_ETC_HRS) that has Summary information for the same Control Account record on an Access database table.

Below is the line that updates the NOW_ETC_HRS field but also updates every row in the table...

<xsf:calculatedField target="/dfs:myFields/dfs:dataFields/d:LaborSummary/@NOW_ETC_HRS" expression="../../../my:FormData/my:NOW_ETC_HRS_USER_INPUT_TOTAL[../../my:DetailId = ../../dfs:dataFields/d:LaborSummary/@AUTONUMBER]" refresh="onChange"></xsf:calculatedField>

I have tried the following filters...

../../my:DetailId - used to store the AUTONUMBER from the row to switch views.

Looks like this - "/dfs:myFields/dfs:dataFields/d:LaborSummary[../../my:DetailId]/@NOW_ETC_HRS"

../../dfs:dataFields/d:LaborSummary/@AUTONUMBER - contains the row number.

Looks like this - "/dfs:myFields/dfs:dataFields/d:LaborSummary[../../dfs:dataFields/d:LaborSummary/@AUTONUMBER]/@NOW_ETC_HRS"

In my test, I am trying to update row number 2 which works when I hard code the number but I will need to update any number of rows in production

Re: Saving a field back to a data a source(Access)

Clay Fox — Wed, 26 Sep 2007 14:55:44 GMT

Can you post the text for the one that worked but set all rows to the same total?

In the lst filter line it would need the ../../ before my:FormData probably.

I am still confused on what exactly you are trying to do. Maybe you could give some more high level details.

The user gives some input, selects a row of information or something, and then you are trying to set a total and update that same record correct?

Re: Saving a field back to a data a source(Access)

m181354 — Wed, 26 Sep 2007 13:59:59 GMT

I already added the filter and tried to copy it but I still must be missing something or have the wrong syntax. The filter value comes from a data source so I used the following as the filters...

../../dfs:dataFields/d:LaborSummary/[@AUTONUMBER]

my:DetailId - I set this value to @AUONUMBER when I switch views. When I use this it deletes my reference to the NOW_ETC_HRS_USER_INPUT_TOTAL value and does not update.

Here is the entire line...

<xsf:calculatedField target="/dfs:myFields/dfs:dataFields/d:LaborSummary[../../dfs:dataFields/d:LaborSummary/@AUTONUMBER]/@NOW_ETC_HRS" expression="../../../my:FormData/my:NOW_ETC_HRS_USER_INPUT_TOTAL[../../my:DetailId = ../../dfs:dataFields/d:LaborSummary/@AUTONUMBER]" refresh="onChange"></xsf:calculatedField>

Here is the filter line in the form...

my:FormData/my:NOW_ETC_HRS_USER_INPUT_TOTAL[../../my:DetailId = ../../dfs:dataFields/d:LaborSummary/[@AUTONUMBER]"

Re: Saving a field back to a data a source(Access)

Clay Fox — Wed, 26 Sep 2007 13:17:04 GMT

Ok, well at least you are making progress.

The key is the filter value for the target (1st occurenc) not what it is set to (2nd). I am guessing it is not always row 2 that you wish to update.

The second issue is that you need to use the complete field reference. It cannot interpret @AutoNumber and therefore the filter is unsuccessful. It should at least be my:FormData/@AUTONUMBER or something but you would need to check.

What I would recommend is to go into designer and set it up there first. Modify the rule to set @NOW_ETC_HOURS to NOW_ETC_HRS_USER_INPUT_TOTAL and then use the filter button to add the filter RecordID = @AUTONUMBER. Then you can go in and copy this filter to where your first 2 is. I would think you do not really need a filter on your value that you are setting but you I think had this working before. This at least will give you the proper syntax for the filter.

Good Luck

Re: Saving a field back to a data a source(Access)

m181354 — Wed, 26 Sep 2007 12:25:18 GMT

When I supply the row number directly it works great! But when I pass it a filter value it does not. I must have the wrong syntax. I will show you both ways I am trying it.

This works...

<xsf:calculatedField target="/dfs:myFields/dfs:dataFields/d:LaborSummary[2]/@NOW_ETC_HRS" expression="../../../my:FormData/my:NOW_ETC_HRS_USER_INPUT_TOTAL[../../my:DetailId = ../../dfs:dataFields/d:LaborSummary/[2]" refresh="onChange"></xsf:calculatedField>

This does not. @AUTONUMBER is the filtervalue. It is the key on the Access database.

DO YOU KNOW THE RIGHT SYNTAX TO PASS A FILTER VALUE?

Re: Saving a field back to a data a source(Access)

Clay Fox — Tue, 25 Sep 2007 16:54:21 GMT

Have you tried it yet?

I would think your filter would go at the /d:LaborSummary[RecordID = Field]/@NOW_ETC_HRS. I would be calculating the rowID that needs to be updated. Place that in a field or put the calculation in the filter are there.

Typically you will have to test a bit till you get it the way you need it.

Re: Saving a field back to a data a source(Access)

m181354 — Tue, 25 Sep 2007 16:48:03 GMT

Could someone help with how I would make the code below work with saving a field back to a data source without saving it to all the records?

Looks like this is the line I need to change...

<xsf:calculatedField target="/dfs:myFields/dfs:dataFields/d:LaborSummary/@NOW_ETC_HRS" expression="../../../my:FormData/my:NOW_ETC_HRS_USER_INPUT_TOTAL[../../my:DetailId = ../../dfs:dataFields/d:LaborSummary/@AUTONUMBER and ../../dfs:dataFields/d:LaborSummary/@DIST_NONDIST = "Non-Dist"]" refresh="onChange"></xsf:calculatedField>

My filters are AUTONUMBER...the key on the access database and the DIST_NONDIST field. I need to filter on the Key field and DIST_NONDIST = Non_Dist.

So I woiuld take the Greg's example code.../Root/Table/Row[FilterField = 'FilterValue']/Field = "value" and update the code above?