Search results

Hi all, I'm trying to find how to programatically move to the next detail record on a report. Pseudocode: Open two recordsets (Old record, Current record) Compare old to new, if changes, mark up current report record. Move to next detail section Loop But I can't seem to force the report to...

Hi all, I have a report with some code on the Report_Load event. When I open the report, it works fine. I also have a subreport with some code on the Report_Load event. When I open the subreport directly, it works fine. When I add the subreport object to the report, and then open the...

Hi all, I'm sure this is just a syntax problem, but I cannot figure it out for the life of me. I'm working on a bound form and I'm trying to set the where condition of a DSum to Month(ReviewDate) = Month(me.txtReviewDate), but having trouble. I have tried several different ways. As an...

http://www.cnn.com/2012/08/22/showbiz/prince-harry-photos/index.html?hpt=hp_t3 Do folks in the UK care when the prince goes out and has a good time? Seems like such a nothing story to Americans, but kind of curious what the UKer's think.

Hi, I have a query with parameters, which are supplied by a form. User clicks a button on frmMain, frmDialogBox pops up. User enter values in frmDialogBox (specifically OrderID). In the query, Order ID Criteria is set to Forms!frmDialogBox!cboOrderID. This works as expected. However, I...

Is anyone here familiar with the search engine GoodSearch? You can choose to support a registered charity, which earns the charity $.01 for each internet search that you perform. I'm currently supporting the non-profit hospital that I work for, but there are several worthwhile charities that...

Hi all, So I have this report based on a query. The report is a listing of conferences and their overall compliance rating. The report takes a date parameter. So if I run the report for 2010, for example, and one of the conferences met 10 times that year and of those 10 times the conference...

Hi all, This should be easy, but I must not be using the correct search terminology. I have a function that opens a new email message in Groupwise (Email client). This is accessed by clicking a button on a form. The function has a variable "stTo" which I can set like this: stTo =...

It seems really odd to me that there are stickied threads by a poster that is banned. A sticky is sort of a mark of approval by the forum administration whereas a banning is a heavy mark of disapproval. Not to mention that if someone had a question regarding the sticky post, they can't ask the...

I recall reading a thread at some point where some forum users were saying that they were writers. Mostly out of curiosity, who on the forums like to write in their spare time, and what type of genre do you tend to write in? I like to write mostly fantasy type fiction. I have three novels that...

This article got me thinking: http://religion.blogs.cnn.com/2011/01/04/appeals-court-says-cross-on-federal-land-is-unconstitutional/?iref=allsearch (Article summary: A group put a cross on public lands, other groups complained, the group then started interring veterans at the site in order to...

Hi, I'm mostly self-taught, so this might be something that I just missed, or it might be due to the design of the inherited database, but any help would be appreciated. We have paper forms that are filled out, approximately 20k-30k/year. Each of these paper forms is read electronically by a...

Ok, this is very strange. I have a form with various textboxes and a refresh button. The button calls on_click UpdatePreview. UpdatePreview looks like this: if condition 1 = true then if condition 2 = true then if condition 3 = true then if...

Ok, odd question. There is a main database that contains a ton of demographic information on STAFF members. We have meetings where both members of the STAFF and others (who we call GUESTS) attend. I don't have the ability to modify the STAFF database at all, I simply am connected to it through...

I'm currently working on an ADP (Access 2003 - Sql Server 2005). I'm trying to find a way to make filtering easy for non-computer people. So I have a bunch of records that all have a BeginDate field on them (field type smalldatetime). I'm using a Form that is based on a View to display the...

Every now and again someone comes along and does something or says something that is so awful that you just have to shake your head in disbelief. This is a classic case: http://www.cnn.com/2010/US/01/13/haiti.pat.robertson/index.html If I had a list of the top 5 things wrong with America...

Hi everyone, I am starting to get into some Visual Basic that is above my head, so I am trying to figure some of this out. Hoping to get some help. First, in layman's terms: I have textbox1, textbox2, textbox3(and so on, up to 6), that contain numbers. I have textbox7, textbox8...

Hi all, I've searched all corners of the Internet world for a SIMPLE way to send an automated email when a user clicks a button. The objective here being that when someone checks a box indicating that the labeled item is complete, the next person that needs to work on the project is notified...

Hi all, I am relatively new to SQL Server, currently going through the process of upgrading an Access 2000 database to SQL Server 2005 utilizing an Access Data Project for the front end. When I create a view through SQL Server Management Studio connecting two (or more) tables, and then try...

Hello all, Out of curiosity, how is Oliver Cromwell viewed in the UK? Our history classes in the US really just glazed over him, but I have found his story to be very intriguing. I've read a lot about him where I could find it, and it made me wonder how he is received in the UK. Thanks...