K
Kidaeshus
/* reposted from microsoft.public.access */
I'm trying to bring in an input form that was designed in Access 2000.
The form takes timecard input in hours, workstations and work
operations assigned to jobs.
When the job number is input, DLOOKUP is used to retrieve the textual
name of the job in one read only text box and the 6 character customer
code (think ACCPAC) in another. The work centre and operation IDs
similarly retieve the 'real name' associated with the 3 digit ID code.
Inputing the manhours uses DSUM to retrieves the manhours per day and
per week in respective read only text boxes.
Everything works as it should, but the text box for the customer code
and both manhour totals do not 'repaint'. The underlying information
IS there because if I click on the read only text boxes, the
information appears. I've tried a 'Repaint Object' macro, but I could
only repaint the whole form triggered by 'on Update'.
I see no discernable difference in the properties between these text
boxes and the ones that DO work. This Access 'frontend' worked fine in
Access 2000. If I copy a DLookup statement from one that isn't working
to one that is, it works. Copy that entire text box to another
location and the no-repaint returns.
I suppose I'm looking for a repaint of these text boxes triggered by
an 'On Change' but I'm unsure how to accomplish that. I've tried the
following module as well (id txtCustNo, event OnChange):
Private Sub txtCustNo_Change()
Me.Repaint
End Sub
UPDATE:
I've since noticed that upon loading the form, "Calculating..." is in
the status bar (lower left). If I click to another application window
(e.g. mail or whatever), "Calculating..." changes to "Form View" and
everything displays as it should. Actually USING the form puts
"Calculating..." back into the lower left and no-repaint returns. It's
like it cannot finish loading unless the Access window loses focus.
I've looked and relooked, but I cannot see any part of the programming
or form design 'hanging'. Deleting objects (and retrying) within the
form one-by-one does nothing.
Suggestions welcome.
Environment:
Running Office 2007 under Windows 7 Pro on brand new quad core boxes
with ASUS P5KPL-CM motherboards with integrated video and 4Gbs RAM.
The data tables are evenly divided between local and ODBC links to a
MS SQL database.
I'm trying to bring in an input form that was designed in Access 2000.
The form takes timecard input in hours, workstations and work
operations assigned to jobs.
When the job number is input, DLOOKUP is used to retrieve the textual
name of the job in one read only text box and the 6 character customer
code (think ACCPAC) in another. The work centre and operation IDs
similarly retieve the 'real name' associated with the 3 digit ID code.
Inputing the manhours uses DSUM to retrieves the manhours per day and
per week in respective read only text boxes.
Everything works as it should, but the text box for the customer code
and both manhour totals do not 'repaint'. The underlying information
IS there because if I click on the read only text boxes, the
information appears. I've tried a 'Repaint Object' macro, but I could
only repaint the whole form triggered by 'on Update'.
I see no discernable difference in the properties between these text
boxes and the ones that DO work. This Access 'frontend' worked fine in
Access 2000. If I copy a DLookup statement from one that isn't working
to one that is, it works. Copy that entire text box to another
location and the no-repaint returns.
I suppose I'm looking for a repaint of these text boxes triggered by
an 'On Change' but I'm unsure how to accomplish that. I've tried the
following module as well (id txtCustNo, event OnChange):
Private Sub txtCustNo_Change()
Me.Repaint
End Sub
UPDATE:
I've since noticed that upon loading the form, "Calculating..." is in
the status bar (lower left). If I click to another application window
(e.g. mail or whatever), "Calculating..." changes to "Form View" and
everything displays as it should. Actually USING the form puts
"Calculating..." back into the lower left and no-repaint returns. It's
like it cannot finish loading unless the Access window loses focus.
I've looked and relooked, but I cannot see any part of the programming
or form design 'hanging'. Deleting objects (and retrying) within the
form one-by-one does nothing.
Suggestions welcome.
Environment:
Running Office 2007 under Windows 7 Pro on brand new quad core boxes
with ASUS P5KPL-CM motherboards with integrated video and 4Gbs RAM.
The data tables are evenly divided between local and ODBC links to a
MS SQL database.