Search results

Hi all I have an Access 2010 application that talks to SQL Server. Part of the application creates tables on the SQl Server and inserts data to it (I know SQL Server has its on data inport/export wizard and bulk insert capabilities but for reasons outside of my control it needs to be done from...

Hi guys, not sure sure if this is a shortcoming of Access or programmer error (most likely the latter). I have a report with quite a few subreports in it. There are a number of calculated fields on the form, most of which use Dlookup to retrieve at least one of the figures required for the...

Hi all, just wondering if there is a VBA command that returns the current view of the current active report. I am running code the uses the SetFocus Action, which works fin in Report view, but when I try to go to Print Preview view, Access throws an error stating that the command or action is...

Hi all, Im hoping there are some people around who have worked with SharePoint and Access before to help me out with this one. I have been tasked with expediting the report generation based on SharePoint (SP) lists at work. The SharePoint server is located in Sweden, while our office in Perth...

Hi all, I created an update query that is designed to update the data in a linked SharePoint. I have created the query fine but when I try to execute the update query I get an error stating: 'qryAMYPOCUpdater' is not a valid name. Make sure that it does not include invalid characters or...

I need a query to select the last 12 months worth of data from a table "MAD". The user inputs a starting month and year and the query must then pull up the last 12 months of data. For example, I might want the 12 months of data from August 2001 to August 2002. The data is stored daily with...

I need a query to select the last 12 months worth of data from a table "MAD". The user inputs a starting month and year and the query must then pull up the last 12 months of data. For example, I might want the 12 months of data from August 2001 to August 2002. The data is stored daily with...

I'm trying to use Dlookup to grab thes value in a field from a query. It works if I copy the values to a table however I want to avoid this if possible. Here's the code below Private Sub Form_Load() Dim MyDate, MyDay, MyYear, ent1, ent2, ent3, ent4, ent5 DoCmd.OpenQuery "qryCalcDifference"...

I have a table which has two records in it and 5 numerical fields. I need to divide each field of one record by the corresponding field of the next record. If the result is greater than a set value then other code will follow. I have tried creating two tables each with one record and then...

I want to add a m windows media player activex control to a form and then get it to play a file selected by the user from a drop down list. I can insert the form - no real expertise needed there - but I can't seem to work out how to provide the code to make it work. I've search endlessly on...