Search results

Unfortunately this wouldnt work as, like you say, there are situations where they need to close without running the query. There is another button for this also. I'll try to explain in a little more detail. The db is for Time Management, it logs time spent on each task by logging the time...

I really dont know how the process could be tweaked to improve this. There is one button that closes and runs a query, and one button that doesnt. They should always, at the end of their shift, use the button that runs the query and closes the DB. However they are using the close button...

I presume using Access built in Macro writer. On the 'Create' ribbon you should see Macro, Module, Class Module & VBA. You are looking for the 'Macro' option which I guess is what you require. Its a lazy mans VBA anyway really, it just does most of the coding for you with little input :).

Yes, they are successfully prevented from closing the application UNLESS they use this button to do so (as it runs a query that updates one of my tables first).

Almost there guys, almost there! So, it works. But... I get a Runtime Error when running the Macro. Code below... Private Sub Command2_Click() blockClose = False DoCmd.OpenQuery "End Shift", acViewNormal, acReadOnly DoCmd.OpenQuery "End Client", acViewNormal, acEdit...

I knew it'd be something like that that I'd missed! Changed to Expression and now works perfectly, thank you!

I think this works perfectly... I will dismantle your test DB shortly and see if I can replicate it. Will keep you updated..

The spellings are correct in relation to the field names as far as I can see. SELECT [Possible CMYR].Agent, Count([Possible CMYR].ID) AS CountOfID, Avg([Possible CMYR].[Criteria Sum]) AS [AvgOfCriteria Sum], Avg([Possible CMYR].[Total applicable criteria]) AS [AvgOfTotal applicable...

I had considered this option, however in the instances where they need to close the programme without running the query, it is no longer possible.

This part... Sorry, I'm not great with VB... 'Disable the Close Button Option Sub CloseButtonState(boolClose As Boolean) Dim hWnd As Long Dim wFlags As Long Dim hMenu As Long Dim result As Long hWnd = Application.hWndAccessApp hMenu = GetSystemMenu(hWnd, 0)...

So just tried this, now I'm getting a Type Mismatch Error at Thanks Microsoft...!

Basically I have a button they can click to close it without running the query, and a button they can click to run the query and close. When they are supposed to be click the button to run query and close, they are just pressing the close X. I don't see what else I can do but any advise or...

Hello I have a Time Management database which the users keep closing without running a specific query by mistake. In an effort to work around this I added a the query to the 'On-close' event of the main form, however this cannot be used as some times they need to close the db without running...

Hello So, my database is for QA monitoring data. I have created a query that populates the agents average scores and the numbers of calls QA'd. Two of the fields in my query (Total Applicable Criteria & Criteria Sum) are set to the Total 'AVG' to obtain their average of these fields...

And I read your post immediately and left the tab open until I replied 2 and a half hours later, meaning I had not refreshed the page and did not see your edit until I had posted the reply.

It makes perfect sense now that it has been edited. Thanks Plog.

Right.. I dont understand why it happens, only that it does and the result. Have now amended my calculations - thanks for your help!

Hello I have a database that stores QA data, a percentage score is calculated and I was previously able to obtain an accurate average by agent percentage score. However, now, the average percentages (which are calculated in a query) are completely inaccurate. For example the majority if not...

Hello, Just wanted to get everyones views to see if there is an easier way around this. I have a database that when opened, currently displays the error 'The setting you entered isnt valid for this property.' I havent made any recent changes, but havent opened the database in a long time as...

Resolved myself. Amended the main report to a main form, and changed my subreport to a subform that was continuous as it can still display the data.