Search results

Hi Everyone - I am taking over an former employee's database and I noticed he created lots of lookup tables that have only one value listed.... Is it more common to create a lookup table rather than just assign default values to create a small value list in the properties of a control? I...

Thanks Redneckgeek! Your response actually made me think of something else. I created another query off of my data table and was able to use a cross tab query on it to get it in the exact format I want! :)

I have a data table that stores hours worked against each project and a project table that stores billing type(direct, indirect,potential), manager, charge code... I had a query and report that listed total hours and utilization per month but then managers wanted to throw in the composition of...

Hi everybody. I have three queries. Query1 contains employee ID, employee name, hours worked, utilization percentage and project billing type is "direct". (127 records returned) Query2 contains the same information except the project billing type is "indirect". (41 records returned) Query 3...

I'm a happy camper now!! First - thanks to everybody who replied. I learned some new debugging tips and some facts about requery vs refresh! I tried georgedwilkinson's code snippet at that worked like a charm! Thank you! Sometimes I get so focused on doing something one way and then someone...

Doin' the Happy Dance!! Thanks for your input namliam, matt and janz!! From a previous post by georgedwilkinson I was able to find an alternate solution that works just as well.... all my subforms were on a tabbed control. I kept focusing on adding the code to the after update event of a...

For some reason when I cut/paste the code to post it - it always puts that extra space in...

Thanks for your reply namliam. I'm still not having any luck. I've tried the following variations of code in the after update event of the field that should trigger an update to the second subform. The field is on a subform called 'subfrmWBS' and I want it to trigger a refresh of the field...

Hi wiklendt - Well I've tried putting code in the after update event of the form - that didn't work. I also tried putting it in the several other events of the form with no avail. I'm going to have to give up on this for today since it it past 11pm here. I will continue trying tomorrow...

If I have the following code in an After Update Event in a field on a subform... this will refresh the subform with current focus as I expect... Private Sub LaborCategory1_Hrs_AfterUpdate() DoCmd.RunCommand acCmdRefresh End Sub ...but what if I want to do the same thing - refresh a subform...

Thanks for your input... It's the Aussies to the rescue :) I appreciate your ideas. I've tried incorporating your suggestions but still nothing works :( I've tried different variations and I've been searching the forum for the past 2 hour still looking for possible alternative but I'm beginning...

Unhappy. I have been on this same problem for many days now. I'm trying to help myself since I haven't gotten any input from anyone... :( But in trying to help myself find any solution.... I found something but I'm still not satisfied with it. On the tabbed control I ended up adding a Refresh...

Is it possible to have a subform update it's contents based on user changes made to another subform? I've been trying for days to get the control on the subform to update but I can't get it to update correctly. Someone even suggested I may be "pushing the limits" of MS Access by overdesigning my...

Help - if anyone is out there... I was having trouble uploading my sample db since it was over the upload limit - but I have finally gotten my sample db small enough to upload. Based on Ken's reply, he thought I might be overdesigning with 6 subforms on a main form. I've added a tab control...

Okay.. thanks for trying.

Sample DB Here it is with sample data... the main form is frmProposalSetup and when you change an hour value in section C, I was trying to get labor hours in section B to update... Oops - the size exceeds the limit - I'll try to compress it or something..

6 forms pushes the limit? To provide more background info... this is a database for storing contract proposals. There is a proposal table that tracks the basic proposal information such as the customer the proposal is submitted to, proposal title, proposal creation date, etc. This table's...

Close but not there yet Thanks for your replies! I tried putting forms.frmPROPOSALSetup.subfrmPROPOSALSetup.Form.Requery in the After Update event of the SumHrs_LabCat1 field on the second subform but that didn't do anything either. Then I tried putting the same line of code in the After...

I'm kind of confused... can someone help me? I have a main form (frmPROPOSALSetup) with 6 subforms. The first subform (subfrmPROPOSALSetup) contains several fields that contain total labor hours (for each defined labor category). The second subform (subfrmWBS) contains a workbreakdown structure...

Hi - I've been trying a different things recommended on this board, but I'm still running into problems. Can anyone tell me what I'm doing wrong? I have a main form with 2 subforms. My main goal is for Subform A to update with updated information from Subform B. At first, in the Form...