M
michaelblaz
I'm currently working on a database for the California National Guard t
help automate some of the reports that our Readiness Officers have t
publish periodically. As it stands I have the required excel forma
tables linked into the database as "link tables". Here's my problem an
the solution I've come up with, however my Macro coding skills ar
nowhere near pro....
In the link table I need to update the field at record 4, column t
with a summed count from a query. I've created a form for the lin
table and subform for the query. My macro in design view is a
follows:
Form-[test]
Subform-[Sum of CountOfsidstrSSN_SM]
GotoRecord
record-Go To
offset-=4
GotoControl
controlname-[f4]
SetValue
Item-[f4]
Expression-[Forms]![test]![persmain Query Query].[Forms]![Sum O
CountOfsidstrSSN_SM]
THE ERROR..
When the code is executed it takes me to the fourth record, field [f4]
however it then halts with the error "The value you entered isn't vali
for this field"
THE WIERD PAR
if I click okay, and then run the macro again... the field updates wit
the information that I need.... but only if I am already on recor
4....
Now I wouldn't mind hitting okay and then updating the field I need i
it weren't for the fact that I have to have this form update over 50 o
so fields in different records and on different lines...
fixing this simple macro problem allows me to cutdown 30+ hours of wor
to just under 2.....
any ideas???? I'm on a strict deadline to get this working, and ever
report that I need to publish is going to have to be done this way.
ps> I'd be happy to provide the testbed file I am working with so tha
you can experience my pain firsthand...
help automate some of the reports that our Readiness Officers have t
publish periodically. As it stands I have the required excel forma
tables linked into the database as "link tables". Here's my problem an
the solution I've come up with, however my Macro coding skills ar
nowhere near pro....
In the link table I need to update the field at record 4, column t
with a summed count from a query. I've created a form for the lin
table and subform for the query. My macro in design view is a
follows:
Form-[test]
Subform-[Sum of CountOfsidstrSSN_SM]
GotoRecord
record-Go To
offset-=4
GotoControl
controlname-[f4]
SetValue
Item-[f4]
Expression-[Forms]![test]![persmain Query Query].[Forms]![Sum O
CountOfsidstrSSN_SM]
THE ERROR..
When the code is executed it takes me to the fourth record, field [f4]
however it then halts with the error "The value you entered isn't vali
for this field"
THE WIERD PAR
if I click okay, and then run the macro again... the field updates wit
the information that I need.... but only if I am already on recor
4....
Now I wouldn't mind hitting okay and then updating the field I need i
it weren't for the fact that I have to have this form update over 50 o
so fields in different records and on different lines...
fixing this simple macro problem allows me to cutdown 30+ hours of wor
to just under 2.....
any ideas???? I'm on a strict deadline to get this working, and ever
report that I need to publish is going to have to be done this way.
ps> I'd be happy to provide the testbed file I am working with so tha
you can experience my pain firsthand...