Offline Terminal DataBase + Custom Table #4

Anybody does not have idea?

"Math" wrote:

> Hi, 
> 
> The table name is : ItemPrix , ItemPrixRemise.
> The server name is : gesboutm
> The database name is : RMS_STORE2
> The offline srever is : aures_1542
> The database offline name is : RMS_OFF
> 
> Thanks
> 
> Math
> 
> "Akber Alwani" wrote:
> 
> > HI Math,
> > 
> > Off course MS not take care what you have added or deleted your own as this 
> > custom table is your own creation so there is nothing or not talk how it goes 
> > by automatically but do do if you want. I think if you know the merge or 
> > transactional replication technology then you can do so. tell me the table 
> > name I will create the sample script for you and sent it to you so you can 
> > deploy this to your server, also send me the name of your actual server and 
> > offline machine too.
> > 
> > "Math" wrote:
> > 
> > > 
> > > Hello,
> > > I use the terminal database offline withe my POS (rms 1.3R).
> > > I create my database with Pos administrator, specifie the server for offline 
> > > database.
> > > When I generate Z report , the database synchronize items and customers. But 
> > > my problem is : I have a custom Table with Price connected to the Item's 
> > > table, and this table doesn't synchronize with the offline database.
> > > 
> > > Is it a solution to my problem ? or a tips ? 
> > > 
> > > Thanks
> > > 
> > > Sorry for my english.
> > > 
> > > Math 

0
Math (30)
6/12/2007 2:56:00 PM
pos 14173 articles. 0 followers. Follow

3 Replies
576 Views

Similar Articles

[PageSpeed] 12

Hi Math, This is akber as promosie please have this script saved on the any 
notepad and name is mergedata.sql
-- Enabling the replication database
use master
GO

> The table name is : ItemPrix , ItemPrixRemise.
> The server name is : gesboutm
> The database name is : RMS_STORE2
> The offline srever is : aures_1542
> The database offline name is : RMS_OFF


exec sp_replicationdboption @dbname = N'gesboutm', @optname = N'merge 
publish', @value = N'true'
GO

use [gesboutm]
GO

-- Adding the merge publication
exec sp_addmergepublication @publication = N'gesboutm_Repl', @description = 
N'Merge publication of gesboutm database from Publisher RMS_STORE2.', 
@retention = 0, @sync_mode = 

N'character', @allow_push = N'true', @allow_pull = N'true', @allow_anonymous 
= N'true', @enabled_for_internet = N'false', @centralized_conflicts = 
N'true', @dynamic_filters = 

N'false', @snapshot_in_defaultfolder = N'true', @compress_snapshot = 
N'false', @ftp_port = 21, @ftp_login = N'anonymous', @conflict_retention = 
14, @keep_partition_changes = 

N'false', @allow_subscription_copy = N'false', @allow_synctoalternate = 
N'false', @add_to_active_directory = N'false', @max_concurrent_merge = 0, 
@max_concurrent_dynamic_snapshots 

= 0
exec sp_addpublication_snapshot @publication = 
N'gesboutm_Repl',@frequency_type = 4, @frequency_interval = 1, 
@frequency_relative_interval = 1, @frequency_recurrence_factor = 0, 

@frequency_subday = 1, @frequency_subday_interval = 5, @active_start_date = 
0, @active_end_date = 0, @active_start_time_of_day = 500, 
@active_end_time_of_day = 235959, 

@snapshot_job_name = N'RMS_STORE2-gesboutm-gesboutm_Repl-1'
GO

exec sp_grant_publication_access @publication = N'gesboutm_Repl', @login = 
N'BUILTIN\Administrators'
GO
exec sp_grant_publication_access @publication = N'gesboutm_Repl', @login = 
N'distributor_admin'
GO
exec sp_grant_publication_access @publication = N'gesboutm_Repl', @login = 
N'sa'
GO

-- Adding the merge articles
exec sp_addmergearticle @publication = N'gesboutm_Repl', @article = 
N'ItemPrix', @source_owner = N'dbo', @source_object = N'ItemPrix', @type = 
N'table', @description = null, 

@column_tracking = N'true', @pre_creation_cmd = N'drop', @creation_script = 
null, @schema_option = 0x000000000000CFF1, @article_resolver = null, 
@subset_filterclause = null, 

@vertical_partition = N'true', @destination_owner = N'dbo', 
@auto_identity_range = N'false', @verify_resolver_signature = 0, 
@allow_interactive_resolver = N'false', 

@fast_multicol_updateproc = N'true', @check_permissions = 0
GO

-- Adding the article's partition column(s)
exec sp_mergearticlecolumn @publication = N'gesboutm_Repl', @article = 
N'ItemPrix', @column = N'XXXXX', @operation = N'add'
GO

-- Repeat the above for all columsn in tables

-- Adding the merge articles
exec sp_addmergearticle @publication = N'gesboutm_Repl', @article = 
N'ItemPrixRemise', @source_owner = N'dbo', @source_object = N'Voucher', @type 
= N'table', @description = null, 

@column_tracking = N'true', @pre_creation_cmd = N'drop', @creation_script = 
null, @schema_option = 0x000000000000CFF1, @article_resolver = null, 
@subset_filterclause = null, 

@vertical_partition = N'true', @destination_owner = N'dbo', 
@auto_identity_range = N'false', @verify_resolver_signature = 0, 
@allow_interactive_resolver = N'false', 

@fast_multicol_updateproc = N'true', @check_permissions = 0
GO

exec sp_mergearticlecolumn @publication = N'gesboutm_Repl', @article = 
N'ItemPrixRemise', @column = N'XXXXX', @operation = N'add'
GO

-- Repeat the above for all columsn in tables

-- Adding the merge subscription
exec sp_addmergesubscription @publication = N'gesboutm_Repl', @subscriber = 
N'AURES_1542', @subscriber_db = N'RMS_OFF', @subscription_type = N'push', 
@subscriber_type = N'local', 

@subscription_priority = 0.000000, @sync_type = N'none', @frequency_type = 
4, @frequency_interval = 1, @frequency_relative_interval = 1, 
@frequency_recurrence_factor = 0, 

@frequency_subday = 8, @frequency_subday_interval = 1, @active_start_date = 
0, @active_end_date = 0, @active_start_time_of_day = 0, 
@active_end_time_of_day = 235959, 

@enabled_for_syncmgr = N'false', @offloadagent = 0, 
@use_interactive_resolver = N'false'
GO


Also remember above I just added the example of one column of each tables 
you send to me. there are some other stuff can be done also. I better suggest 
that I have remote client RDP and will connect to your server to serve you. 
if you want.

Let me know if require any more help.

"Math" wrote:

> Anybody does not have idea?
> 
> "Math" wrote:
> 
> > Hi, 
> > 
> > The table name is : ItemPrix , ItemPrixRemise.
> > The server name is : gesboutm
> > The database name is : RMS_STORE2
> > The offline srever is : aures_1542
> > The database offline name is : RMS_OFF
> > 
> > Thanks
> > 
> > Math
> > 
> > "Akber Alwani" wrote:
> > 
> > > HI Math,
> > > 
> > > Off course MS not take care what you have added or deleted your own as this 
> > > custom table is your own creation so there is nothing or not talk how it goes 
> > > by automatically but do do if you want. I think if you know the merge or 
> > > transactional replication technology then you can do so. tell me the table 
> > > name I will create the sample script for you and sent it to you so you can 
> > > deploy this to your server, also send me the name of your actual server and 
> > > offline machine too.
> > > 
> > > "Math" wrote:
> > > 
> > > > 
> > > > Hello,
> > > > I use the terminal database offline withe my POS (rms 1.3R).
> > > > I create my database with Pos administrator, specifie the server for offline 
> > > > database.
> > > > When I generate Z report , the database synchronize items and customers. But 
> > > > my problem is : I have a custom Table with Price connected to the Item's 
> > > > table, and this table doesn't synchronize with the offline database.
> > > > 
> > > > Is it a solution to my problem ? or a tips ? 
> > > > 
> > > > Thanks
> > > > 
> > > > Sorry for my english.
> > > > 
> > > > Math 
> 
0
AkberAlwani (916)
6/13/2007 4:46:00 AM
I thank you, I suspected that it was necessary to use a publication but I 
was not on.

I used your script and that works very decently after some modification.  

Thank you.  

Math


"Akber Alwani" wrote:

> Hi Math, This is akber as promosie please have this script saved on the any 
> notepad and name is mergedata.sql
> -- Enabling the replication database
> use master
> GO
> 
> > The table name is : ItemPrix , ItemPrixRemise.
> > The server name is : gesboutm
> > The database name is : RMS_STORE2
> > The offline srever is : aures_1542
> > The database offline name is : RMS_OFF
> 
> 
> exec sp_replicationdboption @dbname = N'gesboutm', @optname = N'merge 
> publish', @value = N'true'
> GO
> 
> use [gesboutm]
> GO
> 
> -- Adding the merge publication
> exec sp_addmergepublication @publication = N'gesboutm_Repl', @description = 
> N'Merge publication of gesboutm database from Publisher RMS_STORE2.', 
> @retention = 0, @sync_mode = 
> 
> N'character', @allow_push = N'true', @allow_pull = N'true', @allow_anonymous 
> = N'true', @enabled_for_internet = N'false', @centralized_conflicts = 
> N'true', @dynamic_filters = 
> 
> N'false', @snapshot_in_defaultfolder = N'true', @compress_snapshot = 
> N'false', @ftp_port = 21, @ftp_login = N'anonymous', @conflict_retention = 
> 14, @keep_partition_changes = 
> 
> N'false', @allow_subscription_copy = N'false', @allow_synctoalternate = 
> N'false', @add_to_active_directory = N'false', @max_concurrent_merge = 0, 
> @max_concurrent_dynamic_snapshots 
> 
> = 0
> exec sp_addpublication_snapshot @publication = 
> N'gesboutm_Repl',@frequency_type = 4, @frequency_interval = 1, 
> @frequency_relative_interval = 1, @frequency_recurrence_factor = 0, 
> 
> @frequency_subday = 1, @frequency_subday_interval = 5, @active_start_date = 
> 0, @active_end_date = 0, @active_start_time_of_day = 500, 
> @active_end_time_of_day = 235959, 
> 
> @snapshot_job_name = N'RMS_STORE2-gesboutm-gesboutm_Repl-1'
> GO
> 
> exec sp_grant_publication_access @publication = N'gesboutm_Repl', @login = 
> N'BUILTIN\Administrators'
> GO
> exec sp_grant_publication_access @publication = N'gesboutm_Repl', @login = 
> N'distributor_admin'
> GO
> exec sp_grant_publication_access @publication = N'gesboutm_Repl', @login = 
> N'sa'
> GO
> 
> -- Adding the merge articles
> exec sp_addmergearticle @publication = N'gesboutm_Repl', @article = 
> N'ItemPrix', @source_owner = N'dbo', @source_object = N'ItemPrix', @type = 
> N'table', @description = null, 
> 
> @column_tracking = N'true', @pre_creation_cmd = N'drop', @creation_script = 
> null, @schema_option = 0x000000000000CFF1, @article_resolver = null, 
> @subset_filterclause = null, 
> 
> @vertical_partition = N'true', @destination_owner = N'dbo', 
> @auto_identity_range = N'false', @verify_resolver_signature = 0, 
> @allow_interactive_resolver = N'false', 
> 
> @fast_multicol_updateproc = N'true', @check_permissions = 0
> GO
> 
> -- Adding the article's partition column(s)
> exec sp_mergearticlecolumn @publication = N'gesboutm_Repl', @article = 
> N'ItemPrix', @column = N'XXXXX', @operation = N'add'
> GO
> 
> -- Repeat the above for all columsn in tables
> 
> -- Adding the merge articles
> exec sp_addmergearticle @publication = N'gesboutm_Repl', @article = 
> N'ItemPrixRemise', @source_owner = N'dbo', @source_object = N'Voucher', @type 
> = N'table', @description = null, 
> 
> @column_tracking = N'true', @pre_creation_cmd = N'drop', @creation_script = 
> null, @schema_option = 0x000000000000CFF1, @article_resolver = null, 
> @subset_filterclause = null, 
> 
> @vertical_partition = N'true', @destination_owner = N'dbo', 
> @auto_identity_range = N'false', @verify_resolver_signature = 0, 
> @allow_interactive_resolver = N'false', 
> 
> @fast_multicol_updateproc = N'true', @check_permissions = 0
> GO
> 
> exec sp_mergearticlecolumn @publication = N'gesboutm_Repl', @article = 
> N'ItemPrixRemise', @column = N'XXXXX', @operation = N'add'
> GO
> 
> -- Repeat the above for all columsn in tables
> 
> -- Adding the merge subscription
> exec sp_addmergesubscription @publication = N'gesboutm_Repl', @subscriber = 
> N'AURES_1542', @subscriber_db = N'RMS_OFF', @subscription_type = N'push', 
> @subscriber_type = N'local', 
> 
> @subscription_priority = 0.000000, @sync_type = N'none', @frequency_type = 
> 4, @frequency_interval = 1, @frequency_relative_interval = 1, 
> @frequency_recurrence_factor = 0, 
> 
> @frequency_subday = 8, @frequency_subday_interval = 1, @active_start_date = 
> 0, @active_end_date = 0, @active_start_time_of_day = 0, 
> @active_end_time_of_day = 235959, 
> 
> @enabled_for_syncmgr = N'false', @offloadagent = 0, 
> @use_interactive_resolver = N'false'
> GO
> 
> 
> Also remember above I just added the example of one column of each tables 
> you send to me. there are some other stuff can be done also. I better suggest 
> that I have remote client RDP and will connect to your server to serve you. 
> if you want.
> 
> Let me know if require any more help.
> 
> "Math" wrote:
> 
> > Anybody does not have idea?
> > 
> > "Math" wrote:
> > 
> > > Hi, 
> > > 
> > > The table name is : ItemPrix , ItemPrixRemise.
> > > The server name is : gesboutm
> > > The database name is : RMS_STORE2
> > > The offline srever is : aures_1542
> > > The database offline name is : RMS_OFF
> > > 
> > > Thanks
> > > 
> > > Math
> > > 
> > > "Akber Alwani" wrote:
> > > 
> > > > HI Math,
> > > > 
> > > > Off course MS not take care what you have added or deleted your own as this 
> > > > custom table is your own creation so there is nothing or not talk how it goes 
> > > > by automatically but do do if you want. I think if you know the merge or 
> > > > transactional replication technology then you can do so. tell me the table 
> > > > name I will create the sample script for you and sent it to you so you can 
> > > > deploy this to your server, also send me the name of your actual server and 
> > > > offline machine too.
> > > > 
> > > > "Math" wrote:
> > > > 
> > > > > 
> > > > > Hello,
> > > > > I use the terminal database offline withe my POS (rms 1.3R).
> > > > > I create my database with Pos administrator, specifie the server for offline 
> > > > > database.
> > > > > When I generate Z report , the database synchronize items and customers. But 
> > > > > my problem is : I have a custom Table with Price connected to the Item's 
> > > > > table, and this table doesn't synchronize with the offline database.
> > > > > 
> > > > > Is it a solution to my problem ? or a tips ? 
> > > > > 
> > > > > Thanks
> > > > > 
> > > > > Sorry for my english.
> > > > > 
> > > > > Math 
> > 
0
Math (30)
6/13/2007 8:47:01 AM
Thanks Math, I appreicate if you rate on net me please.

"Math" wrote:

> 
> I thank you, I suspected that it was necessary to use a publication but I 
> was not on.
> 
> I used your script and that works very decently after some modification.  
> 
> Thank you.  
> 
> Math
> 
> 
> "Akber Alwani" wrote:
> 
> > Hi Math, This is akber as promosie please have this script saved on the any 
> > notepad and name is mergedata.sql
> > -- Enabling the replication database
> > use master
> > GO
> > 
> > > The table name is : ItemPrix , ItemPrixRemise.
> > > The server name is : gesboutm
> > > The database name is : RMS_STORE2
> > > The offline srever is : aures_1542
> > > The database offline name is : RMS_OFF
> > 
> > 
> > exec sp_replicationdboption @dbname = N'gesboutm', @optname = N'merge 
> > publish', @value = N'true'
> > GO
> > 
> > use [gesboutm]
> > GO
> > 
> > -- Adding the merge publication
> > exec sp_addmergepublication @publication = N'gesboutm_Repl', @description = 
> > N'Merge publication of gesboutm database from Publisher RMS_STORE2.', 
> > @retention = 0, @sync_mode = 
> > 
> > N'character', @allow_push = N'true', @allow_pull = N'true', @allow_anonymous 
> > = N'true', @enabled_for_internet = N'false', @centralized_conflicts = 
> > N'true', @dynamic_filters = 
> > 
> > N'false', @snapshot_in_defaultfolder = N'true', @compress_snapshot = 
> > N'false', @ftp_port = 21, @ftp_login = N'anonymous', @conflict_retention = 
> > 14, @keep_partition_changes = 
> > 
> > N'false', @allow_subscription_copy = N'false', @allow_synctoalternate = 
> > N'false', @add_to_active_directory = N'false', @max_concurrent_merge = 0, 
> > @max_concurrent_dynamic_snapshots 
> > 
> > = 0
> > exec sp_addpublication_snapshot @publication = 
> > N'gesboutm_Repl',@frequency_type = 4, @frequency_interval = 1, 
> > @frequency_relative_interval = 1, @frequency_recurrence_factor = 0, 
> > 
> > @frequency_subday = 1, @frequency_subday_interval = 5, @active_start_date = 
> > 0, @active_end_date = 0, @active_start_time_of_day = 500, 
> > @active_end_time_of_day = 235959, 
> > 
> > @snapshot_job_name = N'RMS_STORE2-gesboutm-gesboutm_Repl-1'
> > GO
> > 
> > exec sp_grant_publication_access @publication = N'gesboutm_Repl', @login = 
> > N'BUILTIN\Administrators'
> > GO
> > exec sp_grant_publication_access @publication = N'gesboutm_Repl', @login = 
> > N'distributor_admin'
> > GO
> > exec sp_grant_publication_access @publication = N'gesboutm_Repl', @login = 
> > N'sa'
> > GO
> > 
> > -- Adding the merge articles
> > exec sp_addmergearticle @publication = N'gesboutm_Repl', @article = 
> > N'ItemPrix', @source_owner = N'dbo', @source_object = N'ItemPrix', @type = 
> > N'table', @description = null, 
> > 
> > @column_tracking = N'true', @pre_creation_cmd = N'drop', @creation_script = 
> > null, @schema_option = 0x000000000000CFF1, @article_resolver = null, 
> > @subset_filterclause = null, 
> > 
> > @vertical_partition = N'true', @destination_owner = N'dbo', 
> > @auto_identity_range = N'false', @verify_resolver_signature = 0, 
> > @allow_interactive_resolver = N'false', 
> > 
> > @fast_multicol_updateproc = N'true', @check_permissions = 0
> > GO
> > 
> > -- Adding the article's partition column(s)
> > exec sp_mergearticlecolumn @publication = N'gesboutm_Repl', @article = 
> > N'ItemPrix', @column = N'XXXXX', @operation = N'add'
> > GO
> > 
> > -- Repeat the above for all columsn in tables
> > 
> > -- Adding the merge articles
> > exec sp_addmergearticle @publication = N'gesboutm_Repl', @article = 
> > N'ItemPrixRemise', @source_owner = N'dbo', @source_object = N'Voucher', @type 
> > = N'table', @description = null, 
> > 
> > @column_tracking = N'true', @pre_creation_cmd = N'drop', @creation_script = 
> > null, @schema_option = 0x000000000000CFF1, @article_resolver = null, 
> > @subset_filterclause = null, 
> > 
> > @vertical_partition = N'true', @destination_owner = N'dbo', 
> > @auto_identity_range = N'false', @verify_resolver_signature = 0, 
> > @allow_interactive_resolver = N'false', 
> > 
> > @fast_multicol_updateproc = N'true', @check_permissions = 0
> > GO
> > 
> > exec sp_mergearticlecolumn @publication = N'gesboutm_Repl', @article = 
> > N'ItemPrixRemise', @column = N'XXXXX', @operation = N'add'
> > GO
> > 
> > -- Repeat the above for all columsn in tables
> > 
> > -- Adding the merge subscription
> > exec sp_addmergesubscription @publication = N'gesboutm_Repl', @subscriber = 
> > N'AURES_1542', @subscriber_db = N'RMS_OFF', @subscription_type = N'push', 
> > @subscriber_type = N'local', 
> > 
> > @subscription_priority = 0.000000, @sync_type = N'none', @frequency_type = 
> > 4, @frequency_interval = 1, @frequency_relative_interval = 1, 
> > @frequency_recurrence_factor = 0, 
> > 
> > @frequency_subday = 8, @frequency_subday_interval = 1, @active_start_date = 
> > 0, @active_end_date = 0, @active_start_time_of_day = 0, 
> > @active_end_time_of_day = 235959, 
> > 
> > @enabled_for_syncmgr = N'false', @offloadagent = 0, 
> > @use_interactive_resolver = N'false'
> > GO
> > 
> > 
> > Also remember above I just added the example of one column of each tables 
> > you send to me. there are some other stuff can be done also. I better suggest 
> > that I have remote client RDP and will connect to your server to serve you. 
> > if you want.
> > 
> > Let me know if require any more help.
> > 
> > "Math" wrote:
> > 
> > > Anybody does not have idea?
> > > 
> > > "Math" wrote:
> > > 
> > > > Hi, 
> > > > 
> > > > The table name is : ItemPrix , ItemPrixRemise.
> > > > The server name is : gesboutm
> > > > The database name is : RMS_STORE2
> > > > The offline srever is : aures_1542
> > > > The database offline name is : RMS_OFF
> > > > 
> > > > Thanks
> > > > 
> > > > Math
> > > > 
> > > > "Akber Alwani" wrote:
> > > > 
> > > > > HI Math,
> > > > > 
> > > > > Off course MS not take care what you have added or deleted your own as this 
> > > > > custom table is your own creation so there is nothing or not talk how it goes 
> > > > > by automatically but do do if you want. I think if you know the merge or 
> > > > > transactional replication technology then you can do so. tell me the table 
> > > > > name I will create the sample script for you and sent it to you so you can 
> > > > > deploy this to your server, also send me the name of your actual server and 
> > > > > offline machine too.
> > > > > 
> > > > > "Math" wrote:
> > > > > 
> > > > > > 
> > > > > > Hello,
> > > > > > I use the terminal database offline withe my POS (rms 1.3R).
> > > > > > I create my database with Pos administrator, specifie the server for offline 
> > > > > > database.
> > > > > > When I generate Z report , the database synchronize items and customers. But 
> > > > > > my problem is : I have a custom Table with Price connected to the Item's 
> > > > > > table, and this table doesn't synchronize with the offline database.
> > > > > > 
> > > > > > Is it a solution to my problem ? or a tips ? 
> > > > > > 
> > > > > > Thanks
> > > > > > 
> > > > > > Sorry for my english.
> > > > > > 
> > > > > > Math 
> > > 
0
AkberAlwani (916)
6/13/2007 9:07:01 AM
Reply:

Similar Artilces:

CRM 4.0 Report Deployment
Hi When I deploy a custom report (through Web UI) and run it, no data is displayed. The report header, footer, etc, display, but there is no data. To simplify the problem I created a very simple report with no parameters, which selects all from filteredsystemuser, and the problem was the same. This is in a test VPC, the whole environment is contained in the VPC. I am developing/publishing/viewing as the CRM administrator. The steps I took were: - Created a new report in Business Intelligence Development Studio using Wizard (installed in VPC) - Created a new DataSet called dsTest with a new D...

Custom reports/queries across multiple companies in Business Porta
Is there any way to create a custom query or report that can be run inside Business Portal and which pulls figures from multiple Great Plains companies. Thank you. A View can be constructed in one database that pulls data from other databases. This view can then be used as the source for reports in tools like Crystal etc -- Richard L. Whaley Author / Consultant / MVP Documentation for Software Users Get our Free Tips and Tricks Newsletter and check out our books at http://www.AccoladePublications.com "KT" wrote: > Is there any way to create a custom query or report th...

Custom entities and attributes Off Line
Hi, Just wanted to confirm that all customizations (like new attributes and entities) can also be taken off line with the lap top edition of the outlook client... Pl advice... regards Hi, Yes, you can access custom entities and attributes when you are offline on the Laptop client. Please remember to specify what data you want to sync in Local Data Groups in the Outlook client. HTH, Niths "S" wrote: > Hi, > > Just wanted to confirm that all customizations (like new attributes and > entities) can also be taken off line with the lap top edition of the outlook ...

Can I make a database in Word with Excel Data
I know this may be a "DUH" question, but... I am making a list of area dentists that I have copied and pasted of of the Dex website into Excel. I am wondering if I can take this inf and make a database in Word for printing address labels. Does anyon know if this can be done, and HOW?:confused -- Myn77 ----------------------------------------------------------------------- Myn777's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2958 View this thread: http://www.excelforum.com/showthread.php?threadid=49283 For help on Word mail merge using Excel as the...

Splitting a database
Hi, I have broken my database into several stages. I have implemented the first stage and this is simply the database (with basic features) on a central computer and a shortcut added to each user's computer. I know this is quite risky but at this stage only one person is cupturing and editing the data and the rest is viewing information and printing reports. I am still building on new features of the database and this would include adding more fields to some tables. 1 - Could i now split my database and give each user a FE, given the fact that i will still be adding and removin...

my case it online , it Show offline
When I open Messenger and put my case it online , it Show offline to my friends .. not online .. What to do! -- free9 http://webim.live.my/ What I did was sign in on that website as well as the regular windows live (if you have the newest windows live you can sign on in two places). So everyone could see me as online again, and I could use windows live as I normally do with the web messenger running in the background. I hope we get a solution soon. free9 wrote: my case it online , it Show offline 22-Mar-10 When I open Messenger and put my case it online , i...

query with inline dummy table
Is there a way in Access to create a query that contains the table records within the query itself? I want to avoid creating a dummy table and just use values within the query definition. I was thinking about using syntax similar to the insert into statement I would use to populate the dummy table, but I'm not sure if I have a syntax problem or I'm trying to solve an impossible problem. The query I'm thinking of might look something like this: select * from values("test"); -or- select * from ( ("1/1/07","2/1/07","3/1/07","4/1/07&qu...

workaround for non normalized table
I've inherited a database that relies heavily on a non normalized table. Until I can convince the general manager that I can normalize the data without losing any records, I've got to have a workaround for certain situations. Namely, I need to ensure that data is not being badly reproduced at various stages of our operations. I would therefore like to reference the information directly from the main table in order to populate certain information in related tables. In this case, the main table uses [Order Number] as its primary key, and ties it to a bunch of information like ...

Fix: Visio 2007 x64 Hangs During Database model Creation
I'm posting this here, so hopefully others will have an easier time finding the solution than I did... On Windows XP (x64) Visio 2007 hangs when I try to create a new database model diagram. Performing a "repair" doesn't help at all. For some reason, turning off the "Print Spooler" Service makes things work just fine. I have no idea why this is, but it did the trick. -- Chris Mullins, MCSD.NET, MCPD:Enterprise, MVP C# http://www.coversant.net/blogs/cmullins Hi Chris, Thanks for sharing this information. Do you see the hang when creating other new draw...

Error in code exportin tables to excel
I'm tryin to export a table to excel with the code: Private Sub Command4_Click() On Error GoTo Err_Command0_Click Dim stDocName As String stDocName = "F01_UT" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, F01_UT, "C:\TRY\Tbls", True Exit_Command0_Click: Exit Sub Err_Command0_Click: MsgBox Err.Description Resume Exit_Command0_Click End Sub However, Access displays the message: Compile error : Syntax error What I'm doing wrong? If I want to export more tablas do I have to write more lines (DoCmd.TransferSpreadsheet acExport, acSpr...

Field service table structure and field definitions
The 9 SDK does not reference or define the fields or tables for the Field service component. Where can I find this information? I need to move RMA into a data warehouse and am having significant trouble identifying the data flows. Thanks, Will You may want to contact I.B.I.S. They wrote the application. -- Charles Allen, MVP "WS" wrote: > The 9 SDK does not reference or define the fields or tables for the Field > service component. Where can I find this information? I need to move RMA > into a data warehouse and am having significant trouble identifying th...

VBA code to hide all the tables on form open
I don't want people to use a blank mdb to import my tables. I manually hide them all. However, after running the macro to delete all records and import from .txt, the table become unhide. I do the importation on daily basis. I posted to macro newsgroup and asked way to hide table after importation action macro but got no answer. Maybe it cannot be done in macro? If so, I need VBA code to hide all the tables on form open. Thanks. Hiding your tables won't prevent people from being able to import them into a blank mdb. All they have to do is ensure that they've set the datab...

Free shipping for selected customers
Our Store Ops system is setup to always charge shipping on all orders for all customers (the "Automatic shipping" option in Store Ops configuration is checked). For 99% of our customers, this is correct. However, there are a select group of employees who work in our warehouse. They do not need the garments shipped to them, so they should not automatically be charged shipping. There are also some high-end customers who we normally provide free shipping as a courtesy. Our system is also setup to received orders from a website (using a custom web interface). It can feed the cu...

Importing to a contact subfolder with that has a custom form
I am using a custom form for a subfolder under contacts. When I use the import wizard to import a comma deliniated DOS file the resulting records are in the default contact form rather than the custom form. When I manually add a contact it correctly chooses the custom form. Any help will be welcomed! You can re-apply the form to the items that don't have it - methods depend on your version of Outlook. Bob White wrote: > I am using a custom form for a subfolder under contacts. > When I use the import wizard to import a comma deliniated > DOS file the resulting records are i...

Please help with New Database Query
Newbie to New Database Query - Can you change a spreadsheet to a table if so how? I have a lot of spreadsheets that I would like to work with in New Database Query. Can this be done. Any help will be greatly appreciated. In general, if you select a range and give it a name....MS Query will recognize it as a data source: Example for data in Cells A1:Z500, with column headings (EmpID, FName, Lname, etc): Select A1:Z500 In the Names box (just above the Col_A heading) type rngMyData1 Press [Enter] Next, save your workbook. Then...Data>Import External Data>New Database Query When y...

business cards #4
Hi, I'm using Microsoft Publisher 2000 for the first time. I have made up some business cards and am about to cut them out. I know from other programmes that I have used before that you can display cutting guidelines for using a guillotine. Does anyone know if this is possible with Microsoft Publisher. Any help greatly appreciated. Thanks, Debbie. Don't use perforated card stock? -- Don -------- Vancouver, USA - One of the great cities in one of the 45+ countries in the Americas! "Debbie" <anonymous@discussions.microsoft.com> wrote in message news:1906201c4...

dynamically filtered pivot table
I'm trying to make a pivot table that will dynamically hide a section o its contents based on a boolean operator the user can set. Becaus this boolean is used in several places, I don't want to require th user to manually set the visibility parameters for the pivot table. It seems like the only way to do this effectively is to have th booleans set by a button, and have the button not only toggle th boolean, but also change the visibility in the pivot table. here's the code i've tried: Sub ToggleButton1_Click() If ToggleButton1.Caption = "Include" Then 'C...

Exporting a table from Access 2003 to Excel 2007
I am trying to export a table from Access 2003 with more than 100,000 records into Excel 2007 and am not having any luck. I do not find the 2007 file extension in the drop down and choosing the latest version only exports part of the table. Any thoughts on whether this is possible to do? -- Carol Hi Carol, This is even hard to do with Excel 2007. You won't be able to do it directly with Excel 2003. You could export the file as a comma separated value with a csv suffix. By default Excel usually opens csv files. However you may lose formatting and other stuff. I ju...

Permissions #4
I have recently upgraded to exchange 2003 and have had few problems. However one problem that crops up is when a user replies to an e-mail group external to the organisation. The server post an undeliverable saying that the user does not have permission to send to external group. If the user tries again it usually will go through. I cant find anything on the server which seems relevant to this problem. ...

Are there functions/Or Events that are called automatically when the database file first opens and When it closes?
All, I'm assuming its "Public Function init_something()" but I can't seem to find a reference to the correct syntax. I'm using Access 2007. Basically what I'm trying to do is initialize a list of global variables and I can't seem to figure out how to do it. Option Compare Database Public VariableName As String 'Call Init - Will throw an error 'VariableName = "Hello World" - Will throw an error Option Explicit Public Function Init() VariableName = "Hello World" End Function Private Sub btName_Click() ...

row spacing in custom drawn CListCtrl
I have noticed that row spacing in a custom drawn (not owner drawn) CListCtrl when run on Vista or Server 2008 is about 20% larger than on XP. Is there a way to reduce this spacing? Thanks in advance, Julijan Probably not easily; Vista uses a different font than XP, so you are probably seeing artifacts of the different font size (assuming that the Vista machine is running in an absoutely identical configuration to the XP machine, same size screen, same resolution, same default font name, etc.; if not, then there is no reason to expect they will be "the same", ever, anyway). ...

Copying a database, how do I change security?
I have a split app (developed using A2000) which my own office has been using for several months. Another office has recently asked me to make a copy for their use. I am happy to do so, however, both the FE and BE are fully secured and I'm not sure how to change security on the copies to recognize the personnel at the other office and to stop recognizing the personnel at my office. I confess that I never fully understood Acess' user level security process. I implemented security originally by following specific steps from a textbook which I no longer have. I do understand about...

Text in pivot table limited to 255 characters
I am using a pivot table as an efficient way to aggregate text responses from a large data set. However, the pivot table cuts off the text after the first 255 characters (similar to when you copy a worksheet by using the move/copy option). How can I overcome this? I have tried putting the pivot table on the same sheet as the dataset, but that does not work. I should also note that these pivot tables are then fed into an automated report through a complicated set of VLOOKUPs, etc. The pivot table aggregates several questions and responses from many areas of the datset into one discr...

Money 4.0 file transfer to Money Essentials
I am getting an error message when I try to import my Money 4.0 backup file to Money Essentials program on my new PC. Are the 2 version incompatible? =?Utf-8?B?Y21nZnVzYQ==?= <cmg_fusa@yahoo.com> wrote in news:E3AD8366-ED94-4625-A534-C0CCA8F3DBA8@microsoft.com: > I am getting an error message when I try to import my Money 4.0 > backup file to Money Essentials program on my new PC. Are the 2 > version incompatible? Yes. Money Essentials is incompatible with everything. Take it back and get Money Plus. -- Steve B. New Life Home Improvement In microsoft.public.money, cm...

Endnote/Cite write, as well as database issues #2
Hello all- Is anyone using Endnote 7 on the mac and Office X? I have found some stability issues, as well as issues connecting to certain databases- e.g. Blackwell does not have a direct filter, you have to go through other steps. I am all ears (actually eyes) to talk with someone about this because I am writing my dissertation and think that the steep learning curve is worth it. Email : sethhalvorson@gmail.com Hi Seth, There are a number of people dropping in and out of either this newsgroup or more likely the microsoft.public.mac.office.word newsgroup, who use Endnote, including some p...