Search results for query: *

That appears to put 23rd July in all fields I only want the 23rd July to appear where the check box is true?

Hi The sql is: SELECT Main.Name, Main.Address, Main.Town, Main.Postcode, Venues.[venue name], Main.Date_of_Booking, Venues.Time, Main.[23/07] FROM Venues INNER JOIN Main ON Venues.[venue name] = Main.venue WHERE (((Main.[23/07])=IIf([Main]![23/07]=True,"23rd July"))); [23/07] is a boolean...

Hi I have a table with a number of dates that are checkboxes. I need to mailmerge this table into a letter and display the label of the checkbox rather than the True/False value of the check box. I have tried an IIF statement so if the value is true to display the date (eg...

No the split works fine and we have the tables in one database and the queries and reports in an another - its just we don't get exclusive access still. At the moment both are on the shared network drive - if I put the front end on the local machine will everyone still access the same reports etc?

Hi We currently have an Access database which consists of alot of queries and reports and a form from which users can modify the criteria (dates, officers etc) for each report. This has been working very well, however, as this database is being used by more and more people the administrator of...

well I have tried using avg from within the query before the workingdays function eg: avg(Workdays: WorkingDays([DATEAPVAL],[DATEPRNT])-1) I have also tried it in the foot of a report that uses the working days field. I just get an error saying its too complex.

Hi Yes there is a holidays function: Public Function Holidays(FromDate As Date, UntilDate As Date) As Integer Dim FDate As String Dim UDate As String If IsNull(FromDate) Or IsNull(UntilDate) Then Holidays = 0 Exit Function End If FDate =...

Thanks for the reply - the Working days function was written by an external source. Here it is: Public Function WorkingDays(FromDate As Date, UntilDate As Date) As Integer If IsNull(FromDate) Or IsNull(UntilDate) Then WorkingDays = 0 Exit Function End If If UntilDate...

Hi I have an Access query in which I calculate the number of Working days between two dates. How do I workout the average of this figure? I have tried using Avg as well as dAvg both in the query and also in the footer of a report but I just get errors. Any ideas as to what I am doing wrong...

Yes it is - it chooses the standard default printer as the first option to choose from.

Well I have checked the majority of the reports and they are all set to Default printer rather than 'Use specific printer'. Maybe its more of a network issue?

Well all applications are set to use the default printer is there a separate way within Access that you can select the printer?

Hi We have 2 (Canon/Oce) printers on each floor and each individual prints direct to the own mailbox. We have an access 2000 database that is basically a report generator from an internal system. Reports are being added and amended all the time but whats recently started happening is that who...

Thanks for this - I did try the Min function but used the Values drop down on the tool bar and not the Totals icon. That seems to work, thanks.

Hi This probably has a very simple answer but I can't find it! I have an audit table which records any changes made to another table which contains applications. The audit table records the date and time of the change, who did it and the application number. An application maybe updated a number...

Just to let you know our support guy has done the following and it works! set $tape = "/dev/nrst10" has been changed to : set $tape = "/dev/rmt/0cn" Our backup has now fit all onto one tape, thanks for you help!

Right I have posted the results below, it appears that we link to rmt/01bn for our tape device? lrwxrwxrwx 1 root root 8 Jul 8 2003 nrst10 -> rmt/0lbn lrwxrwxrwx 1 root root 8 Aug 8 2003 nrst13 -> rmt/1mbn lrwxrwxrwx 1 root root 8 Jul 8...

Hi The two main lines in our dump which I think are relevant are : set tape = "/dev/nrst 10" /usr/sbin/ufsdump 0uf $tape /apps If we had c to the 0uf section will that allow us compression and if so what of? Thanks

Hi I am not a support person so I am trying to find out to assist our support guy! I think that our DLT tape currently holds 30gb but we have had a system upgrade and we now have 35gb to back up. We are aware that we can change the compression on our tape deck so it compresses the data so we...

Hi We have a changed the density of our tape deck and the instructions say to 'format' the tape. How do we do this using Solaris 8? Any help would be appreciated!! Thanks