Recent content by Franky G

Hi, When I try to run this query I get an error 'Invalid Operation' When I remove the 'OR' criteria, it works no problem. (it works irrespective of which OR criteria I leave in). SELECT UNI73LIVE_SBCASE.REFVAL AS [Case No], UNI73LIVE_SBCASE.WARD, OneLineAddress([ADDRESS]) AS [Site Address]...

Thanks Pat, although I do need to store who borrowed the map. I have actually included a field in the Dates table to record who takes the map, is that OK? What does Cascade delete do? Thanks FrankyG

Hi, I would like to keep track of maps which I control, such as who the map was given to, MapOut date and MapIn dates. (and ultimately to produce report on each map on 1 years worth of OUT/IN data, average time out etc) I have a table containing Map information (MapNo, MapName, MapOwner etc)...

Hi, At the moment I'm using a Macro to Start MS Word with a specific template, which is working fine. However, some staff have moved onto XP/ Office XP PC's while I'm developing on W2k. The problem is that the path to WINWORD.exe is different, and the Macro can't handle that. So I suppose I'm...

Sorry, it's the actual code for toggling the value of field 'Mode' that I'm struggling with. Am I right in saying that even if a field on a form is invisible, it can still be active? FrankyG

Hi, I've got a table 'tblMaintMode' with one field 'Mode' which will be either 0 or 1. I've got a hidden form timer event checking this value and when it's set to 1 then Access will close for maintenance. I'd like to have a button on my main form which would be invisible, only I know where it...

Hey, thanks for the quick reply...got it working, at least the first bit. Now to check whether I can change the value in tblMaintMode while other users are in the Database...hmmm. If I can, then Sweeeet :-) FrankyG

Hi, My DB is split into front and back end, most of the tables are linked to Oracle database. At the moment, I'm using a hidden form to detect idletime and close the database after x minutes of idletime - see http://support.microsoft.com/default.aspx?scid=KB;en-us;128814 I would rather have a...

Thanks, managed to figure it yesterday. Made the sendmail code a sub and just inserted the line Call SendMail into my code. Works for me anyway! Cheers! FrankyG

Hi, I have some code which runs when a user clicks a button, which notifies the user (msgbox) that an alert will be sent to the administrator if they elect to continue. If they click Continue, I would like to call a module which sends the email, then continues with the code that runs my query...

Hi all, I've got a query which calculates the total applications received between two dates, and the value of these applications. At the moment, I'm running the query 13 times-as an update table query which gives me the totals for a year. How can I make the query run, append to the table, and...

Not sure where this should be asked; I would like to produce graphs which compare 3 or 4 figures based on selected periods. eg. compare figures a, b and c for 01/01/2002 to 30/03/2002 with figures a, b and c for 01/01/2003 to 30/30/2003. I would like these on the same graph so a side by side...

I don't believe I didn't try that...is it not the most obvious thing in the world :rolleyes: It works...It's Miller Time...:D Thanks! FrankyG

Hi, I'm trying to identify applications which have been in the system from more than x days but not responded to, x being variable and entered onto a user form. I'm trying to calculate working days between 2 dates, using this function; Public Function WorkingDays(FromDate As Date, UntilDate...

Ok Jon, this worked; I got my clumsy version working also, and Mile-O, haven't tried your revised statement yet :) Thank you, another project concluded with your help :D Regards FrankyG