Recent content by jake7363

Hi, I designed a slide show that works perfectly in IE7, but I get a blank screen for the HTML page in FF. Can any one give me a clue what I am missing? The url is below. Thanks in advance, Jake

Worked like a charm!!! Thanks so much... I think you are right about using it in the form, but I had to do it for all the forms, so I thought it might be a better idea... But, I did learn something... Much appreciated, Jake

Hi, I am a bit confused where I went wrong.... In a form, I have 4 option buttons in a frame, named optLog. The Click Event is as follows: Private Sub optLog_Click() selLog End Sub In the module, the function selLog contains the following: Select Case optLog Case 1...

I don't know why this works and the other way doesn't, but THANKS!

Hi, I have two tables: tblJan, tblFeb I have 1 form: frmMonth. I am trying to use a command button to change the recordsource to view another month. Here is what I have: Sub cmdFeb_Click() Forms!frmMonth.RecordSource = "tblFeb" End Sub An error message appears as follows: "Run-time error...

Yup! That's the first thing I checked. Thanks..

Hi, I have a report that has a grouping by a field called "JobNo". Sometimes there is one record (3 lines/record), sometimes there are three records. Is there a way to send a form feed so that the report is not able to print half of a record on one page and half on the other? Thanks in...

Thanks much!!!

Hi, I am designing a report based on a query using BETWEEN in reference to dates. The question is, how do i get the date range to be printed on the report? Thanks in advance, Jake

Thanks to both! Much appreciated..

Hi, My database includes a JobNo field that is masked to appear as "06-01-0234". I am trying to set up a parameter query that allows me to just search for the last four numbers. I am using LIKE [Find] & "*" then enter "0234", it does not pull up the record. If I use the entire...

SkipVought - I was one reply late - it was referring to the post by Golom. Sorry for the confusion.

As I see it, the code designates specific months. But this is a "rolling" period, so that without intervention, it drops one month and adds another when the month changes. Thx.

The idea is that this will be a continuing rolling process. It needs to keep rolling the months over as they change, without user intervention. This will include changing from year to year, so that once it is set up, to run it will not require any interaction.

I just want to show the data, no other calculations.