Search results for query: *

I had same problem. Solved it by creating an install program (in Access) they creates the desktop shortcut. The shortcut must contain the full path to Access (MSACCESS.EXE) and the path to the mde file. Example: "C:\Program Files (x86)\Microsoft Office\Office12\MSACCESS.EXE"...

Excel 2010 max row= 1,048,576 and max colums= 16,384 You should write code to open Excel and copy data you need to the different tables. That is what I do with large Excel files. Tom

Not correct. I use the following code: Const SW_HIDE = 0 Const SW_SHOWNORMAL = 1 Const SW_SHOWMINIMIZED = 2 Const SW_SHOWMAXIMIZED = 3 Private Declare Function IsWindowVisible Lib "user32" (ByVal hwnd As Long) As Long Dim dwReturn As Long Private Declare Function ShowWindow Lib "user32"...

Export using a query, not a table, and format the date field in the query the way you want it. Tom

It’s been a while, so I take a stab at it. Here’s the way I allow a user to check spelling in the remarks of an inspection checklist. I set focus to the text box holding the remarks. The control source is a field from a table. When the user clicks the “Check Spelling” button, I run...

Check out the help screen on "Publish a database to a SharePoint site". This option is available only if your database is saved in Office Access 2007 format.

Check out this thread. thread181-1349692

To force the user to go to the F drive and download the correct version, simply add this next line below your msgbox line: application.Quit acQuitSaveNone This will close his program. Tom

To hide the ribbon: DoCmd.ShowToolbar "Ribbon", acToolbarNo To unhide it: DoCmd.ShowToolbar "Ribbon", acToolbarYes

Also add in the lines in red or you'll error out because the Application.CurrentProject.Path does exist. Sub myMkDir(strFolderName As String) On Error goto Err_h Dim a, t As String, i As Integer a = Split(strFolderName, "\") t = a(0) For i = 1 To UBound(a) t = t & "\" & a(i) If Len(Dir(t...

Try this: Function GetData() Dim wshNetWork Dim strUserDomain Dim strCompName Set wshNetWork = CreateObject("WScript.Network") strUserDomain = wshNetWork.UserDomain strCompName = wshNetWork.computername MsgBox "User Domain: " & strUserDomain & vbNewLine & "Computer...

They were running on XP Pro, but we just get upgraded to VISTA Enterprise. Tom

The code in the link below shows how to pop a dialog box for the user to select a file. It returns the path and file name selected. http://support.microsoft.com/kb/824272 Tom

Like you I was reluctant to move to AC2007. I have a lot large Access 2003 applications and using VBA. All worked under AC2007 using AC2003 file format. And with AC2007, instead of sending reports to the screen or to a file you can send to either in PDF format. Tom

Set a password in the BE.

You are not closing the instance of excel. Use: oapp.quit

Check out http://www.cpearson.com/EXCEL/recycle.aspx He gives a good example of vb code.

Just a thought form me. I programmed large and small applications in Clipper for many many years. I choose to convert them all to Microsoft Access. I’ve gone through Access 97, 2003 and now using Access 2007. The learning curve was not that big. Using VBA inside Access is a lot like Clipper...

Check out: faq703-3270

Check out the code in Thread705-735830 I use it with a lot of users - no problems.