Recent content by UNDPC

Hello, I am trying to programmatically open up a secured access db from an excel module and run a macro contained in the db, but I am having trouble figuring out how to pass the username and password to the db without the login dialog. Does anyone have any experience with this and would be able...

Andrew, Thanks for the code. One more question for you. I did not realize that the access db in which the macro is stored is a secured access db with a username and password. Would I need to insert code to read a username and password to get the macro to kick off and would you possibly have the...

hello, I am trying to find some sample code to call and run a macro in an ms access database from an excel vba module. the access macro has already been created and all it does is delete the data in a table and import the excel worksheet into the current table. I'd appreciate any help with the...

Hello, I have a security problem with access if anyone could assist. I had created an access database and then secured it going through the steps of the security faq, creating the workgroup file and shortcut necessary to open the db with user/password login. I wanted to test a couple security...

Willar, I have not seen any documentation on this while searching on it. Do you know of any online where I can check this and get a better understanding of it? Thanks.

Hi, I am having a little problem that I hope someone may have some info on. I have created 2 different secured access databases, both stored in the same folder on our network, with the same users/passwords. The problem I am having is that when I try to link a table in one of the secured db's...

I'm sorry PH, I though you meant the Background Refresh property on the external data range where the query is downloaded to on the excel sheet. I'm still sort of a novice at this. So would my code be something to this extent: Sheets("List").QueryTable.BackgroundQuery = False and insert this...

I was talking about the Excel table as well. Why would I want to turn off the background refresh property? I can't have static data, I need to retrieve new data each time the list item is changed. If I turn off the background refresh the requery won't run. PH, you responded a bunch of times to...

PH, I don't see how this will help since it has to make the connection to the access DB to return the correct query data to the excel sheet. Doesn't turning that property off not allow for a requery?

Skip, Thanks for your help. In doing this, I have realized that the person who created this spreadsheet is only using the dropdown listbox (validation list) to populate another cell which is the parameter for an MS Access query from one of our databases. It looks like the query is downloaded...

Skip, Should the code now look like this: Do Until IsEmpty(Range("AG" & n)) ListCell = Range("AG" & n).Value Range("D5:J5").Select With Range("D5:J5") .FormulaR1C1 = ListCell .Calculate End With ActiveSheet.PageSetup.RightFooter =...

Skip, Here is my code. Thanks for you help. Dim StartPage, n As Integer Dim ListCell As String StartPage = Val(InputBox("Enter the Starting Page Number.", "Page Number Start", "1")) n = 69 ListCell = Range("AG" & n).Value 'this is where the list is...

Yes, I have tried that as well and it does not work either. It still just prints and moves onto the next item in the list.

Hi, I am working on a macro to cycle through a data validation list, calculate the sheet, then print each record each time. The problem I am having is that when I place the value from the list in the calucated cell dropdown, I cannot get the sheet to calculate before it runs the print portion...

the query is run with a cell on the sheet being used as the parameter, so when you change the cell value the query runs and the data is passed back to the same worksheet, a couple of rows below. so i wanted to try the worksheet change event, but it runs it twice, once right after i change the...