Replies

I understand your response and thanks.

Another issue: Since we work in a network environment, the location of My Data Sources in problematic (C:Documents and SettingslbrumfieMy DocumentsMy Data Sources). This is how Windows XP sets up the location of My DocumentsMy Data Sources. Notice that my user name account (lbrumfie) is in the path.

I use macros in Access 2002 to run parameter/make table queries. The macro runs Word and opens a particular mail merge document. I make the data source for the document the table the query made.

This path, that includes the user name, makes it more difficult to distribute the front end of the Access application. I would like to be able to place the front end on the users desktop and have the application store the table in that front end. But I can’t set up the macros that way because the path to Desktop and My Data Sources has the user name in it.

Has anyone had this problem and is there a work around (meaning I would really like to distribute the front end to the users desktop)?

Thanks. I hope this make some sense.

I understand your response and thanks.

Another issue: Since we work in a network environment, the location of My Data Sources in problematic (C:Documents and SettingslbrumfieMy DocumentsMy Data Sources). This is how Windows XP sets up the location of My DocumentsMy Data Sources. Notice that my user name account (lbrumfie) is in the path.

I use macros in Access 2002 to run parameter/make table queries. The macro runs Word and opens a particular mail merge document. I make the data source for the document the table the query made.

This path, that includes the user name, makes it more difficult to distribute the front end of the Access application. I would like to be able to place the front end on the users desktop and have the application store the table in that front end. But I can’t set up the macros that way because the path to Desktop and My Data Sources has the user name in it.

Has anyone had this problem and is there a work around (meaning I would really like to distribute the front end to the users desktop)?

Thanks. I hope this make some sense.

Hans, thanks for the reply. Since this TransferSpreadsheet thingy worked before for me, it helps to know that Help is wrong. Then again, it bothers me that Help is wrong.

I had to have our IT staff reload all the software on my computer. It seems to have fixed that problem.

I have another problem, though. I have Word 2002 documents that merge data from Access. Once the document knows where to find the data, the merge works fine. The problem is that to set up the Find Data Source, it takes Word over 2 minutes to process the request!! Any ideas?

(I know this should be posted on the Word forum, but thought the Access forum would be able to answer, also.)

Edited by LonnieB: Additional information – We work on a network with a front end on the desktop and the back end on the network server.

Hans, thanks for the reply. Since this TransferSpreadsheet thingy worked before for me, it helps to know that Help is wrong. Then again, it bothers me that Help is wrong.

I had to have our IT staff reload all the software on my computer. It seems to have fixed that problem.

I have another problem, though. I have Word 2002 documents that merge data from Access. Once the document knows where to find the data, the merge works fine. The problem is that to set up the Find Data Source, it takes Word over 2 minutes to process the request!! Any ideas?

(I know this should be posted on the Word forum, but thought the Access forum would be able to answer, also.)

Edited by LonnieB: Additional information – We work on a network with a front end on the desktop and the back end on the network server.

Thanks, Mark. I finally figured out how to get it to work. No one place explained everything that needed to be done. What I had not done was to go to the cpanel for the subweb and change from anonymous user to the other choice (something like a registered user). When I did that, it worked fine.

BTW, how has your experience with iPowerWeb been? I just joined them two weeks ago. I am on their Web Hosting program right now, but I am going to change to their Windows Hosting program because is has .asp, .asp.net. and ODBC support which I am finding out I need to have the web site I want.

WebGenii, thank you, too.

Thanks, Mark. I finally figured out how to get it to work. No one place explained everything that needed to be done. What I had not done was to go to the cpanel for the subweb and change from anonymous user to the other choice (something like a registered user). When I did that, it worked fine.

BTW, how has your experience with iPowerWeb been? I just joined them two weeks ago. I am on their Web Hosting program right now, but I am going to change to their Windows Hosting program because is has .asp, .asp.net. and ODBC support which I am finding out I need to have the web site I want.

WebGenii, thank you, too.

Thanks for getting back with me. My web site is hosted by iPowerWeb. The Discussion Web is located on their servers. They provide the FrontPage 2002 Server extensions. I do not have any server loaded on my computer, that I know of.

Methinks there is some issue with the Webbots or there is html code under one of the forms that isn’t pointing to the right place to require a log in.

I am new to web site development and management, if you couldn’t tell, so I have a lot to learn. FP help is pretty good, but if you don’t know the lingo, it is hard to understand easily.

Did I answer your question?

Thanks for getting back with me. My web site is hosted by iPowerWeb. The Discussion Web is located on their servers. They provide the FrontPage 2002 Server extensions. I do not have any server loaded on my computer, that I know of.

Methinks there is some issue with the Webbots or there is html code under one of the forms that isn’t pointing to the right place to require a log in.

I am new to web site development and management, if you couldn’t tell, so I have a lot to learn. FP help is pretty good, but if you don’t know the lingo, it is hard to understand easily.

Did I answer your question?

I looked in the Knowledge Base and could not find anything like you mentioned. Do you have an idea of where it might be?

Thanks to you, too.

Thanks, Tom. I will check into it.

You can use the DoCmd.ShowToolbar code. You use acToolbarNo to hide menus and toolbars and acToolbarYes to show menus and toolbars. It confused me because I thought there would be a ShowMenu command, but there isn’t. Menus and Toolbars are the same, as far as the ShowToolbar command is concerned.

I use the following code on the FormOpen event to hide all toolbars. This way, users can only use what I let them use. I have a switchboard-like form that provides forms, queries and reports that users need.

Private Sub Form_Open(Cancel As Integer)

DoCmd.ShowToolbar “Database”, acToolbarNo ‘hides the database window’
DoCmd.ShowToolbar “Web”, acToolbarNo ‘hides the Web toolbar’
DoCmd.ShowToolbar “Form View”, acToolbarNo ‘hides the Form View toolbar
DoCmd.ShowToolbar “Menu Bar”, acToolbarNo ‘hides the Menu Bar (the built in menu bar with File — Help)’
DoCmd.ShowToolbar “MyMenu”, acToolbarNo ‘hides the menu I made’
cmdBClose.Visible = False ‘hides the Close button that contains the code below’

End Sub

I have a Close button on the opening form that has the following code in the OnClick event to turn on toolbars that I want to see. This command button is only visible to my password.

Private Sub cmdBClose_Click()
On Error GoTo Err_cmdBClose_Click

DoCmd.SelectObject acTable, , True ‘shows the Database window and selects the Table tab’
DoCmd.ShowToolbar “Database”, acToolbarYes
DoCmd.ShowToolbar “MyMenu”, acToolbarYes
DoCmd.ShowToolbar “Form View”, acToolbarYes
DoCmd.ShowToolbar “Menu Bar”, acToolbarYes
DoCmd.Close

Exit_cmdBClose_Click:
Exit Sub

Err_cmdBClose_Click:
MsgBox Err.Description
Resume Exit_cmdBClose_Click

End Sub

You should probably be able to rig up something like this for your needs.

Hi, Adam. You provided VBA code similar to what is below and it worked for my purpose at the time.

Sub CopyItems()
Dim CopyYes As Range

Sheets(“CopyTo”).Range(“A7:FA220”).ClearContents

For Each CopyYes In Range(“H1:H211”)

If CopyYes.Value = “y” Or CopyYes.Value = “Y” Or CopyYes.Value = “Yes” _
Or CopyYes.Value = “yes” Or CopyYes.Value = “YES” Then
CopyYes.EntireRow.Copy
Sheets(“CopyTo”).Range(“A65536:FA65536”).End(xlUp).Offset(1).PasteSpecial Paste:=xlAll
End If

Next
End Sub

I now need to be able to find a “Yes” value in the Range(“H1:H211”), but I only need to copy about six non-contiguous cells to another worksheet. The CopyYes.EntireRow.Copy doesn’t work for what I need. I have tried CopyYes.Range(“A1, D1:G1, B1”).Copy, but, of course, that doesn’t work. Can this be done? If you need more info, please ask. TIA

Hi, Richard. I found out, by luck on my part, that a tool bar and a menu bar are really the same thing, in a sense. When I use the DoCmd.ShowToolbar, all I have to do is place the menu name in ” ” , insert a comma, and acToolbarYes to show a menu or acToolbarNo to hide a menu. Who would have thunk that. Thanks a bunch.

Hi, Richard. Thanks, but toolbars I understand. What I need is a list of built-in MENU names. I can’t find a list of them anywhere. There must be a list somewhere. me.