Search results

Greetings Gurus, I have run out of ideas on how to perform some string manipulations and am hoping you may help. I am trying to extract substrings from a logfile and insert them into my db. Example strings: 12:14:56 - bob - logon - bobspc - 192.168.0.1 - 192.168.0.2 - thisserver - 1,2,3,4,5...

Greetings Gurus, Could you please help? I have some vba running in a ThisOutlookSession.OTMPrivate Sub olInbox_ItemAdd(ByVal Item As Object) On Error GoTo Err_olInbox_ItemAdd Dim appAccess As Object Dim objDBase As Object If Item.Class = 43 Then 'tried Or Item.Class = 45 in case...

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

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

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

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

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

OK, so from my last post (http://www.access-programmers.co.uk/forums/showthread.php?t=197719) I have had no replies and research, 2 weeks worth, has indicated that this is an overly complex way of doing what I would like. So my research as shown that the easiest method would be to simply (?)...

Greetings Gurus I would like to try and get received emails into Access. I think the easiest way to do this would be to install Outlook onto the server running the database but I would like some advice please. What I have is:- - Exchange2003 server (e.g.blue.red.local or http://mail.red.com)...

Greetings Gurus, Access2003 F/E with SQLExpress B/E. I would like to send email to an Exchange mailbox, have that mail forwarded to a SQL table and link that table to an Access F/E. I have seen a few articles on how to do this using SQLMail but I can't see anywhere in SQLExpress that allows...

Greetings Gurus, Before I drive myself nuts trying to find a way to do this I would like to ask if it can be done. Mainform has a combobox - selects CompanyName Subform has records - e.g. company, productcode, productprice, orderdate, supplydate Currently I have a "Notify" button whose...

Greetings Gurus, I'm not quite sure how to put this (or if it is even possible) but I'm sure one of you will be able to tell me. I am entering records through a form (as you would :)), closing the form and the record displays in the table. What I would like to do is be able to modify that...

Hi gurus, I'm a bit stumped on this one. I am trying to add multiple records from 1 form to 1 table. If you open the "Form1" form from the attached test02.mdb you will probably see what I mean. The requirement is to add changed prices to each company on a daily basis. I could do this through...

Hi again... Is it possible to have a cross-tab form? The kind of thing I'm trying to do looks like Company Name A B C D Date 1 1 1 1 Date 2 2 2 2 The concept works fine in a cross-tab query but I can't add information. I have...

Hi All Could anyboby tell me how to disallow edits and still have an OnClick value event... I have a form which has a date field which when "OnClicked" auto-populates with the current date whether intentional or accidental. I have tried disallowing edits in the form properties and this...

Hi all, A bit of help if someone has a moment. If you launch the "Company" form in the attached db (examples are better to work with than explanation) you can see it is 1 form with 2 subforms. If you double-click on one of the names in the Employees subform a pop-up form "NewOrders" is...

Hi all, I know this may be more of a SQL question than an Access question but I was hoping that one of the gurus here may have an answer. Background: SQL 2005 Express with Access 2003 F/E In order to re-develop my Access FE I did a backup of my always-on B/E, installed SQL2005 Exp. on a...

Hi Gurus, Mailman has been helping with this in the vb forum but I decided to move it here because I don't think this is a vb problem. Looking at the attached example I am trying to get the employee combobox (combo2) to show only those employees who work at the company selected in the listbox...

Greetings Gurus I need a little help with a listbox/lookup problem please. The listbox contains a list of company names which, when a company name is clicked on, brings up a corresponding datasheet display of orders that company has placed. That datasheet contains a combobox of contacts. What...