Search results

Hi Mailman, Nice to talk to you again... That works in terms of actually getting a value out of dtAddMin, I think my problem is getting the right time formats as every result is coming up as a "long date"

Greetings Gurus, Please could someone tell me how to add 2 time values together? I have a form which has two unbound text boxes into which a user can submit a numeric value (e.g. "10") which is supposed to be the amount of time that user has been doing something. This value is supposed to be...

Hi, That's kind of what I am doing by querying whether the Username is "" or Recordset doesn't exist. Seemed simpler that way. I have got the minimise effect to work without requiring a module, if forms part of the action if a record is not found. I didn't write the code. Darbid ended up doing...

Hi Nigel, Here's the current method. As stated, PC1 runs Outlook & Access. There is an Outlook.OTM script that "listens" for messages on an Exchange public folder and when one is received it passes the new mail on to Access. Access stores the required details in a table (with a SQL B/E) and...

Thank you lagbolt & ghudon. Those both work very nicely.

Greetings gurus, Could you help please? I have a form which loads on Access startup. If a record exists in the form then an action is performed but how do you define an action if there are no records? The code I have got isIf Me.UserName <> "" Then DoCmd.Maximize MsgBox "New Support Request"...

Hi Ken, I would except then I can't run the form minimised surely?

I already have the form, it's called SupportList. I am thinking it may be an idea to launch it at Access startup from the "Startup" option, pop-up a message saying "no new entries" or something similar and auto-minimising it to the taskbar. That form could then query the table every 1 minute (if...

ghudson.. I get your point, the alert has to be interactive so that when it is clicked to acknowledge it then that click triggers the calling of a form which summarises the request. If the user double clicks on a field in that summary it opens the form which is used to process the request...

GHudson... aaah, if only I could... It's a support database. Users send us requests for assistance that need to be dealt with A.S.A.P.

Wow..that's some serious code... It's also WAAAAY over my head and I would love to use it if I could understand it. I think however that it is much more than I need and, if you will excuse me, I think I would prefer to simplify life a little and go with the idea of using the F/Es to query the...

Hi again, OK, I think I get what you are saying.. So, create a module? Do something likeOption Compare Database Public Sub Timer(Cancel As Integer) Me.TimerInterval = 10000 Dim db As Database, tb As DAO.Recordset Set db = CurrentDb Set tb = db.OpenRecordset("dbo_Support", dbOpenDynaset...

Hi Ken & Nigel, Perhaps I didn't explain properly, the scenario is... PC1 runs Outlook & Access. When a new email arrives the Outlook.OTM scripts passes the details to Access which writes the relevant email into a SQL B/E database. Pc2, pc3 & pc4 then use a form to manipulate the data in that...

Greetings Gurus, Thanks to Darbid I have a listener set up in Access receiving incoming email and writing them to a table. What I would like to know is if it is possible for that machine (hosting Access & Outlook) to send a non-email based alert when a new record is written to the table to...