A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

DLookup & DSum repaints



 
 
Thread Tools Display Modes
  #1  
Old November 2nd, 2009, 09:11 PM posted to microsoft.public.access.forms
Kidaeshus
external usenet poster
 
Posts: 4
Default DLookup & DSum repaints

/* 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.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:28 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.