Search results

can i bring whippet t' pub?

As you upsidedowners like to say No worries mate. Chris

Hello Answer to my own question. DoCmd.DeleteObject acQuery, "QRY_AVGWAIT" DoCmd.DeleteObject acQuery, "QRY_AVGWAIT2" Chris

Ah! the fact that i didn't have those subs means my attempt worked. Oh well glad you solved it. Is this the reason you had problems with >I've tried creating the objSht as a ("Excel.Sheet") class instead of adding it as a Sheet to a Workbook but that brings it's own problems of when adding...

Hello Thats odd as i pasted your code into a module removed the case statements and just created the workbook and it saved fine without the dialog appearing Dim objXl, objWkb, objSht As Object Set objXl = CreateObject("Excel.Application") objXl.Visible = True Set objWkb =...

Hello try objSht.SaveAs "C:\fred.xls" Chris

Hello You could try using DIM r as DAO.r and DIM db as DAO.db making sure that the Microsoft DAO 3.6 object library reference is checked. This cured a similar problem i had. Chris

Hello I've put this statement into the mousedown event of a combobox Their could be more than one problem but i can't get passed the fact that it tells me the queries already exist. If this is the case should the querydefs be initalized when the database is loaded and then the rowsource of...

Hello I'm sure i'll get shot down in flames yet again but this works in Excel so the logic should be sound. INT(44/5)*5+5 = 45 INT(47/5)*5+5 = 50 Chris apologies len must be writting same time!

Hello solved it SELECT TOP 5 Count(TBL_ADHOC_REQUESTS.[REQUEST ID]) AS [TOP 5 REQUESTERS], TBL_REQUESTERS.Names FROM TBL_REQUESTERS RIGHT JOIN TBL_ADHOC_REQUESTS ON TBL_REQUESTERS.ID = TBL_ADHOC_REQUESTS.[REQUESTER ID] GROUP BY TBL_REQUESTERS.Names ORDER BY Count(TBL_ADHOC_REQUESTS.[REQUEST...

Hello I would like to do a top 5 query on a groupby query the trouble is i get the top 5 names i.e in alphabetical order rather than the top 5 highest values from the count SELECT TOP 5 Count(TBL_ADHOC_REQUESTS.[REQUESTER ID]) AS [TOP 5 REQUESTERS], TBL_REQUESTERS.Names FROM TBL_REQUESTERS...

Hello Don't know about being a guru but according to my calender there are only two weekends between sept-6-2002 and sept-16-2002 RE: >4 weekends from the 6th to the 16th < >Sept 6, 2002 and end date as Sept 16 2002. So I do the following: < Chris PS there is a weekday function in EXCEL...

Hello Just had a quick try of this. Created a combobox based on a table in a form. Then created a textbox on the form. Then selected the AfterUpdate option for the combobox and selected code builder. Private Sub Combo2_AfterUpdate() Text4.SetFocus End Sub Then select the GotFocus property...

Hello I don't know if this is familiar this is how i send e-mail any way. Public Function Mailer() Dim olkapps As Outlook.Application Dim olknamespaces As Outlook.NameSpace Dim objmailitems As Outlook.MailItem SetWarnings = False Set olkapps = New Outlook.Application Set olknamespaces =...

which sub do you mean? This code will run a saved query. Dim stDocName As String stDocName = "Query1" DoCmd.OpenQuery stDocName, acNormal, acEdit Chris

Hello If you know how to do a group by query (sounds like you do) then all you need to do is select the id of the CSR and a datefield related to the time field and the time. You group on the ID and the date and count on the time. This will give you the number of entries per CSR on any given...

Hello In the forms on_load procedure type docmd.maximize Chris

Hello You can do a simple delete query in the query builder. Go to the query window select create query in design view. Select the table you want to delete the records from. select the Query field on the menu bar. Select delete query. double click on the * in the table then double click on the...

Hello I have spent many a day cursing crosstab queries and their reports. So i decided to try and write a dynamic report that runs off a crosstab query. I was wondering should anyone be interested to look at it they could provide some feedback. Cheers Chris

Hello You did it again!!. Thanks thats saved the hairline for another day. Cheers Chris