Search results

  1. Martyh

    Sumif equivalent

    Thanks guys... i need to start thinking in a database way again! (i've been on an excel project for a month) In my case the group by should do the trick!! Thanks again. Do you guys know the answer to my other question? My problem is very similar to Vickiwells(vickiwells Posted:Subforms on...
  2. Martyh

    Sumif equivalent

    Is there a =Sumif (Excel) equivalent in access? for example, could i use dsum()? Your help is needed!
  3. Martyh

    subforms on tab control

    My problem is very similar to Vickiwells. However there is a one to many relationship in within the form ie The "One" side forms the Main part of the form, while the "many" side forms the subforms portion. Because there was too much information to place on the screen, I split the "many" side in...
  4. Martyh

    Most efficient way?

    Hi, I have "concocted" a way to get an XML file exported. See below. However, I am wondering whether this is the most efficient way of doing that. Any advice would be welcome. BTW I'm not quite finished with ObjectExists (qrytoWebTrainingXML must exists)! Private Sub cmdToWeb_Click() Dim...
  5. Martyh

    Change the predefined display of "Medium Date"

    Gee Whiz! You mean you're not Bill Ga.... You sounded so authoritarian with "That's why ..." ! :D Alright, so then my only other choice would be to look-up every "Format" property and change it from Medium date to mmm.dd.yyyy (or what ever). Is there an programmatic method that I could use to...
  6. Martyh

    Change the predefined display of "Medium Date"

    Yes but they allow the short date and the long date formats to change... why not the medium date too. :confused: Thanks for your reply.
  7. Martyh

    Change the predefined display of "Medium Date"

    Is there some way that I can change the way the predefined display of the format of "Medium Date" ? The HELP doesn't HELP. It says: "appropriate for the language version of the host application." but the only reference to language is the Regional and Language Options" in the control panel. And...
  8. Martyh

    "breakpoint" off yet compiled program stops

    Thanks RuralGuy ! Does this work in access 2003 as well? --- I don't see any mention of that! Marty
  9. Martyh

    "breakpoint" off yet compiled program stops

    Is there a way to eliminate the problem of stopping a program from going to the code side of the module and stopping (as if it were in the debugging mode) in the middle of a perfectly good program that has been compiled? THe places where it stops are places where a last set a breakpoint, and...
  10. Martyh

    Unusual problem (at least for me!)

    I have the problem resolved. Thanks for your help Bob! Marty
  11. Martyh

    Unusual problem (at least for me!)

    I have the problem resolved with a reboot!!
  12. Martyh

    Unusual problem (at least for me!)

    This morning I went to the server (Windows 2003 Server) and logged in. The permissions on the server were set to : Full Control - Administrators Special - Create Owners Full Control - M Taitt Full Control - System Full Control - Users The Shareuser tab was set to share the folder. But there...
  13. Martyh

    Unusual problem (at least for me!)

    >> permissions for the folder (on the Server) where the Access database lets everyone who is going to use it, have Add/Edit/Delete permissions. and do you know how to set these permissions? This is Windows server2003. Marty
  14. Martyh

    Unusual problem (at least for me!)

    Hi! I have worked on plenty of Frontend / Backend systems but I have never come across this problem: I use Windows Server 2003 for the backend (first time ) The backend is installed as \\10.0.17.251\OAC\gentleBE.mdb (also a first for me) I can connect my "client" and I do not get any error...
  15. Martyh

    Cross tab.... in a FORM?

    Banana, OK I've investigated... How do I use textboxes instead of checkboxes? I have no experience using "Class Modules" ... perhaps a few words? Thanks,
  16. Martyh

    "read-everything" calendar!

    Hi, I have a form that is designated read only. I've put a calendar on the double-click of a control in that form. When the form is in regular edit mode the calendar works fine, but when the form is in read-only mode then the calendar continues to function (ie you can double click and change...
  17. Martyh

    Cross tab.... in a FORM?

    Thanks Banana, I'll be investigating this!
  18. Martyh

    Parent-Child Form

    Hitech coach and thunder! Thanks for your quick reply! I guess I need a kick in the pants! Of course your solution is right! I was getting an error message that there was no record ... but duh!! Thanks
  19. Martyh

    Parent-Child Form

    Hi! How can you tell (programmatically) if there is value in a Child ? eg Me!sfrmAttachmentDetails.Form!ParticipantID I currently have a form and a sub form in a typical 1 to many relationship. I would like to know how I could determine if there is data entered into the many side of the...
  20. Martyh

    Cross tab.... in a FORM?

    Hi! I have data that I have looks like this: ID CID Phas FYr Contrib Funds_Delivered 1 1 1 2002 10000 0 2 2 1 2002 10000 0 3 3 1 2002 10000 0 ... 25 1 1 2003 15000 -1 26 2 1 2003 12000 0 27 3 1 2003 18000 -1 ... 46 1 1 2004 19000 -1 47 2 1 2004 14000 -1 48 3 1 2004 20000 -1 ... 88 1 2 2005...
Back
Top Bottom