Search results

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...

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

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...

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...

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...

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.

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...

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

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...

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

I have the problem resolved with a reboot!!

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...

>> 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

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...

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,

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...

Thanks Banana, I'll be investigating this!

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

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...

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...