I have the error :-2147352567 Exception occurred when I execute the code below. The "tbl_MiseAJour" is a linked table Code Snippet: 1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42:...

I know I'v done this before but have forgotten how. I have the user select a file from a dialog box. What is returned is the full path with the file name at the end. For example fullpath = "C:\Dircet1\Direct2\selectedfile.txt" Given this string I want to pull the just file name and extension...

I want to do one simple thing. Push a button and export "MyTable" to Excel. To make things easy, save in my documents folder. File name will be provided on form text box.

We have an access database that worked fine on XP machines. We've recently upgraded a couple of them to Windows 7. The problem we are encountering is "No object in this control" when opening the database on that computer. The only thing we've done differently between the XP and 7 machines...

I have a form with 24 columns and I want to be able to see the first Three columns when I am scrolling to the right. These 3 columns are the key to know what the other columns are. The form that I have is a Continues Forms view now. Thank you

I currently view pdf files via a command button with the following code; Dim strPath, strFileName As String strPath = Me.tbFPath strFileName = Me.tbFName ShellExecute Me.hWnd, "open", strPath & strFileName, "", "", SW_SHOW I can not find any documentation on this as...

My company is currently in the process of updating the laptops from Dell 610 to Latitude E6400 Notebook. With this upgrade the mousehook.dll is no longer recognized. does anyone have a work around? I found this post on ee: http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24070342.html...

Hello All, I have a big problem and need to resolve it quickly. I have a Database that has been moved out into production with my small group of engineers. However, I have a function that is giving me this 3271 run time error. Recently, I had this question posted on EE and got the resolution I needed...

I create a main form that shows only the buttons that they need. Access Menu is not showing

Hi, I wonder if somebody could help me with this problem. I have created a custom message box for my application which is basically just a form that pops up over the current form displaying some text with a couple of buttons to receive the users response. I need to halt the code whilst waiting for the...