Search results

Hello, could someone please offer some suggestions as to how I can fix a problem I have with Access 2010? I have written some code to pull data from tables on various web pages. The code iterates through several thousand pages and pulls data from each one. Everything works fine when I run this...

Hello, I've been writing some code to pull data from a website and have hit a bit of a problem. I'd be grateful if someone could help with help this. The one thing that I can't seem to do is to set the value of a combo box on the webpage. I need to select a value in order for the correct...

Anyone know how to create OLAP cubes using either Access or Excel (assuming it can be done of course)? I have a number of queries that I would like to use as the basis for OLAP cubes that can be used by my colleagues. Any help would be gratefully received.

I'm trying (being the operative word) to build a passthrough query and am having some problems. When I try running the following SQL it returns "Incorrect Syntax near '!'". Can anyone see what's wrong? SELECT dbo.vSyndicate.CalYearID AS CalYr, Right([ReturnCalQuarterID],1) AS Qtr...

I'm trying to write a pass-through query that contains anumber of IIf statements. SQL Server doesn't appear to like them. Can anyone please tell me what the syntax should be or what function to use in their place? Thanks.

I have a VERY simple select statement that I am using in a pass-through query: "SELECT * FROM dbo_vReturn;", but I cannot get this to work. Each time I run the query it generates an error: "ODBC call failed - Invalid object name "dbo_vReturn" (#208)". The dbo_vRteturn is a view in the backend...

Does anyone have a Jet to ANSI SQL conversion tool they could either send me or recommend:confused:

Can anyone help? I have a query that queries against 11 linked views against an SQL Server backend. The query is running dog slow, so I want to convert it to a pass-through query so that the processing is done server side rather than Access having to drag thousands of records across the...

Does anyone have some code that will generate a chart in Powerpoint from data in an Access table?

Can anyone help with this problem? I have a form with a listbox populated with a number of spreadsheet names and want to pass the value selected from the listbox back to a function. But the problem is that the calling function does not wait for an item to be selected from the list and the form...

Help joining queries that return different nos. of records. I am having real trouble trying to join two queries together. Both queries are based on different tables which contain the same type of data. The problem is that each query returns a different number of records as follows: Query1 Key1...

Can someone please tell me how I can programatically delete all relationships for one, or all, tables?

Does anyone happen to have some code that loops through all forms (open or not) and lists the form name, desription property and the code behind the form? I want this to produce some documentation. I've had a very very long week and my brain is completely addled, I've been trying to get this to...

Can anyone point me to some code that brings up the "Open File" & "Save File" dialogues? I believe one of the functions I once used for this was called GetFileOpen(), but I've now misplaced the code. Any help would be appreciated!

Does anyone have some code that replaces the old "On Mouseover" event in AXP?

Does anyone know if it is possible to change the appearance of the mousepointer to the pointing hand graphic used in hyperlinks etc? I have a form that contains numerous controls, by double clicking on these controls another form opens. This all works fine but the problem is that the users are...

I have a function that uses SendObject to send emails to a number of different email addresses. The problem is that I want to also vary the sender email address (as I have numerous email addresses that I use). How can I get Access to send an email using a from address that I specify (can it be...

Can someone please tell me where I am going wrong. I want to import a single worksheet from a workbook using Transferspreadsheet. This is what I have so far: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTemp", False, variableSheetName I think there should be an exclamation...

I want a list of each sheet in a workbook. Can someone tell me where I have gone wrong here?: Sub ListSheets() Dim exlObj As Object Dim exlSht As Object Set exlObj = CreateObject("Excel.Application") Set exlSht = CreateObject("Excel.Sheet") exlObj.Visible = True With exlObj...

I need to assign a subform to a specific page of a tab control using the form on Open event. Can anyone give me the reference for this?