Recent content by Galphanore

Exemptions list I have a VBA that I found that closes my form if it's idle for five minutes, and it works great. Too great. I'm trying to make an exemption so that I can set certain user names to not get kicked off after five minutes, I am using the security feature created by the "User-Level...

The problem is that I have a table that has, currently, ten, start and end dates, and I want to have it check between them all. The start and end dates are in a table. I attached the current table and a report with an iif statement of what I want...but it's not right, and I'm not sure why.

I have a table with start dates, end dates and holiday names. What I am trying to do is determine if today falls between any of those start and stop dates, but I can't figure out what to do. I think it is probibly something to do with BETWEEN, but I'm not sure how to use it correctly, could...

Is there any way to get it so that I can reference the dates in another field? I want to have lines next to them that use the following for a control : =IIf((Weekday([lstDates])>1) And (Weekday([lstDates])<7)," ","Weekend, No sign-in.")

Thanks! That's awsome.

What I am doing is creating a sign in roster for a contact. It shows the times they are supposed to sign in, and shows when they are not, based on whether it is a weekday, weekend or holiday. So I need to be able to generate a report that shows the next 60 days, for instance, and then has blocks...

Thanks, but I'm trying to get it to dynamiclly generate it without havinig to pull the dates from a table, I don't want to have to make a table with all the dates from now till the end of time :eek:

Is it possible to number the lines in a report?

I am trying to get a report to show a number of records in the detail section based on a number value in a form, in the attachement I'm trying to get the report Main to show four rows when the Days text box in the form Main has the number four in it, for example. The first row should display...

Is there any way to force a subreport to display even when it is empy? So that it would show the header with nothing under it instead of just removing the subreport?

Awsome! Thanks alot.

I have a report that prints out records, the problem is that I only want it to print out the records that have "Active" selected in the "Status" field on their table and I can't figure out how to do it. I'm sure it's very simple and I'm just over-looking it, but I can't seem to find how to do it.

I have a text box on my main form with this equation : =IIf(Child123.Form!Combo27="2","Active"," ") It is supposed to show the word "Active" if the combo box in my subform has the second option selected, the options of the box are "Pending" "Active" and "Complete". It works great as is, as...

Thanks, that works.

Thanks! That works, but how do I get it to update the age if I change the DOB? Right now the database has to be closed and reopened for the change to take effect.