Search results

Thanks vbaInet, That solves the immediate problem wherein the form no longer errors but now A.GrandTotalTime = 0.00 whereas it should read 3.17 (being the TotalTime of SubformA) + 0.00 (the TotalTime of SubformB). Given that I am using control sources to get the values that I require, and that...

Hi vbaInet, Is this correct (not sure what "true" part or "false" part is meant to be in the builder "IIf (IsError («varname») , «truepart», «falsepart»)"? Setting MainformA.GrandTotalTime control source to =IIf(IsError([SubformA].[Form]![TotalTime]+[SubformB].[Form]![TotalTime]),0) results in...

Greetings Gurus, Perhaps you could help? I have a Main form "A" with subforms "B" & "C". Both B & C contain time fields which are manually entered in hh:MM:ss format and TotalTime fields with a control source set as Sum([Timefield]). Main form A contains a Grand TotalTime field which needs to...

Greetings Gurus, I am having an issue summing/formatting a time value and hope you can help. I have a manually edited field which contains a long-time value xx:xx:xx. I need to calculate the total of all the values in this field but, of course, hit the 23:59 barrier and get rolled over to...

Hi DJKarl, I am trying not to "chain" the sequence if at all possible i.e. run script > create file > read file > upload data. I am trying to keep the sequence as short as possible

Greetings Gurus, May I request your input please? The goal: Display dynamic system information on a form as it opens The problem(s): As above, I am trying to find a way to retrieve CPU usage, available RAM, physical disk activity and logged-on user on a form as it opens. I have tested...

Thanks for the quick reply JANR, Clean, simple, efficient...I like it.

Greetings Gurus, long time no see... I was wondering if the following was even possible because after much googling I can't seem to find an answer. Basically I have a sub-form (lets call it frm2) which looks up and displays fields based on the "ID" field in another subform (called frmIn)...

Hi Spike, Thanks for the answer. I only just got it as I was posting a reply. FYI column0 contains the ID of the name, column1 contains the actual name, so that part was right. The "XXX" (now changed to ZZZ) is used to push the name to the bottom of the list so that I know to ignore those...

Greetings Gurus Some advice or help please... My form has a listbox (list42) which contains names looked up from a table called AllNames. It also has a combobox which contains the possible status of the list42 names. For e.g. "Bob" on list42 can be selected as "absent", "present" etc. I am...

Let the games begin... Using the VB6 code I get no errors when I build the dll, then follow these instructions http://www.ehow.com/how_6250242_create-installer-vb6-program.html, and run the installer. Having tested it now it doesn't work when Outlook receives new mail nor does it launch any...

and here is the VS2005 version pretty much copied and pasted from http://www.vbforums.com/showthread.php?t=406636 Option Explicit On Option Strict Off Imports Extensibility Imports System.Runtime.InteropServices #Region " Read me for Add-in installation and setup information. " ' When run, the...

Hi Darbid, Ok, the story so far... I have found and installed VB6 on one machine and installed Visual Studio on a second machine. Trying to work out what is going on I have attempted to merge the code and/or concepts of your code, this (http://msdn.microsoft.com/en-us/library/Aa140126) and...

Hi Darbid, Now that I have the month-end out of the way I can get back to you. I haven't found a VB6 editor or VS .net2003 and I have tried all the Express editions (2K5, 2K8, 2K10) none of which are any good. I have managed to find Visual Studio 2005 but I will probably only get to playing...

Hi Darbid, nice to "see" you again.... Yes, I've seen those. As well as:- http://www.outlookbanter.com/outlook-vba/7477-vbaproject-otm-not-read-anymore.html http://www.outlookcode.com/article.aspx?ID=36 http://support.microsoft.com/Default.aspx?kbid=290780...

Thanks to the great and wonderful darbid I have a listener in my Access database listening for any incoming Outlook emails. What I had not discovered is that the Outlook code is not very portable though so having unsuccessfully tried several methods of getting the code to run on two other...

Hi, I didn't explain fully. I have 1 exchange server, let's call it "server1". I have 1 database/sql server, let's call it server2. I have 3 workstations that need to be aware of specific incoming mail as well as the day-to-day stuff. I have 3 potential scenarios:- 1. I can install Access &...

I think I understand what you mean. I would like to ask though, should the Outlook that this script is running under be independant of any other incoming mail. For e.g. if we have a customer called Bob and he sends us an email not related to an order, I presume the outlook script will still run...

darbid, if you are ever in London, or if I'm in Munich, I owe you many,many beers...thank you very much for your help and your patience.

Darbid, Thank you, Thank you, Thank you, Thank you, Thank you, Thank you, Thank you, Thank you, Thank you, Thank you, Thank you, Thank you, Thank you, Thank you, Thank you, Thank you.