Search results

Sorry I had brain crosslink...I am converting data and had recordset .update on my mind and .save jumped in there. Not enough sleep last night ;) Thanks Rich that worked perfect. yup yup yup...Update and then requery. Would have been nice to work without the update...but it works and I am...

Rich- Thanks, but same thing. I can see the mainform perform the main form requery, then the subform SUM([ENG hours]) fires. I may be able to make a test db this afternoon or tonight. ---------- subform: Private Sub ENG_hours_AfterUpdate() On Error GoTo Err_HoursUpdate DoCmd.Save...

Sorry, I should clarify a bit further- The main form is college number, lets say 1..3 colleges. The subform displays the credit details of each college with a subtotal for that college. The main form is a total of ALL credits for ALL colleges. As soon as the user changes a value in the subform...

Can you post the timer code or sample of this. I have the SAME issue with a DSUM of a subform/recordset. I want to total ALL records in the underlying subform and AS SOON as a user changes a value on the subform the main form should recalc the total (like a spreadsheet does). Problem is the...

David- I like the idea of the client paying a "finders fee" upfront or perhaps an annual fee/lifetime fee/subscription fee. I disagree with the flat fee concept because projects vary by scope & length. One project could be simple maintenance of an access db, another $5000 small db and yet...

I remember downloading the subs syntax doc from a microsoft site. Maybe msdn? Anyway.. Here is a helpful Microsoft article

If anyone is interested in PDA & Tablet development resources from Microsoft you MUST jump into their ISV Smart Client readiness program. You receive: Software code and developer kits. Access to technical support through newsgroups. DVDs of technical sessions from developer...

IT Authenication. This is a joke. You can make your own business cards at home. Even if you are not an IT consultant or in an IT department, you still have influence on projects which impact IT spending. Tell them that. What else can they ask you for? Taxid? If you are a sole-proprietor you...

GREAT example Pat! I guess I have to join the CT Access users group now. Very useful example. I will do something similar where I run a delete query and then run the append query with the multi-list box selections. This table will then be part of the query which will be used for the mailmerge...

If you are a developer--Sign up for the Microsoft Action Pack for $299 and you get all their server & client products. Look under partners, sales&marketing tools page. I now have two copies of Office2003, one from the MS Action Pack and the other from the Microsoft Office2003 launch.

What about Access 2002. Clearly this is still in the mix, NO? My clients are looking to upgrade from Access 97 to Access 2000. I want to push them to 2002 Since they still run Win 98, WinNT4.0, Win2000. I have to search some threads/boards in two weeks (no time now) on running Access2003 or...

If you are a MS Action Pack subscriber you get Microsoft MapPoint® 2002. I believe there is an SDK or some documentation on integration. THIS may be the best fit! You should be a subscriber! The interface looks nice- Love the Script title! I would love to change my interface colors, but don't...

I am a bit confused due to the amount of detail with no "big picture". Keep it simple and avoid using all those text boxes. Rethink what you want to show. ex: main form shows all instructors and subform changes as user selects instructor on main form. You should tie the main form to a query...

Pat- I have a similar issue. I have to pass the choices made to a COMPLEX query (can't do this dynamic) which will then feed a mailmerge. I have read numerous threads and it does not appear that there is an easy way to pass the selection list to a query. Perhaps a temp table as DCX mentioned in...

ah, so try putting nz([vaantal]) in the subform detail and keep Sum([vaantal]) in the subform footer. Should work fine. -norm.

What is the recordsource (under properties) for the form? A query or a table or nothing? Looks almost like you have an unbound form (no recordsource) and setting it during run time. Also why so many instructor text boxes. Why not make a continuous form and have them displayed that way? -norm.

I TAKE IT BACK. It does not work fine. The Sum([field]) on the subform will update once I leave that row (continuous form). And the dsum (total for all colleges) on the main form still does not update immediately with the AfterUpdate event. Anyone have a suggestion??? Is there a better event to...

How 'bout something like this (see attached DB): Private Sub Prem_Name_AfterUpdate() If IsNull(Me![Contact_Name]) Then Me![Contact_Name] = Me![Prem_Name] End If End Sub -- This assumes you want it to populate the contact fields after entering "something" in the 'prem' fields...

Make sure you put this in the control source of the field. And field is located on the forms footer (for continuous forms)

Where is vaantal field? On the subform or on the main form?