Search results

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

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

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

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

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

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

Hi, I'm trying to check whether a field [Letter] in a table "Not Started List" has a specific value, 6M or 30M, if either of these values are present then I want to continue running a macro, otherwise msgbox 'No data, quitting'. Can I use DCount for this, or do I need something else? At the...

Hi, I have a button on a form which starts a macro, which does the following. Setwarnings off OpenQuery "QueryMergeData" RunApp "C:\Program Files\Microsoft Office\Office\WINWORD.EXE" & "J:\Reports\BC\Admin\Merge.doc" Setwarnings on The Word Document uses data from a table that query has...

Hello all, I have a field in a query(make table) which calculates the number of days between 2 dates[TIME], then I have the query determine the value of two other fields 'Letter: LetType([TIME])' and 'range: PeriodChecker([TIME])' depending on the value of [TIME]. I do this by using a function...

Hi, I have a button which launches a make table query, starts MS Word, which reads from the table and mail merge's some of the results. The query will typically return a good number of records, but I only want to mail merge ones where the field 'LetType' equals 6M or 30M. Often, there are no...

Hi, I have an 'Events' Database in which I'm trying to record time spent by various staff members at each event. tables; tblAppDetails, tblEmployee, tblHours I have already made a good start on the main input form, but need some help of the employee/hours sub-form. It's a relationship...

Hi, I have a form on which I have 5 tabbed pages each page having a few controls on it. Problem is that I really need to rename my form, but most of my query's/reports reference the controls on the form. Is there any way to change the name of the form and update all the query's accordingly...

Can anyone tell me what this does; In the field (QBE grid) Format(DateAdd("yyyy",3,[CASEDT]),"mmyyyy") and in the criteria field there is; Format(DateAdd("m",2,Date()),"mmyyyy") The field [CASEDT] Is a date field, and as far I can see, this criteria will pull results that have dates which...

Hi, I have a form which has an optional combo-box field which can be selected prior to running a report. I would like my report to pull through the selection from the combo box, or if the combo-box was left blank, to display 'No team selected' I have done this before and am searching through...

Hi all, I have three tables, Property, Owner and LetType For each property, there can be multiple owners. For each owner, there can be multiple letter types sent on different dates. The letter types will be limited to 3 or 4 types. I need to record when we sent the letters to each owner, the...

Hi, I would like to produce a report (actually need a graph, but haven't even looked at that!) that will allow me to compare data from 2 years side by side. I want to total various fields (9 in total) recieved in a 4 week period. Then I want to see cumulative totals over the year, for both...

Hi, I'm starting from scratch with an events database but need some advice on tables/relationships. The main purpose of the database is to calculate/record the hours spent and fees generated by our staff members who attend the events. Each EVENT may be spread over a few SITES (eg New years eve...