New stores exported from HQ get original store's configuration....
In a headquarters / store operations environment, are configuration settings "centrally maintained data" that get exported from HQ when a new store is created from HQ? In other words, do the new stores get the configuration settings assigned to the first store in store ops manager - file - configuration - accounts/ordering/inventory/options/etc tabs....? Thanks for any insights.
convoluted
pos
14173 articles. 
0 followers.
2 Replies
614 Views
the short answer is no. But it does get some (finding this out as we go). Inventory yes, Ordering dependson what you mean, accounts yes you can send that down, options no. "convoluted" wrote: > In a headquarters / store operations environment, are configuration settings > "centrally maintained data" that get exported from HQ when a new store is > created from HQ? In other words, do the new stores get the configuration > settings assigned to the first store in store ops manager - file - > configuration - accounts/ordering/inventory/options/etc tabs....? Thanks for > any insights.
DougPicNPacThat stuff all comes from the TEMPLATE database you use when you export a new store. If you use Store 1's database as the template, then yes that's where the settings come from. See the HQ Help file for a description of what should be set up in the Template DB. This is basically how you create 'default' values for operating options and security among other things. Glenn Adams Tiber Creek Consulting http://www.tibercreek.com glenn@tibercreek.com ---------------------------------------------- Please DO NOT respond to me directly but post all responses here in the newsgroup so that all can share the information. convoluted wrote: > In a headquarters / store operations environment, are configuration settings > "centrally maintained data" that get exported from HQ when a new store is > created from HQ? In other words, do the new stores get the configuration > settings assigned to the first store in store ops manager - file - > configuration - accounts/ordering/inventory/options/etc tabs....? Thanks for > any insights.
glenn9672
Similar Artilces:
Must buy new computer...Ideas?
Hello to all! Finally my over 10-1/2 year old Dell desktop's extreme slowness has seriously gotten on my nerves and I'm now looking for a new one. (Surprisingly, it's working pretty well otherwise...) Maybe this isn't the right forum? But beside the usual things like RAM and HD GBs, are there things I should be sure to have...or be careful NOT to have on a desktop? After n ot looking into computers for over a decade I feel like a Martian in the Earth. lol! Also, is it possible to transfer to the new one ALL my stuff, including programs, etc.? Do you thin...
HQ users should be able to add ship-to records from the stores.
HQ users should be able to add ship-to records from the stores. As of RMS 1.3.???, HQ users can indeed create ship-to records at the stores. I'm told that RMS doesn't handle this properly. There are problems created when stores are messing around with global customers. I suspect that MS will 'fix' this by eliminating the ability of stores to add Ship-To records. I have a customer, ABC Fitness, who has one office, but several gyms. I repair the treadmills at their various gym locations. I have each service site set up as a Ship-To in RMS, within the ABC global customer ac...
store an std::string in combobox
Hi there, I am working on some legacy code which is being translated into Chinese. I have a combobox with a load of strings in. The strings are convertd to chinese. The problem is, the actual strings are used to determine what happens on the OK button. So I want to add the original, english, strings to the combo box item - SetItemDataPtr. These strings come in as const std::string. I'm having major woes trying to get them into the itemdata. I've tried doing .c_str() and casting them back to const char* but to no avail. What's a simple way of storing a const std::string in the com...
I used "save as" but now can't locate original file
I was using a file (November), changed the data, clicked "save as" (December. Now, November is the same as December. Any possibility there's a temp file of November anywhere? Book I believe you have not done as you describe. If you had a previously saved November workbook open and made some changes then File>Save As and named it December, November workbook will still be on your computer in its previous state. Unless you saved it as November with the changes. From where did you open November workbook? It will still be there. Gord Dibben Excel MVP On Thu, 1 Dec 2005 1...
Default properties for new folders
How does one set the default properties applied when creating new email folders? Currently, when I create a new folder, it is created with the AutoPreview turned on by default. I'd like to change that do that it is left off by default. It's something of a pain to create a new folder and then go in to customize it's properties. You can do this by editing the Messages view; View-> Arrange By-> Current View-> Define Views... You might want to define a new view yourself and apply that view on first use of that folder. -- Robert Sparnaaij [MVP-Outlook] www.howto-o...
New Email Messages
I just installed Outlook 2007 on my new PC and for some reason the new messages I received can only be received when I press the SEND/RECEIVE BUTTON. My Outlook at work receives these new mail messages as they are received. So how can I configure the system to make that happen? -- The Trail Hiker!! There are two settings within the accounts 1) Send on starting 2) Auto send/receive every xx minutes - set this for 10 minutes "hiker0531" <hiker0531@aol.com> wrote in message news:87259C7A-5C07-4846-BF61-DE3F98345D21@microsoft.com... >I just installed Outlook 2007 on my n...
Increasing size of store #2
Hey guys, Is there an downside to increasing the store size to 75 gb in standard? Also, is it okay to delete PreDefragLogFile's older then last year? The log files are taking up 40gb of space and i dont think they are necessary. Thanks in advance On 3 Apr 2007 09:24:10 -0700, draelive@gmail.com wrote: >Hey guys, > >Is there an downside to increasing the store size to 75 gb in >standard? Also, is it okay to delete PreDefragLogFile's older then >last year? The log files are taking up 40gb of space and i dont think >they are necessary. > >Thanks in advance You...
Unable to open "New" window to write email.
I am using Microsoft Outlook in Office 2003. It has been working great until today. When I click "New" to write a new email I get an error window : The messaging interface has returned an unknown error. If the problem persist, Restart Outlook. I have tried this several times, even restarted the computer to no avail. Anyone have a solution???? ...
Prevent new comments on old posts in sharepoint blogs
How do I stop comments on certain posts in a SharePoint blog? I have removed permissions to the specific post to the lowest possible access and people can STILL post a comment. If I uncheck one more item in the list of permissions, the users can no longer see the post. Any suggestions? ...
A Short Video on Adding/Editing New Customers
If capturing customers at the POS is important to you, take a couple of minutes and watch this video. This application also allows for edit of Global customer information in HQ installations. http://www.retail-pos.com/ReverseLookup.wmv Contact us for detailed info and demo. sales(at)retail-pos.com www.retail-pos.com It would be nice if you could encode the videos with a more common codec, and not in wmv format. This requires the GTM3 codec (GoToMeeting). Windows Media Player 11 doesn't automatically download the codec, and I'm not going through the trouble to download and in...
New Location/New setup
Currently I'm downsizing our office, and moving to a new location. I'm running MS Server2003 as well as Exchange 2003. Once moved, I will no longer require the server (since I am setting up a home office). Are there currently any steps or procedures available to correctly shutdown one office...and basically setup a home office with no exchange server. Also I will be removing the current pc's from the Domain, and setting up a few in a workgroup. I would like to receive emails from the other employees for time being until I completely cancel this email account. I already have a...
How do I activate the new mail button
When I start Outlook, the "New", "forward", "reply" and "reply to all" buttons are not active which means I can not send mail. I have no problems receiving mail. Also, on web pages with email links, when I click on them, the Outlook application is not launched which is almost certainly related to this. I think I'm missing something very simple here! Are you in a mail enabled folder? Do you have an active email account installed? --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert...
Style available all sheets new or old
I need a custom style that is available in all spreadsheets, new or old. I can set style and save it in book.xlt in xlstart, but that only works for new workbooks, and doesn't work with old spreadsheets when I call them up. I want to be able to select a group of cells, or column or row and apply a setting for negative numbers to have brackets. I am using Excel 2000. I even tried saving the style in personal.xls, but that doesn't work as it is hidden. Do I have to use a macro? And if so what would it be? Thanks One way: Public Sub MergeStyles() ActiveWorkbook....
Sub Form Assigning New Values to Old Records
I am using a subform within a form to have users update certain fields in the record where the rest remiain locked. On the Main form when the list box (which is bound to a query) is used to select the record set to display in the subform it sometimes takes an old record and assigns a new value to the record. For example it changes the Period field from 9 to 10. Taking a record created in period 9 and assigning a period ten to it which is the selection I make in the list box. Addtionally, it looks like it is taking the first record in the related table to assign this new value to. ...
Getting rid of Alt + Enter
I inherited a workbook and the person used Alt Enter a lot. I want to get rid of it. Is there a way to do find/replace on the special character that causes the line to wrap? I tried reformatting and I got the info on one line but an additional character was added (looks like a small rectangle). I would try Ctrl+A, then Ctrl+H, and while holding the ALT key down, type 0012 with your numeric keypad inside the "Find What" box. Then press Replace All. HTH Jason Atlanta, GA >-----Original Message----- >I inherited a workbook and the person used Alt Enter a >lot. I ...
Which table will refresh by adding new Account / Contact
Hi, I am new to CRM and trying to update CRM Accounts and Contacts from our Sales Management system. I am using Micorosft Bulk Import utility. I am in preparation of CVS files but not sure what columns do I need in CVS file to complete one Account/Contact record. Could anybody please help. I am .NET expert developer, please let me guide If I could develop CRM by using .NET not CVS Regards Hi Adnan, Microsoft do provide CRM SDK for CRM enhancment using .net. You can download from following url http://www.microsoft.com/downloads/details.aspx?familyid=9C178B68-3A06-4898-BC83-BD14B74308C5...
Adding new pages
Any thing I do on new pages happens simultaneously on any previous page. Can someone help me please? Can you be more specific? What stencils are you using and what are you trying? John... Visio MVP Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm Need VBA examples? http://www.mvps.org/visio/VBA.htm Common Visio Questions http://www.mvps.org/visio/common_questions.htm "Joanie" <anonymous@discussions.microsoft.com> wrote in message news:4C3642E4-4F2B-4A65-8C00-E9041CE74A37@microsoft.com... > Any thing I do on new pages happens simultaneously on any previ...
How do I get keep the format (superscript) from a table?
I have a report that is using a vlookup to come up with a value. The vlookup table has cells with superscripts. How do I keep the superscript format when the lookup returns a value. Not all data in the table has a superscript. Formulas return values--not formats. Maybe a macro that would copy|paste would work??? P3SAB$ wrote: > > I have a report that is using a vlookup to come up with a value. The > vlookup table has cells with superscripts. How do I keep the superscript > format when the lookup returns a value. Not all data in the table has a > superscript. -- D...
How do I get random numbers from a certain range?
I have 468 unique numbers and need to select, at random, 64 numbers that do not repeat. How do I get Excel to do this? Assuming your numbers are in A2:A469... In B2:B469, enter =RAND() and then sort A and B based on B, and take the top 64 (A2:A65) OR: you can use formulas to pull a different set of 64 each time you re-calc, which may not be what you want. HTH, Bernie MS Excel MVP "Random numbers" <Random numbers@discussions.microsoft.com> wrote in message news:E6D42792-E837-49FF-8EC1-0E89C63F8979@microsoft.com... >I have 468 unique numbers and need...
New trend, new business, new year a new beginning
New trend, at start of new year. "If you want things to work different, you must try a different...whatever..." Does that seem obvious? Brighten up with this "reading" and attack the money issue with more gusto! I am finishing my year 2005 with some regrets and some joy. For some the year passed has not been "tip top" in their view. But I believe it has just been very well as the page I shall bring you that has this statement which I believe wholeheartedly: "THINGS ARE UNFOLDING AS IT SHOULD" (paraphrased) I invite you to read the whole "poem&quo...
New messages comes up in Deleted folder
Sometimes when I receive new messages the go to the Deleted folder instead of the Inbox. The messages are from random people...not just one sender. What is the problem? Thanks Check your message rules/filters. "key word" in new mail subject line of body is probably being tagged and filtered to deleted items folder. Regards C. >-----Original Message----- >Sometimes when I receive new messages the go to the >Deleted folder instead of the Inbox. The messages are >from random people...not just one sender. What is the >problem? Thanks >. > ...
Exporting Messages
When attempting to export WLM from my laptop to my new desktop, I get an error message saying "the export directory must be an empty directory" no matter what folder I try to place them. How do I export messages & contacts too? "jschramm" wrote in message news:96F49659-4317-4D88-847F-4420A2E795BB@microsoft.com... > When attempting to export WLM from my laptop to my new desktop, I get an error message saying "the export directory must be an empty directory" no matter what folder I try to place them. How do I export messages & contacts too?...
New User has admin rights
I just created a new user and assigned her the role of Sales Manager. This role is working correctly for other users with it assigned, but she has admin rights? This is the only role she has assigned.... Any ideas? TIA Metcalf ...
Creating new row in other table
Dear All, Please teach me, how to make a new row/list in other table by entering number in other table. Sample, In the table A and in the field "Details", I put the number 2 and it automatically creates two rows in table B. Can this be done in MS Access? Thank you for your help. Regards, Maulwy Why? What business need are you attempting to solve with this approach? It's generally considered not very good database design to be creating 'empty' rows in a second table. Why do you want empty rows? And if the number you enter in TableA is a 'limit&...
CODE: get current dir of MDB file
I will be posting a few short snippets of code. Many of you coders already know these, but they should benefit other people as well. Here is code to find the current directory of the MDB file you currently have open. This is useful for saving output files (like report PDFS, text files, etc) to the same dir as your MDB file. It returns the current directory with a trailing backslash. Function CurrentDBDir() As String Dim strDBPath As String Dim strDBFile As String strDBPath = CurrentDb.Name strDBFile = Dir(strDBPath) CurrentDBDir = Left(strDBPath, Len(strDBPath) - Len(strDBFile)) End...
Hello to all! Finally my over 10-1/2 year old Dell desktop's extreme slowness has seriously gotten on my nerves and I'm now looking for a new one. (Surprisingly, it's working pretty well otherwise...) Maybe this isn't the right forum? But beside the usual things like RAM and HD GBs, are there things I should be sure to have...or be careful NOT to have on a desktop? After n ot looking into computers for over a decade I feel like a Martian in the Earth. lol! Also, is it possible to transfer to the new one ALL my stuff, including programs, etc.? Do you thin...
HQ users should be able to add ship-to records from the stores.
HQ users should be able to add ship-to records from the stores. As of RMS 1.3.???, HQ users can indeed create ship-to records at the stores. I'm told that RMS doesn't handle this properly. There are problems created when stores are messing around with global customers. I suspect that MS will 'fix' this by eliminating the ability of stores to add Ship-To records. I have a customer, ABC Fitness, who has one office, but several gyms. I repair the treadmills at their various gym locations. I have each service site set up as a Ship-To in RMS, within the ABC global customer ac...
store an std::string in combobox
Hi there, I am working on some legacy code which is being translated into Chinese. I have a combobox with a load of strings in. The strings are convertd to chinese. The problem is, the actual strings are used to determine what happens on the OK button. So I want to add the original, english, strings to the combo box item - SetItemDataPtr. These strings come in as const std::string. I'm having major woes trying to get them into the itemdata. I've tried doing .c_str() and casting them back to const char* but to no avail. What's a simple way of storing a const std::string in the com...
I used "save as" but now can't locate original file
I was using a file (November), changed the data, clicked "save as" (December. Now, November is the same as December. Any possibility there's a temp file of November anywhere? Book I believe you have not done as you describe. If you had a previously saved November workbook open and made some changes then File>Save As and named it December, November workbook will still be on your computer in its previous state. Unless you saved it as November with the changes. From where did you open November workbook? It will still be there. Gord Dibben Excel MVP On Thu, 1 Dec 2005 1...
Default properties for new folders
How does one set the default properties applied when creating new email folders? Currently, when I create a new folder, it is created with the AutoPreview turned on by default. I'd like to change that do that it is left off by default. It's something of a pain to create a new folder and then go in to customize it's properties. You can do this by editing the Messages view; View-> Arrange By-> Current View-> Define Views... You might want to define a new view yourself and apply that view on first use of that folder. -- Robert Sparnaaij [MVP-Outlook] www.howto-o...
New Email Messages
I just installed Outlook 2007 on my new PC and for some reason the new messages I received can only be received when I press the SEND/RECEIVE BUTTON. My Outlook at work receives these new mail messages as they are received. So how can I configure the system to make that happen? -- The Trail Hiker!! There are two settings within the accounts 1) Send on starting 2) Auto send/receive every xx minutes - set this for 10 minutes "hiker0531" <hiker0531@aol.com> wrote in message news:87259C7A-5C07-4846-BF61-DE3F98345D21@microsoft.com... >I just installed Outlook 2007 on my n...
Increasing size of store #2
Hey guys, Is there an downside to increasing the store size to 75 gb in standard? Also, is it okay to delete PreDefragLogFile's older then last year? The log files are taking up 40gb of space and i dont think they are necessary. Thanks in advance On 3 Apr 2007 09:24:10 -0700, draelive@gmail.com wrote: >Hey guys, > >Is there an downside to increasing the store size to 75 gb in >standard? Also, is it okay to delete PreDefragLogFile's older then >last year? The log files are taking up 40gb of space and i dont think >they are necessary. > >Thanks in advance You...
Unable to open "New" window to write email.
I am using Microsoft Outlook in Office 2003. It has been working great until today. When I click "New" to write a new email I get an error window : The messaging interface has returned an unknown error. If the problem persist, Restart Outlook. I have tried this several times, even restarted the computer to no avail. Anyone have a solution???? ...
Prevent new comments on old posts in sharepoint blogs
How do I stop comments on certain posts in a SharePoint blog? I have removed permissions to the specific post to the lowest possible access and people can STILL post a comment. If I uncheck one more item in the list of permissions, the users can no longer see the post. Any suggestions? ...
A Short Video on Adding/Editing New Customers
If capturing customers at the POS is important to you, take a couple of minutes and watch this video. This application also allows for edit of Global customer information in HQ installations. http://www.retail-pos.com/ReverseLookup.wmv Contact us for detailed info and demo. sales(at)retail-pos.com www.retail-pos.com It would be nice if you could encode the videos with a more common codec, and not in wmv format. This requires the GTM3 codec (GoToMeeting). Windows Media Player 11 doesn't automatically download the codec, and I'm not going through the trouble to download and in...
New Location/New setup
Currently I'm downsizing our office, and moving to a new location. I'm running MS Server2003 as well as Exchange 2003. Once moved, I will no longer require the server (since I am setting up a home office). Are there currently any steps or procedures available to correctly shutdown one office...and basically setup a home office with no exchange server. Also I will be removing the current pc's from the Domain, and setting up a few in a workgroup. I would like to receive emails from the other employees for time being until I completely cancel this email account. I already have a...
How do I activate the new mail button
When I start Outlook, the "New", "forward", "reply" and "reply to all" buttons are not active which means I can not send mail. I have no problems receiving mail. Also, on web pages with email links, when I click on them, the Outlook application is not launched which is almost certainly related to this. I think I'm missing something very simple here! Are you in a mail enabled folder? Do you have an active email account installed? --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert...
Style available all sheets new or old
I need a custom style that is available in all spreadsheets, new or old. I can set style and save it in book.xlt in xlstart, but that only works for new workbooks, and doesn't work with old spreadsheets when I call them up. I want to be able to select a group of cells, or column or row and apply a setting for negative numbers to have brackets. I am using Excel 2000. I even tried saving the style in personal.xls, but that doesn't work as it is hidden. Do I have to use a macro? And if so what would it be? Thanks One way: Public Sub MergeStyles() ActiveWorkbook....
Sub Form Assigning New Values to Old Records
I am using a subform within a form to have users update certain fields in the record where the rest remiain locked. On the Main form when the list box (which is bound to a query) is used to select the record set to display in the subform it sometimes takes an old record and assigns a new value to the record. For example it changes the Period field from 9 to 10. Taking a record created in period 9 and assigning a period ten to it which is the selection I make in the list box. Addtionally, it looks like it is taking the first record in the related table to assign this new value to. ...
Getting rid of Alt + Enter
I inherited a workbook and the person used Alt Enter a lot. I want to get rid of it. Is there a way to do find/replace on the special character that causes the line to wrap? I tried reformatting and I got the info on one line but an additional character was added (looks like a small rectangle). I would try Ctrl+A, then Ctrl+H, and while holding the ALT key down, type 0012 with your numeric keypad inside the "Find What" box. Then press Replace All. HTH Jason Atlanta, GA >-----Original Message----- >I inherited a workbook and the person used Alt Enter a >lot. I ...
Which table will refresh by adding new Account / Contact
Hi, I am new to CRM and trying to update CRM Accounts and Contacts from our Sales Management system. I am using Micorosft Bulk Import utility. I am in preparation of CVS files but not sure what columns do I need in CVS file to complete one Account/Contact record. Could anybody please help. I am .NET expert developer, please let me guide If I could develop CRM by using .NET not CVS Regards Hi Adnan, Microsoft do provide CRM SDK for CRM enhancment using .net. You can download from following url http://www.microsoft.com/downloads/details.aspx?familyid=9C178B68-3A06-4898-BC83-BD14B74308C5...
Adding new pages
Any thing I do on new pages happens simultaneously on any previous page. Can someone help me please? Can you be more specific? What stencils are you using and what are you trying? John... Visio MVP Need stencils or ideas? http://www.mvps.org/visio/3rdparty.htm Need VBA examples? http://www.mvps.org/visio/VBA.htm Common Visio Questions http://www.mvps.org/visio/common_questions.htm "Joanie" <anonymous@discussions.microsoft.com> wrote in message news:4C3642E4-4F2B-4A65-8C00-E9041CE74A37@microsoft.com... > Any thing I do on new pages happens simultaneously on any previ...
How do I get keep the format (superscript) from a table?
I have a report that is using a vlookup to come up with a value. The vlookup table has cells with superscripts. How do I keep the superscript format when the lookup returns a value. Not all data in the table has a superscript. Formulas return values--not formats. Maybe a macro that would copy|paste would work??? P3SAB$ wrote: > > I have a report that is using a vlookup to come up with a value. The > vlookup table has cells with superscripts. How do I keep the superscript > format when the lookup returns a value. Not all data in the table has a > superscript. -- D...
How do I get random numbers from a certain range?
I have 468 unique numbers and need to select, at random, 64 numbers that do not repeat. How do I get Excel to do this? Assuming your numbers are in A2:A469... In B2:B469, enter =RAND() and then sort A and B based on B, and take the top 64 (A2:A65) OR: you can use formulas to pull a different set of 64 each time you re-calc, which may not be what you want. HTH, Bernie MS Excel MVP "Random numbers" <Random numbers@discussions.microsoft.com> wrote in message news:E6D42792-E837-49FF-8EC1-0E89C63F8979@microsoft.com... >I have 468 unique numbers and need...
New trend, new business, new year a new beginning
New trend, at start of new year. "If you want things to work different, you must try a different...whatever..." Does that seem obvious? Brighten up with this "reading" and attack the money issue with more gusto! I am finishing my year 2005 with some regrets and some joy. For some the year passed has not been "tip top" in their view. But I believe it has just been very well as the page I shall bring you that has this statement which I believe wholeheartedly: "THINGS ARE UNFOLDING AS IT SHOULD" (paraphrased) I invite you to read the whole "poem&quo...
New messages comes up in Deleted folder
Sometimes when I receive new messages the go to the Deleted folder instead of the Inbox. The messages are from random people...not just one sender. What is the problem? Thanks Check your message rules/filters. "key word" in new mail subject line of body is probably being tagged and filtered to deleted items folder. Regards C. >-----Original Message----- >Sometimes when I receive new messages the go to the >Deleted folder instead of the Inbox. The messages are >from random people...not just one sender. What is the >problem? Thanks >. > ...
Exporting Messages
When attempting to export WLM from my laptop to my new desktop, I get an error message saying "the export directory must be an empty directory" no matter what folder I try to place them. How do I export messages & contacts too? "jschramm" wrote in message news:96F49659-4317-4D88-847F-4420A2E795BB@microsoft.com... > When attempting to export WLM from my laptop to my new desktop, I get an error message saying "the export directory must be an empty directory" no matter what folder I try to place them. How do I export messages & contacts too?...
New User has admin rights
I just created a new user and assigned her the role of Sales Manager. This role is working correctly for other users with it assigned, but she has admin rights? This is the only role she has assigned.... Any ideas? TIA Metcalf ...
Creating new row in other table
Dear All, Please teach me, how to make a new row/list in other table by entering number in other table. Sample, In the table A and in the field "Details", I put the number 2 and it automatically creates two rows in table B. Can this be done in MS Access? Thank you for your help. Regards, Maulwy Why? What business need are you attempting to solve with this approach? It's generally considered not very good database design to be creating 'empty' rows in a second table. Why do you want empty rows? And if the number you enter in TableA is a 'limit&...
CODE: get current dir of MDB file
I will be posting a few short snippets of code. Many of you coders already know these, but they should benefit other people as well. Here is code to find the current directory of the MDB file you currently have open. This is useful for saving output files (like report PDFS, text files, etc) to the same dir as your MDB file. It returns the current directory with a trailing backslash. Function CurrentDBDir() As String Dim strDBPath As String Dim strDBFile As String strDBPath = CurrentDb.Name strDBFile = Dir(strDBPath) CurrentDBDir = Left(strDBPath, Len(strDBPath) - Len(strDBFile)) End...