Recent content by cturner

This is a separate application. Desktop weather from the weather channel runs in the background and it would be easiest to minimize and pause my presentation for 2 minutes and then maximiaze and restart but I am not very good at code so I came here for suggestions...

I am running a powerpoint show on a TV in our cafeteria that shows news and other company information. I need a way to pause the show and minimize to show desktop weahter for 2 minutes then resume the powerpoint. Any ideas???? :confused:

Is there anyway to reference a calculated field from one report onto another. I need to create a summary report from several other reports and don't want to use subforms becuase it slows the report way down. I was just wondering if there was another way.

Ahah. I think I know why I thought mine wasn't working. I have the start date as 9/1/05 and the ending date as 10/1/05. Most of my date1's are 9/1/05 and my between statement is not picking up 9/1/05 but on yours it is. Is there an internal setup that would cause this?

Mine still is not working I do have them as a date field but mine query still is not working. Can you send me a sample of your query. I must have something typed in wrong.

Here's my problem. I run a database every monday that has several (more than 15) reports as the outcome. Due to the massive amount of information we can't build the data up every week. We need to overwrite the tables and recreate the "Reports" every week. The department I am creating this...

I am not sure how to search for this so if there is another thread with this example please direct me in that direction. What I am trying to accomplish in my query is the following: I am bringing data in from another source in the following table ID Date1 Date 2 I want a query to do...

... Although the problem is occurring on a continuous subform, it does not appear that is the cause. Briefly what happens is: On the subform 1 field is entered, which is the primary key of the subform table. On that control's afterupdate there is extensive code which pulls data from another...

Thanks Thanks for the quick reply but...(info from my code person) The recordset is not touched until the findfirst. While debugging, all methods of the recordset fail (movefirst, edit, requery, addnew). It is possible to get different errors, but they all seem to be the same error with...

We are having problems with a database created. the error we get is Run-Time error '-2147417848(80010108)': Method 'FindFirst' of object 'Recordset' failed We can succesfully enter in one record on a subform but when trying to enter the second we always come up with this error. if we end the...

I have a form based on a query I built that calculates time worked. you select the worker in a combo box which I created from a query that lists all active employees and their clock no. with clock no being the bound column. The drop down shows the workers last name, first name. When I choose...

Thanks, It worked great. Sometimes the simplest things get me stumped. This site is wonderful for putting me back on track. Just one comment, when I entered the If statement it changed it to the following =IIf(Time()>#10:00:00 PM#,DateAdd("d",1,Date()),Date()) Just in case someone else...

I am trying to set the default in a feild to either be today's date if it is before 10:00pm but if it is after 10 PM i want ti to bump to the next day. I used this but I am getting an expression error. Any help? = IIf ( Time()> 22:00:00 , DateAdd ("d", 1, Date()) , Date())

Still Need Help Since I have had no hits on this I think I might not be explaining very well or there is no way to do what I need. If anyone has any suggestions on other ways to do what I need I would appreciate it. Also, if you need further explanation as to what I want to do let me know. I...

What next Thanks for your help but I have one question in the area where you say do what you want how do I push my selection to a form? I didn't get an error on my selection but it also didn't do anything? Thanks again.