Search results

I have been doing some consulting for a NJ (USA) firm on a fairly complex database that was originally developed by the firm in Access 2003. They outsourced a carefully spec'd upgrade to an off-shore developer, and about a month ago I got to start picking up the pieces from that debacle. Our...

You need to make the calculation from the subform's recordsource, I think. Assuming the recordsource is a table - tblSubRecs - I'd write something like Me.avg = DSum("total","tblSubRecs")/DCount("total","tblSubRecs") If the subform's recordsource has lots of records you could see performance...

DebSabre, I can't send you the database(s) on which I implemented multiple-user logins, because the non-profit I did them for sells them. The user guide for one of them is at http://www.nchica.org/HIPAAResources/EV/HEVs2UserGuide.pdf I'm not sure I can easily extract just the login piece of...

When you have Access help you put a Memo field on a form, say by drag 'n' drop from the field list, it defaults the "Enter Key Behavior" to "New Line in Field". This lets one put newlines into the memo field with the Enter key, but to leave the field, a Tab is used. (To insert a Tab in the...

Yes - should have been more specific - you would need to use the PrintOut in the report's Open event procedure - and after invoking the PrintOut, just close the report.

You might want to consider the SageKey installers for Access Runtime: http://www.sagekey.com/. Their web site explains the many pitfalls of the MS Access Developer Edition installer. I've used the SageKey product on a half dozen Access distributions and have never had a complaint. Jim

When the flag is flown upside down, it's a sign of distress.

Online Help Documentation for the OpenReport Action (macro) says My guess is you might have to open the report in Preview mode first, then maybe use the PrintOut command to control which printer is used. I've never used PrintOut, so you'll have to check it out yourself.

I agree that it's the Outlook Security Patch putting out these messages. I have found the following article extremely useful for my sites afflicted with this Micro$oft abomination: http://www.inquiry.com/techtips/exo_pro/10min/10min1200/10min1200.asp Jim

You might have a look at http://www.experts-exchange.com/Databases/MS_Access/Q_10024700.html I have used the sample code there to to a mail merge, and it works as advertised. The user interface needs to be tweaked, but if you look on MSDN for documentation on the Work application, you can do...

For the null values, instead of using, say [Finish Actual] in an expression, use Nz([Finish Actual],0). (Look at the VB help for the Nz function.) For the conditionals, check the Iif function.

Thank you for the idea. This did open the link correctly. However, it opened the link in MSIE rather than my default browser (Mozilla). I am trying to accommodate (pander to?) those who are unenthusiastic about MSIE (like me).

I have an Access app that is distributed with an HTML file. The HTML file contains references to US gov't regulations for the privacy and security of medical records (HIPAA), including definitions of terms. The Access app contains a number of command buttons for the purpose of looking up the...

Hi Sara, Well, some progress is good, I guess. Another thing to try is to place a "workgroup information file" on the server with the database. This is a small database named SYSTEM.MDW, and it's located (on my machine) in C:\Program Files\Common Files\System\. My SYSTEM.MDW hadn't been...

Try enclosing each file name in double-quotes as you build the list.

Q4: In its simplest form, you could have a text box, call it txtLookFor. In its AfterUpdate event, say something like Me.Filter = "SrchField Like *" & me.txtLookFor & "*" Me.FilterOn = True This would filter your recordsource so that it shows only records where the field SrchField has the...

I think the SubAddress field will get tacked onto the Hyperlink, separated by a "#". So the web page you're hyperlinking to could parse its location with a bit of JavaScript and redirect to the linked document (for example). Anyway, that'd be a way to get the identity of the document to...

Sara, My guess is that the database you're accessing (pun not intended) from the web page is getting itself into a "can't access me" state, perhaps because you are editing something in it from Access. I had a similar problem long ago, and the solution (for me) was to split the database...

Instead of including the LinkCriterion on the OpenForm call, maybe you should refresh the popup's Filter in the popup's OnOpen and OnGotFocus events, e.g., Me.Filter = Forms.frmCallerOfMe.txtID Me.FilterOn = True If the popup is supposed to hang out somewhere on the screen while the user fools...

A little more information might be helpful. For example, how are you opening the hyperlink? Are you using the FollowHyperlink method? Or are you doing something when the user clicks on the document name? You might try overlaying the document name with a transparent Command Button with a...