Search results

I'm looking for a way to cancel the closing of a form/app. I added a button asking if the user is sure they wish to exit, and am having difficulty finding the correct code to cancel the close event. Here is my code Dim ians As Integer ians = MsgBox("Are you sure you wish to exit?"...

I am trying to access a textbox I have on a report within the report but it is not working properly. I have a team average for a field in a textbox called txtTeamAvg, however it is only tracking the results for some of the teams. In my report footer I want to take the average of txtTeamAvg...

I have an excel sheet to which i am exporting a query to, however the sheet then needs to be modified/formatted. Is there an easy way to do this? When I do the export first, then try to insert rows it won't let me and pulling the data I need out, formatting the excel sheet then putting the...

I am working on decreasing the loading times and increasing the efficiency of an over-inflated Access database that is on its last legs. The backbone table is well over 500,000 records and around 142 fields on the SQL Server backend, and the task is to make a local table with a single record...

I am working on decreasing the loading times and increasing the efficiency of an over-inflated Access database that is on its last legs. The backbone table is well over 500,000 records and around 75-85 fields on the SQL Server backend, and the task is to make a local table with a single record...

I have a checkbox that's bound to a recordset and am trying to find a way to disable a button if all records are checked. However, it appears that the sub must end before I can execute the code to get the correct results of what has been checked. For example: I have 4 records that have been...

I get a critical error (don't remember exactly what it is off the top of my head but it's one of those very vague ones) when trying to execute a simple update statement through VBA on a SQL Server linked table. When it crashes, it has actually executed the command but still pops up the...

I want to disable the user from cutting/copying/pasting the value of a text box. What is the keyAscii of SHIFT as well as CTRL so on the keypress event for that textbox I can simply set it to a null. Or is there an easier way to do this?

Does anyone have any examples of a spell checker? I found one that opens a word doc and copies the text into that, but it does not do what I need it to do. The built in spellchecker ignores Upper case values, and breaks after 3-4 tabs/subforms

Is there a way to disable the filter feature in MS Access? I have several users that use the filter to find a single record when I've repeatedly told them that using CTRL-F is faster and less of a strain on network traffic. I'm trying to eliminate all possible causes of a massive slowdown that...

I had a breakpoint set in my code, removed it and tested the program. When the code got to where my breakpoint was, it acted as if it was still there. I closed down the database and started it up again. The same thing happened (several times). I tried clearing out all the breakpoints and...

I am setting the rowsource of a combobox/datagrid at run time to speed up processing, is there a way to specify NOLOCK or something similar to prevent lockups? I'm having some lock-up problems where processes on SQL Server 2k get behind a process sitting on a select statement that isn't too...

I'm having some problems finding the proper VBA syntax for checking to see if the text in a textbox is contained in a combobox. I'd know how to do this in VB.Net, but unfortunately I'm using VBA. I have a sub-form where all the data is bound from one table, and have added a combobox to this...