Search results

You cannot do this on a page footer without special handling (One of the Access gotcha's)Try this link How to Sum a Column of Numbers in a Report by Page: http://support.microsoft.com/support/kb/articles/Q132/0/17.asp Hope this helps Regards trevor from www.accesswatch.co.uk

Nice trick. I'll try and remember that. Regards Trevor from www.accesswatch.co.uk

If you are building your string in VBA then This is a Known problem ('bug') with Concatenated DATES in SQL Strings in VBA. Dates must be in American format under these circumstances. See my reply to the posting 'SQL in VBA' on this forum Note: This only applies to dates in SQL strings in VBA...

I don't think you can do this but it would be very nice. A possible work round is to use a label or text box outside the combo box and change caption and background colour of the label using code fromcombo box on onclick event. The downside is that this only works for the currrent row. If you...

Use DoCmd.ShowToolbar 'Web',acToolbarNo You will have to check that your Web toolbar is still named 'Web' if it is not then change the name in the command above. Look in VIEW,TOOLBAR,CUSTOMISE to see the toolbars available Hope this helps Trevor from www.accesswatch.co.uk

You cannot refresh a report. Once the report has been generated it is in is final state. background info for those that want it The REFRESH and REQUERY properties are used in forms and datasheets. The Requery can also be used on a Forms Control e.g a listbox Examples using Me. To use the...

What error messages are you getting ? Couple of possibilities. SUM function not available. In which case we have the dreaded lib not available The other possibilty I can think of is that you are trying to use SUM on a previously calculated field. Is the TOTALPRICE field a calculated field by...

Question: Have you changed the name of the FIELDS or the CONTROLS containing the fields? If you previously had the control names the same as the field names (The default for acces wizards) but have now changed either the field names and/or the Control names then this could be the cause of the...

Thanks Pat for the correction Mark_e_y Please ignore my previous answers I have deleted these due to the fact they were incorrect. Regards Trevor from www.accesswatch.co.uk (Trust But verify)

Some points to look for Make sure you are using the Field name and not the control name in your SUM You can only use SUM for groups and Report totals. You cannot use them for page totals (Work round available for this see below) You cannot SUM a calculated column directly. Try these KB...

If you want to select the first row of a Listbox irespective of the value of the first row you can use: lstMyListBox.Selected(0) = True If you want to select a specific row based on a LISTBOX or COMBO BOX 'value' then the following will work: This will work if you know the value of the...

You turned up a day late Peter I have just spent the evening trying to locate your program but as I forgot the name It took some time. I'm glad I found it though because I like the look of your other program 'Data Flow manager' which might be just the thing I have been looking for, I'll be...

I think the reason you cannot see the report is because the Developer of your application does not want tyou to see the report in design view i.e it is hidden (thats what I do). Why would they want to do that? To prevent users from trying to open up the report in design view and change there...

You cannot realy have more than one format associated with a field. You could assign a format in code but you would somehow have to trap the type of input the user was going to use befor they entered it. One way of doing this this would be: Remove any formating from the table field formating Add...

I have just come across this link which may be of help. http://www.lebans.com/Report.htm All Looks a bit to complicated for me. Regards trevor from www.accesswatch.co.uk

I don't know of any way to do this but you could use 2 labels, one for the Project and another for the name. Right aligning the first on and left aligning the second label should do it. Hope this helps Trevor from www.accesswatch.co.uk

You could try writing this yourself but it is very time consiming and prone to error, it also requires a number of API calls outside Access so the chances of problesm occuuring on your users machines increases. If you want to try and do it yourself then the "Access 97 Developers Handbook" from...

22 inches is the maximum width of a form in 97. Form other Access 97 constraints check out this link http://www.accesswatch.co.uk/html/microsoft_access_97_constraints/microsoft_access_97_constraints.htm Hope this helps

I am intrigued by this one when you say it works now because it should not. One problem I can see with the code is that you have an End Sub directly after the Exit_Command1:, this should be an 'Exit Sub 'not and 'End Sub' So your code should read Private Sub Command1() On Error GoTo...

You should use Microsoft GRAPH 97 in your Access Database report. Graph 97 is not installed as part of the standard Install therefore you will need to do a custom install. This should be much easier than hard coding your own Graph generator. Look up Graphs in your help file Alternatively you...