--- In MS_Access_Professionals@yahoogroups.com, "Art" <dbalorenzini@...> wrote:
>
> I have a custom database which I would like to add a custom help system for each field. Does any one have an example of one or ideas how to approach it.
>
> Thanks,
>
> Art Lorenzini
> Sioux Falls
>
Hi Art,
I can only speak from my experience with using help systems.
When I create a project I also create a Help document in Word. I then save individual pieces of it, sort of like TOPICS, as html pages via the save option of Word. I then use a Free utility called Easy CHM which will take all the html pages and convert and combine them into a Compiled help file.
If you open a form in design mode (access) and go to the tab OTHER, you will see Help File. In that place i then place the location of my compiled help file, which was created via the easy chm program....here is an example of what that entry looks like
c:\USC_SENIOR_MENTOR\help1.CHM
Now the Easy chm program will allow you to change topic header and things like that. It also creates a MAP. The map associate a number with each individual topic within your compiled help file.
if you again look at the form in design mode, just below the Help File, you will see Help Context id. In this field you will place a number. This number is created via the easy chm program, it is known as the MAP. For example, in a compiled help file I may have a map that says INTRODUCTION 1001, FORM A 1010, FORM B 1020.
when you enter the number 1010 in that context field, that tell access to open the Help file located at c:\USC_SENIOR_MENTOR\help1.CHM
and navigate within the help file to the whatever topic is associated with 1010. Like a lookup table thing.
Result is as follows: when access is displaying FORM A, AND THE USER HITS THE f1 KEY, the help file is opened and self navigates to the topic mapped to 1010 which in this case is the topic FORM A.
Now additionally you have the option of using the HINTS for each individual field or control.
To use this all you need do is open a form in design mode, highlight a control and goto the TAB OTHER, there you see the field CONTROLTIP TXT. All you need do is type a few words about the control , example, Enter Your Name. Then when the you hover your mouse over the control for a second or two, the HINT ballon will appear and display your Hint.
I hope this helps ?....... I am more than willing to work with you on this. I found it very confusing at first and found very little documentation (NO HELP FILES LOL) on how to do this.
Yours terence
Kamis, 30 Juni 2011
[MS_AccessPros] Re: Developing a help system
[AccessDevelopers] Access 07 front end
What's better to house the backend of a 50 Meg db? (40 read only users; 10 read/write users) SQl Server or Sharepoint? It seems as though there is more functionality using SQL Server (or at least to utilize).
Please zip all files prior to uploading to Files section.
Re: [MS_AccessPros] Repost: Problem backing up SQL Server database using backup.sql file
Bill thanks, you've pointed me to the solution
"First, SQL scripts don't run themselves. "
On the original server where everything was working smoothly I was firing the script in a batch file with the line:
sqlcmd -i "C:\Backup\FullBU.sql"
Once i created a corresponding batch file on the new PC and fired the script with the preceding "sqlcmd -i ..." it all works fine.
Thanks so much for the pointer.
I can now go ahead and create batch files to cover full weekly and daily differential backups.
I've never done a log backup, can you explain a bit more about this?
Also, I've never done a system database backup, could you explain this also
Many thanks to Bill and John V for your help and input
Cheers
John C
--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> John
>
>
>
> Sorry, I didn't see your original post.
>
>
>
> First, SQL scripts don't run themselves. Even stored procedures need to be
> executed.
>
>
>
> Here is what I do. I create 3 maintenance plans to do a full back up every
> week, a diff every day and a log back up every hour (or more often if the
> database is heavily used.
>
>
>
> That will create 3 jobs to run them and you don't need to run scripts or
> anything else.
>
>
>
> Don't forget to back up the system databases as well.
>
>
>
> Regards,
>
> Bill
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of john_coote
> Sent: Wednesday, June 29, 2011 4:47 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Repost: Problem backing up SQL Server database using
> backup.sql file
>
>
>
>
>
> Dear all,
> I'm reposting this as it seemed to become associated with replies which were not
> on the topic.
> If this is not the best place to ask, can anyone direct me to an appropriate
> forum for SQL Server questions?
>
> Many Thanks,
> John
>
> I'm having some trouble running a backup running a backup using a query
> contained withn a .sql file.
> I need to resolve this issue so I can automate backups for my client.
> Any advice would be gladly appreciated.
> PC is Windows 7 Professional, 64 Bit
> SQL Server Express Edition with Advanced Services (2008 R2)
>
> I have two scripts (below) saved as FULLBU.sql and DIFFBU.sql. Neither are
> working how I would expect. scripts which are identical except for database name
> and file location are working perfectly on another server.
>
> <<<FULL DATABASE BACKUP>>>
> BACKUP DATABASE [ASEEDA] TO DISK = N'C:\Program Files (x86)\Microsoft SQL
> Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\ASEEDA.bak' WITH NOFORMAT, NOINIT,
> NAME = N'ASEEDA-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
> GO
>
> AND
>
> <<<DIFFERENTIAL DATABASE BACKUP>>>
> BACKUP DATABASE [ASEEDA] TO DISK = N'C:\Program Files (x86)\Microsoft SQL
> Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\ASEEDA.bak' WITH DIFFERENTIAL ,
> NOFORMAT, NOINIT, NAME = N'ASEEDA-Differential Database Backup', SKIP,
> NOREWIND, NOUNLOAD, STATS = 10
> GO
>
> When I execute either file with SQL Server Management Studio closed; no backup
> happens, SQL Server Management Studio opens, but does not connect to any
> objects.
>
> When I execute either file with SQL Server Management Studio open; the text of
> the script file opens in the Query window but does not execute. If I click on
> Execute, the backup runs as expected. This makes me think that there's nothing
> wrong with the query, but it's somehow failing to connect. I'm stumped.
>
> From SQL Server Configuration Manager, the running services are;
> SQL Server and
> SQL Server Browser
> (on the other computer where these .sql files do execute correctly there is one
> other service running, "SQL Full-text Filter Daemon Launcher"
>
> This is the information from SQL Server Management Studio - About:
>
> Microsoft SQL Server Management Studio 10.50.1600.1
> Microsoft Data Access Components (MDAC) 6.1.7601.17514
> Microsoft MSXML 3.0 4.0 5.0 6.0
> Microsoft Internet Explorer 8.0.7601.17514
> Microsoft .NET Framework 2.0.50727.5446
> Operating System 6.1.7601
>
> Thanks
> John
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
[MS_AccessPros] Re: Repost: Problem backing up SQL Server database using backup.sql file
Hi John, not trying to run these from Access.
I have the script saved as a file with a .sql extension.
With SQL Server Management studio running, after I double click the file "backup.sql", the text is loaded into the SQL server Management Studio window, where I can execute the query and it all works just fine.
--- In MS_Access_Professionals@yahoogroups.com, "John Viescas" <john@...> wrote:
>
> John-
>
> Are you trying to execute these from Access using Pass-Through queries? Do the
> scripts run OK in Management Studio?
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of john_coote
> Sent: Thursday, June 30, 2011 1:47 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Repost: Problem backing up SQL Server database using
> backup.sql file
>
> Dear all,
> I'm reposting this as it seemed to become associated with replies which were not
> on the topic.
> If this is not the best place to ask, can anyone direct me to an appropriate
> forum for SQL Server questions?
>
> Many Thanks,
> John
>
>
> I'm having some trouble running a backup running a backup using a query
> contained withn a .sql file.
> I need to resolve this issue so I can automate backups for my client.
> Any advice would be gladly appreciated.
> PC is Windows 7 Professional, 64 Bit
> SQL Server Express Edition with Advanced Services (2008 R2)
>
>
> I have two scripts (below) saved as FULLBU.sql and DIFFBU.sql. Neither are
> working how I would expect. scripts which are identical except for database name
> and file location are working perfectly on another server.
>
> <<<FULL DATABASE BACKUP>>>
> BACKUP DATABASE [ASEEDA] TO DISK = N'C:\Program Files (x86)\Microsoft SQL
> Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\ASEEDA.bak' WITH NOFORMAT, NOINIT,
> NAME = N'ASEEDA-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
> GO
>
>
> AND
>
> <<<DIFFERENTIAL DATABASE BACKUP>>>
> BACKUP DATABASE [ASEEDA] TO DISK = N'C:\Program Files (x86)\Microsoft SQL
> Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\ASEEDA.bak' WITH DIFFERENTIAL ,
> NOFORMAT, NOINIT, NAME = N'ASEEDA-Differential Database Backup', SKIP,
> NOREWIND, NOUNLOAD, STATS = 10
> GO
>
>
> When I execute either file with SQL Server Management Studio closed; no backup
> happens, SQL Server Management Studio opens, but does not connect to any
> objects.
>
>
> When I execute either file with SQL Server Management Studio open; the text of
> the script file opens in the Query window but does not execute. If I click on
> Execute, the backup runs as expected. This makes me think that there's nothing
> wrong with the query, but it's somehow failing to connect. I'm stumped.
>
> From SQL Server Configuration Manager, the running services are;
> SQL Server and
> SQL Server Browser
> (on the other computer where these .sql files do execute correctly there is one
> other service running, "SQL Full-text Filter Daemon Launcher"
>
>
>
> This is the information from SQL Server Management Studio - About:
>
> Microsoft SQL Server Management Studio 10.50.1600.1
> Microsoft Data Access Components (MDAC) 6.1.7601.17514
> Microsoft MSXML 3.0 4.0 5.0 6.0
> Microsoft Internet Explorer 8.0.7601.17514
> Microsoft .NET Framework 2.0.50727.5446
> Operating System 6.1.7601
>
>
>
> Thanks
> John
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
Bls: [belajar-access] Congrats to Bang Haer, success renewal MVP
Dari: Aksan Kurdin <aksan.kurdin@gmail.com>
Kepada: belajar-access@yahoogroups.com
Terkirim: Jum, 1 Juli, 2011 07:40:19
Judul: [belajar-access] Congrats to Bang Haer, success renewal MVP
Sukses Bang, semoga terus berkiprah memajukan access, khususnya untuk komunitas access di Indonesia.
Aksan Kurdin
ps. Bisa dilihat di: http://geeks.netindonesia.net/blogs/darmawan/archive/2011/07/01/congratulation-to-all-renew-mvps.aspx
[belajar-access] Eksperimen Access Vs Mysql [1 Attachment]
Dear warga Milis,,,
Bermula dari obrolan saya dari Mas Aksan untuk melakukan eksperimen sendiri, akhirnya singkat kata saya mendapatkan ide dari situ utk melakukan eksperimen2 lain (Thanx Mas Aksan… )
Saya buat suatu BE (db2.mdb) dgn mengambil Northwind sbg sumber datanya, dengan bantuan Querry Append akhirnya saya bisa membuat data yg banyak sekali pada sebuah Table Order, hingga mencapai 215000 lebih record, Untuk meringkas cerita saya, terciptalah 88 Tabel Northwind di BE db2.mdb. Saya namakan BE ini BE1 sehingga :
BE1 = db2.mdb (berisi 88 Tabel, pada salah satu Tabel order mempunyai 215040 record)
Kemudian BE1 (db2.mdb) tsb saya transfer ke MySql, singkatnya sehingga menjadi :
BE2 = db2_MySql (adalah DB MySql yang berisi 88 Tabel hasil ekspor db2.mdb, pada salah satu Tabel order mempunyai 215040 record)
kemudian saya buat 2 FE utk melink masing2 BE diatas, yaitu :
FE1 = NWLink_Mdb.mdb.(berisi 88 Link Tabel dari BE1) --- Link Tabel to mdb type.
FE2 = NWLink_MySql.mdb (berisi 88 Link Tabel dari BE2) --- Link Tabel to MySql type (ODBC)
pada masing2 FE saya buat 2 Form, yg pertama Form "Order3" yaitu untuk menampung data pada Tabel Order3 yang berisi 215040 record.
Kemudian Form kedua yaitu Form "Query3" yang menampung data dari Query3 yaitu hasil SELECT tabel2 : Order3, Customer3, Employee3, Shipper3 sehingga akhirnya pada Query3 tsb berisi 215040 record dan 45 Field…(pokoknya saya coba se"brutal" mungkin deh …).
Berikut hasil eksperimen2 saya ( LT = Link Tabel to…)
1. Experimen Besar File FE :
FE1 (LT to mdb), besar file 400 KB, sedangkan FE2 (LT to Mysql) besar file 2,39 MB atau 6 kali FE1.
2. Experimen kecepatan buka masing2 FE :
Saya gak punya stopwatch, tapi percayalah… FE1 (LT to Mdb) lebih cepat (berkali2 percobaan).
Hanya saja disini tdk ada perbedaan mencolok, pokoknya tetep sama2 cepat Cuma FE1 lebih cepat (sekejap malah).
Hal yg menarik dari hasil eksperimen saya ini adalah saya betul yakin sekarang Link Tabel hanya bersifat koneksi tidak meload data dan tidak membuat Tabel temporary pada waktu File dibuka. Jadi dengan sangat bahagia saya berpendapat Link Tabel oke punya deh…(mudah lagi … hehehe).
3.Eksperimen kecepatan buka Form yang berisi record2:
Langsung saja saya pada bagian yg terbrutal pada percobaan ini yaitu membuka Form "Query3" pada masing2 FE. (Query3 sbg Source Form "Query3" berisi 215040 record dan 45 Field), hasilnya :
Form "Query3" di FE1 (LT to mdb) kecepatan : sekejap ! (tdk ada waktu tunggu)
Form "Query3" di FE2 (LT to Mysql) kecepatan ….. ??? komputer hang setiap kali coba dibuka..!
Dari ketiga eksperimen saya diatas mungkin tidak salah kalo saya berpendapat FE Access lebih baik gunakan BE Access juga, entah kalo FE lain.
Mohon para master2 bisa memberi comment atas eksperimen2 saya ini, terutama dimana letak kekurangan eksperimen saya,,,sehingga saya mungkin salah mengambil kesimpulan.
Masalah model transfer data tidak saya lakukan disini, Mas Aksan sudah melakukannya dan bisa dilihat hasilnya pada email2 sblm ini…(kalo hal ini memang Access kalah), kelemahannya adalah Access mengirim semua data baru difilter di FE.
Untuk rekan2 bisa mencoba2 sendiri, ini saya sertakan semua file2 yg saya buat kecuali BE2…mohon di semuanya extract di MyDocument\Downloads
Note : Please Master bisa comment demi hasil kesimpulan yang benar setidaknya buat saya ...
Regards
Hendra
Saya kesulitan menuliskan eksperiman saya disini , jadi saya sertakan saja BE1 dan FE1 I attachment, saya yakin rekan2 akan lebih mengerti dari pada saya jelaskan disini.
Attachment(s) from Hendra Agestha Hamid
1 of 1 File(s)
Re: [belajar-access] Congrats to Bang Haer, success renewal MVP
Oma aksan kapan neh...
On 01/07/2011 07:40, Aksan Kurdin wrote:
Sukses Bang, semoga terus berkiprah memajukan access, khususnya untuk komunitas access di Indonesia.
Aksan Kurdin
ps. Bisa dilihat di: http://geeks.netindonesia.net/blogs/darmawan/archive/2011/07/01/congratulation-to-all-renew-mvps.aspx