Search results for query: *

HA .... Not sure what I was thinking ... Thanks PWise you ROCK!!!

I'm trying to select production volume for a well for the most recent 3 months it has produced from the last day it produced. Below is my query ... I am only getting one record and it is 90 days from the MAX date none of the data in between is coming back ... any help would be much appreciated...

Thanks ... will try your suggestions!! Have a good one!!! gwoman

I have an Excel Add-In created by someone who is no longer with my company and I need to edit it. There is a date lookup module that I need to edit. Some of the modules say "project is not viewable" and some are password protected ... and of course the password was not documented anywhere...

Hi ... I inherited an Access database (XP version) and I need to remove the user level security and convert it to Access 2007. I followed the instructions from microsoft.com however when attempting to assign administer in the permissions dialog box it's tells me that I must be the Administrator...

=) Actually that is the name of the company I work for ...

It can run under any user account and yes the folder is a public folder so it does have access to it. When I show the following variables whe using PickFolder this is what I get ... nms = MAPI fld = Aera wide Kaizens Test So I changed my fld variable as follows: fld = nms.Folder("Aera wide...

I have a script that extracts outlook calendar data and puts it into an Excel Spreadsheet. When I give the user the option to pick what calendar folder they want to use the code works perfect ... however I am making this a scheduled task that runs weekly and so I am trying to hardcode the...

Hi ... There is an empty shape in the master slide but no image is displayed. You can see it in the small version in the slide navigation section but not on the big slide and not if you run the presentation. Yes the presentation runs ... but like I mentioned above ... you can't see the...

I have some users that have legacy PowerPoint presentations that contain images (WMF and CGM) from data sources such as Open Works and Earth Vision ... when opening and converting these presntations ... the slides on the left side of the screen are visible ... but the images do not show up on...

I hadn't tried it yet ... because I wasn't sure if it would throw a warning first!!! Thanks so much!!! Have a fabulous day! gwoman

If I have an XP Excel Spreadsheet and it contains macros and open it and save it in Excel 2007 format ... what would happen to my macros if it were saved as an .xlsx instead of an .xlsm format? Would is disable my macros or would it strip them out all together? Thanks much gwoman

Cool ... thanks!!

Thanks .... would it work better if I put it in a module and used Docmd.RunSQL?

Hi ... I have a query that I have run in SQL Nav ... and I put it into an Access DB and I'm getting a syntax(missing opertaor) error with my case when statement ... does Access not allow case when statements in queries? Here is my query ... SELECT a.RSVR_SGMT_ID ,cd.PRIM_PURP_TYPE_CDE...

I just upgraded to Office 2007. I’m exporting from SAP creating a new excel file. The excel file is created no problem, with the exception of any field that contains dollars (it might be numbers across the board, but I noticed the dollars) sometimes the numbers are so far off from what they...

thanks ....

I'm working on a custom form in Outlook 2007 and I need to add another page ... and can't seem to find it on the new ribbon menu. Does anyone know where they have moved this option? Thanks gwoman

Here is a list of all my declarations at the top of my module ... Dim appExcel As Excel.Application Dim appWord As Word.Application Dim blnMultiDay As Boolean Dim dteEnd As Date Dim dteStart As Date Dim fld As Outlook.MAPIFolder Dim i As Integer Dim intReturn As Integer...

Here is the code that gets the data from the first page ... CreateWorksheet: Set appExcel = GetObject(, "Excel.Application") appExcel.Workbooks.Open (strSheet) Set wkb = appExcel.ActiveWorkbook Set wks = wkb.Sheets(1) wks.Activate appExcel.Application.Visible = True...