Search results for query: *

I have developed a number of applications using Access 2000 - generally without too many problems. However, I am having ongoing problems with the page settings when previewing & printing reports. I alter these settings as required - usually landscape with reduced margins all round - and save the...

I need to add a chart to the end of a report. Standard bar chart - no problem, but I need a stacked bar chart which does not appear to be available. Any suggestions? Thanks.

I have seen this topic raised a couple of times but, as yet, cannot get a working solution. I need to get the weeknumber of any given date. I have looked back over previous solutions to this and am using the following function Public Function WeekNum(Mydate) WeekNum = Format(Mydate...

Michael, Thanks for the assistance - I think the problem was that I had a duplicate unsaved visual basic module which I was not aware of - this would have caused the duplicate occurrence of the name. Unfortunately this still has not solved all of the problems! I am calling the function from...

Paul, Thanks for the help - this has moved the problem on stage. The module now compiles OK and lists Deltadays as a user defined function in the Access expression builder. However, when I try to use the function I am getting the Access error "Ambiguous name in query expression...

I am trying to calculate the number of working days (excluding weekend & holiday) between 2 dates. I have found this topic covered in the FAQ section but am having trouble with the code listed there. I have copied & pasted the following code into a new module Public Function...

Thanks for the pointer Michael - looks like this should be exactly what I need. However, I am having a problem with the code :- I have copied the code into a module and have set up the holiday table. When I try to use the Deltadays function I get the following visual basic error "User...

I have a table with 3 fields Field 1 - start date Field 2 - end date Field 3 - working days between start & end dates. Fields 1 & 2 are populated & I need to populate field 3. This to show number of days between start & end dates excluding weekends & any other national...

I am trying to use the NETWORKDAYS function to calculate working days between 2 events. Access 2000 is reporting this as an unknown function. I have checked the help on this which advises me to check for a library (MSOWCF.DLL) and to re-install Access if it is missing. This dll is in place on my...

I am working on a form which contains 2 datasheet subforms. It would be very helpful to highlight particular fields on the datasheet subforms using combinations of text colours / bold / italic etc. I can adjust the text colour & appearance settings in the property box of these datasheets...

Thanks. Just the clue I needed although I had to put the code into the After Update section of the field which sets the parameter for the query filter. Anyhow - problem solved ! Huge Thanks !!!

I am developing an application which uses a combo box to enter data into a field on a form in datasheet mode. The combo box is based on a query which pulls a list of part numbers previously used by a supplier. This works fine for the first record entered but the query does not appear to be...

I am developing an application which uses a combo box to enter data into a field on a form in datasheet mode. The combo box is based on a query which pulls a list of part numbers previously used by a supplier. This works fine for the first record entered but the query does not appear to be...