Search results for query: *

Hello, I am trying to join our REPORT_MM_RECEIPTS table to our MV_ITEMMAST table. I am joining on the ITEM field. The issue is that in the REPORT_MM_RECEIPTS table, the field is trimmed. In the other table, it has the 32 characters of the field filled with blanks. Anyway, although aside...

Hello, Can anyone tell me why this code doesn't run: ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "Data_All_Items_Added!R3C1:R13174C8", Version:=xlPivotTableVersion10). _ CreatePivotTable TableDestination:="PVT_Items_Added!R3C1"...

hello, I would like to use VBA to set up the linked tables in my database when it opens. I have searched, and there are related topics, but I think I need a little help. I am doing this because some users have their drives mapped differently, and I need to use the base server instead of the...

Hello, I am using VBA from MS Access to create an instance of Excel and of Word, and then to copy and paste from Excel into Word. When I execute, the first time it runs properly, the second time I get this error message: Run Time Error #91 Object Variable or With Block Variable not Set. here...

Hello, I am interested in finding a method like the OnTime method, except that I want the method to interrupt the code that is running. The idea is to give the VBA code a limited time to either complete the task, or move on. OnTime only runs when the current procedure completes. Thank you, Pat

Hello, I would like to find simple(hopefully) code to allow my code to timeout (or resume next) if the hyperlink I am trying to follow doesn't work. If I just paste the link into internet explorer, it will return a generic page saying the URL cannot be found. I can deal with that easily, but...

Hello, I am trying to calculate a moving average for a series of data. I want to generate the moving average for each point within the data, in order to show in a graph. Anyway, below is an example from MS Support. I have followed to the letter, but mine doesn't give a moving average. It...

Hello, I am concerned about the possibility that my application may be leaking memory. In the code below I added the line to set AppAccess = Nothing. Then I started to test. I open the task manager and check the memory used by Excel, then step through the program. After the program runs...

Hello, I have a database from which I am using the following line to export data: Application.DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "output_query_1" , "G:\GroupA\AAA\Compliance.xls", True This method worked for a long time, but today, for some reason, it treats each...

Hello, I have a table with time series information. It has the following fields: Category Date Sales I want to use a query to add a field with a moving average (10 day) of the sales data for each date/category combination. I know this is probably simple, but I have never been able to figure...

Hello, I have a form that I want to automatically resize when it opens to fit the screen, regardless of the resolution settings on the computer. I am working on some vba code to do this (and any insights on that are appreciated), but on the form itself I have the following issue: I have set...

Hello, I would like to know if there is a way to do the following in Access: 1) determine what libraries are currently referenced in the VBA programming environment 2) Set a reference if it is not already set. I want to do this with the opening script in VBA so that when a user opens the...

Hi, I have what I think is going to be a simple question. I have a value stored in a field in a table with only one record. I want to assign that value to my variable x. Here is what I was trying: x = Tables![Table1].Field1 I also tried using RunSQL, but was not able to make that work...

Hello, I have pieced together the code below to navigate to a webpage and copy the information on it. I am reduced to using sendkeys and I really don't like it. If you could suggest code that could allow me to copy the data on the page instead of the sendkeys below I would really appreciate...