Kevin-
You must import all four files using the VBA Editor in your database.
Call the function CheckStartup from your startup form.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Dec 12, 2015, at 2:11 PM, 'zhaoliqingoffice@163.com' zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
John-
After creating "modStarup" module, how do I apply this funtion? Thanks.
Best Regards,
Kevin
Date: 2015-12-12 18:08Subject: Re: [MS_AccessPros] SQL SERVERKevin-
See StartupExample.zip that I just uploaded.John Viescas, AuthorMicrosoft Access 2010 Inside OutMicrosoft Access 2007 Inside OutMicrosoft Access 2003 Inside OutBuilding Microsoft Access ApplicationsSQL Queries for Mere Mortals(Paris, France)
On Dec 12, 2015, at 12:54 AM, zhaoliqingoffice zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:John-
Is there online examples about the startup code for checkingthe links? Thanks.
Best Regards,
Kevin
发自我的小米手机在 "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2015年12月11日 下午3:16写道：Kevin-
No ODBC required. Simply link the tables to your front end. The Database Splitter utility will help you do that. Move the back end to your server and then use the Linked Table Manager utility to fix the links to point to the database on your server.Caution: The links will use the share drive letter you have defined on your computer. If you copy the front end to someone else's computer, you either need to be sure that the user employs the same drive letter, or you need to write some startup code to check the links an offer to re-link the tables.John Viescas, AuthorMicrosoft Access 2010 Inside OutMicrosoft Access 2007 Inside OutMicrosoft Access 2003 Inside OutBuilding Microsoft Access ApplicationsSQL Queries for Mere Mortals(Paris, France)
On Dec 10, 2015, at 10:02 PM, zhaoliqingoffice zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:John-
To use MS Access as backend, do we need the help of ODBC to link tables, or we can simply link the backend by its local address? Do you have articles online about this topic? Thanks.
Best Regards,
Kevin
发自我的小米手机在 "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2015年12月11日 上午12:58写道：Kevin-
To ensure that all users can fetch the images when required, you should use a full logical path name, something like:Yes, the file names must be unique.John Viescas, AuthorMicrosoft Access 2010 Inside OutMicrosoft Access 2007 Inside OutMicrosoft Access 2003 Inside OutBuilding Microsoft Access ApplicationsSQL Queries for Mere Mortals(Paris, France)
On Dec 10, 2015, at 3:42 PM, zhaoliqingoffice zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:John-
If I store pictures to where the beckend is, what the syntax should be? And every pictures I store should have exclusive name,right?
Best Regards,
Kevin
发自我的小米手机在 "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2015年12月10日 下午10:23写道：Kevin-
Use either the OLE Object data type or a text field into which you store the path (on a shared drive) to the document. If you choose the latter, use the Image control and set the Control Source to the text field. That should load the document when you want to display it on a form or report.John Viescas, AuthorMicrosoft Access 2010 Inside OutMicrosoft Access 2007 Inside OutMicrosoft Access 2003 Inside OutBuilding Microsoft Access ApplicationsSQL Queries for Mere Mortals(Paris, France)
On Dec 10, 2015, at 2:44 PM, zhaoliqingoffice zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:John-
Actually I only need one picture in the attachment. I only saw one choice to stall pictures,that's by attachment. May be there's othe way to store one picture? Thanks.
Best Regards,
Kevin
发自我的小米手机在 "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com>，2015年12月10日 下午8:54写道：Kevin-
Either you or someone else asked about this recently, and we answered that it is not possible to "upsize" an Access table containing the Attachment data type to SQL Server. SQL Server has no equivalent data type. The data type it chose may look like "Memo" in a linked table back to Access, but if you look at the actual data type in the SQL Server table, you'll find one of the "blob" (Large binary) data types.You will need to redesign your table to use text links to externally stored documents. If a record can have multiple documents, you will also have to design additional tables to reflect the actual one-to-many or many-to-many relationship.John Viescas, AuthorMicrosoft Access 2010 Inside OutMicrosoft Access 2007 Inside OutMicrosoft Access 2003 Inside OutBuilding Microsoft Access ApplicationsSQL Queries for Mere Mortals(Paris, France)
On Dec 10, 2015, at 10:37 AM, zhaoliqingoffice zhaoliqingoffice@163.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (19) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar