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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 | |
|
|