Search results

How do I group weekly data by a MonthEndDate? Ie. WeekEndDate are 2007-02-10, 2007-02-17, 2007-03-03, 2007-03-17 I need to somehow group these so they show the data as sums for 2007-02-29 and 2007-03-31 Thanks!

Hi I have a statement that checks if a login name belongs to an Active Directory group. The group is set up exactly the same way as all the other groups, which work fine, but it is not returning a positive when a login is part of that group. Any ideas why the return is a zero instead of a...

I've created an unbound form with a list box and two combo boxes. The list box is multi-columns and contains the Primary Keys of the two combo boxes row sources. First column in each of the combo boxes is the primary key and has a zero width so they don't show. So here is the problem, I have...

I have an unbound form which contains a listbox and two combo boxes. The combo boxes have a rowsource from a SQL Server stored procedure, while the list box is filled by passing the contactid to the form and then created a query string as the rowsource. So far all of this works fine. Now here...

I have a very elaborate Access 2000 application that uses three different SQL databases as the back end. Mostly the data is modified or selected via ADO connections. The problem I am having is that recently users on Terminal Server are not able to open the application because for some reason...

I have a main form with several sub forms, but they are handled as objects. So first the forms are declared at the module level (they already exist on the form at this point as sub forms but have no parent child relationship). Option Compare Database Option Explicit ‘Module Level Variables...