Search results for query: *

I am using the the following Function to calculate Working Days. I have a table of Holidays with 2 Fields Holidate(Field Type Date) Name (Field Type Text) The Code works fine when the day in the Holidate field of the table has more than 1 digit but it will not work when it is a single digit date...

Thanks for the prompt reply.This method gives me the previous year but I need to be able to combine the data from both years in a crosstab format as follows :- MTD Actual MTD LYear MTD GP MTD GPLY YTD ACTUAL YTD LYear YTDGP YTDGPLY Thanks and Regards Errol

Thanks for the reply.Please find attached sql for the query. What I need is the same result only for the same period -12 months.Thanks for the help and ideas thus far. Regards and thanks Errol. SELECT DISTINCTROW Sum(SCEX.NETT) AS SumOfNETT, Sum(SCEX.NETT) AS [DAILY SALES], Sum(SCEX.GST) AS...

I need to compare the data between 2years. I have a query that is run from a form that uses parameters between 2 dates from the form. Ineed to compare the date from the same period in the previous year. eg Between begindate a endDate and between begindate-365 and endDate-365. This gives me the...

Many thanks TheAceMan. As the update procedure is written as a function in a module I couldn't use the ME keyword. However by referring to the form directly (Forms_StatsSboard.Recalc) in the function this method works fine. Thanks very much for your help Kind regards Errol

Thanks PHY for the reply I put "Me.Recalc" in the after update event code of the relevant Text box but it does not update the text box. I must be missing the point somewhere. Thanks and regards Errol

Thanks for the reply TheAceMan where do I find the Recalc method and how do I use it? I Tried it Using DoCmd.Recalc at the end of my update code but it returned "Method or data member not found" Thanks for you help Errol

I am using a form as a General purpose switchboard for an application. One of the functions of the form is to update data from text files exported from another application. I am using a text box to display the date of the last update using the function =DMax("[INV_DATE]","SCEX").Unless I open...

I have since solved the problem. The problem is in the MTU settings of the NIC. If the MTU setting of the NIC is reduced to 1400 the printer works fine . I am using a Netgear router with an MTU setting of 1492. The NIC MTU can be changed by downloading a program called DRTCIP from...

I am have the same problem printing over a VPN. However I can print from my Laptop. The setting on the laptop and the desktop appear identical. Both computers are using XP pro Service pack 2. Regards Errol

I am using a function Modified() that calculates when a file was last modified. I want to use this function to create a heading in a query eg. [Stock_On_hand] As SOH & Modified. I am using the following code in a Command Button but cannot get it to work. Private Sub CmdMthly_Click() Dim db As...

Gday Duane, Thanks for your reply, I have looked at the FAQ however maybe I have not been clear in my detail, The report I create from a query may have 1 column or up to 15 columns depending on the data required by the operator. The query column headings are generated using the following code...

Thanks Duane , I have downloaded the file but at present I haven't been able to use it for my application. The column headings that I want to be dynamic are dates formatted as mmm-yy. Thanks for your help Errolf

I am using the following code It is a modified version of the Microsoft Dynamic Report. ' Constant for maximum number of columns EmployeeSales query would ' create plus 1 for a Totals column. Here, you have 9 employees. Const conTotalColumns = 14 ' Variables for Database object...

I am using a report that uses code to generate Dynamic Column Headings. The report appears correctly in the print preview mode but when printed the report only prints multiple records of the last record on the report. Any help appreciated Errol

Thanks Ken, The rest of the parameters relate to a secondary Query that gets its parameters from the same form [GsdataFrm]. My problem is how to reference the parameters in the secondary Query. Errol Featherstone

Iam using a form to send Parameters to a Query used to generate a report with Dynamic Column headings. I can get the report to work to work until I use a second Query to get further data. The error message is "To few parameters expected 5" The following is The query SQL:- PARAMETERS...

Thanks For your help adding the semi colon and the zero solved the problem. Thanks Errol Featherstone

Thanks for the suggestion, I have tried this but it does not make any difference I still only get the numbers inputted but no prefix. Thanks again Errol

I am using a text box on form to input records to a table. I need to to prefix each record in the table with the letters CPFE. The Input Mask that I am using a present is "CPFE"&&&&&&. This shows correctly in the text box but only the numbers are transferred to the table and not the CPFE...