Search results for query: *

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.

Hi, I am trying to create a query that will show data in a rolling four month period. Example: For September, show June through September; for October, show July through October. I am using a general date format in the field. I can use >DATE() - 120 to get a 120 day period, but that...

lameid, I get what you're saying. The fact is, I am only using the Access securtiy because I have no other options. For my applications, it is almost overkill, since the Company has set Access as a secondary database (Oracle being the primary). Hence, not a lot of support for the Access end of...

Super! I really appreciate this. Thanks a lot!!

I did give that a try, but it is still a little beyond my scope. However, in this particular case, is there a way to bypass the need for the users' password, since I am the only one involved in the design? I am thinking just to password my access and let all the others be able to access data...

I understand. Thanks, this should work.