Recent content by Patricha

Thanks dalchri, I copied and pasted directly into a blank Query and I am getting an error when I try this Sql. Syntax Error in FROM clause am I missing something? Thanks

Hi, I am trying to get a distinct count. My data looks like this... StudentId ; BookItem ; BookStoreNum ; BookDate 11564;1;342680;12/15/2001 11564;21;342680;12/15/2001 11564;21;342680;12/22/2001 12244;1;342680;1/11/2001 12244;1;342680;2/24/2001 I want a DISTINCT COUNT Select Count(BookDate)...

Thanks Bagger I learned something new about customizing Menu's Big help **Cheers** Andrew

Just something I finished Compacting the Current database. Several steps are needed to accomplish this. Create a blank form call it frmBlank frmBlank.OnOpen (Event Procedure) do any maintenece (empty tables..etc.) frmBlank.OnTimer (Event Procedure) ' Compact database SendKeys...

Hi, I am creating a custom menu using macro (Acc97) and I have File > Open Save Close Print Exit.. Is there a way to put the seperator bar in the menu just like it is in Most of your drop down menu's. Help or insight on this is much apreciated. Thanks Andrew

Thanks for taking the time and reading my post not sure if I am explaining this well, or I am just an idot trying to make something that seems simple - 'Hard'. I have a blank form (simple enough) I click on the toolbar and drag over a textbox (still simple) I click on the toolbar and drag...

I am using Access 97; What I am trying to achieve: a user must scroll to the bottom of a textbox before a command button will be enabled This textbox holds Dynamic data and can exceed the normal length of the textbox (which in effect you get a scroll bar). How can I trap or get this effect to...

I am in need of much help here.... kind of new to sub-reports. My main report works fine and I have the sub report linked fine. The problem is when there are no records in the subreport Ok I have a sub-report that the record source is a sql SELECT id,count(datemailed) as DateLetterMailedOut...

I am in need of much help here.... kind of new to sub-reports. My main report works fine and I have the sub report linked fine. The problem is when there are no records in the subreport Ok I have a sub-report that the record source is a sql SELECT id,count(datemailed) as DateLetterMailedOut...