Search results

I'm having a hard time thinking this through. Below is an example of the data. I want to only include those records were IIf([TYPE]='E',[LOC]='T') and IIf([TYPE]='C',[LOC]='S') or to just exclude the records (where Type = E And Loc = S) but I don't know how to write it and include it in my...

I'm using Access 2007. The query is built on linked tables. I have [Forms]![FormName]![ListName] and [Forms]![FormName]![TextName] in the criteria field of the query. This works but when I close and reopen the database, the Form goes blank. To fix this issue, I've had to manually go into the...

I've created a simple form that runs a query based on the combo box selection and text box field. Yesterday it worked fine. Today when I open it in Form View, it is blank. The fields still show up in design view. I'm confused why it doesn't work today since I didn't change anything. I've...

Thanks for your help.

Right now my query is pulling all the records within the past week using: Between Date() And Date()-6 How do I exclude the weekends? So it will include data for example from Thursday to Thursday but not including Saturday & Sunday.

I have the reference set to Microsoft Office as well as Microsoft Excel but am still getting the error.

Thanks that works perfect. When I try this on an excel workbook though I get the error name argument not found (WithWindow). Would I use something different?

I get a run-time error : Application.Visible : Invalid request. Hiding the application window is not allowed.

I am using this vba code to open a powerpoint file and update the links. Right now I'm having to make the object visible but I want to be able to run this in the background and hidden to users. Is this possible? Public Function OpenPPT() Dim PPObj As Object Set PPObj =...

Thanks for the replies. I want to be able to run it on multiple computers so the second option will probably work better. I will give it a try.

I have an excel file with graphs linked to another excel data file. When I open the graphs on my machine, res 1280 x 1024, they appear fine. The problem I'm having though is when I try to open on a different monitor, resolution currently set at 1360 x 768, part of the graphs get cut off. I need...

I have built OpenPPT to open the specified powerpoint file. Is there a way to have it automatically open in Slideshow mode? Public Function OpenPPT() Dim PPObj As Object Set PPObj = CreateObject("Powerpoint.Application") PPObj.Visible = True PPObj.Presentations.Open FileName:="test.pptx" End...

I run a sub routine to open four different excel files. I need another sub routine to close the four specific excel files? Here is the code I am using to open and save. Private Sub CmdOpenExcel() 'Opens the specified Spreadsheet Dim xlApp As Excel.Application Dim xlWB As...

I ended up using the SendKey function and that worked.

I have two excel files, one is the data and the other the graphs. All the graphs are linked to cells in the data file. I have changed the security settings to update the graphs automatically. When I open the graphs file though, my horizontal axis labels don't appear. The data in the graphs have...

I am trying to automate the process of getting data from Access to PowerPoint. I am using the following code to open PowerPoint. When PowerPoint opens though I get a warning message. How do I add a function into my code to select the "Update" button? Private Sub CmdOpenPowerPoint_Click()...

I used the DateValue function and that worked. Thanks for your help.

I'm using the CDate function to convert a timestamp into a date but it isn't working completely. I want it to be a ten digit date for example 01/05/2010. The problem if the date is less than nine, 1/5/2010, it isn't returning a value. Date: CDate(Left([TSMP],10)) Examples: TSMP / Date...