Search results

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...

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 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?

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...

I have been having alot of trouble with this and just can't figure it out, I am trying to get data from a parent form into a subform so I can use it in equations. Specifically I have a DOB (Date of Birth) field on the main form, and want to have a =DateDiff("yyyy",[DOB],Date()) to find their...

I have a table with three fields, StartDate, EndDate and Holiday Name. What I am trying to do is have a query search this table and determine if a date is between any of the startdate and enddate fields, and if it is have it output "Holiday", and have it output "Non-Holiday" if it does not.

I have a table with three fields, StartDate, EndDate and Holiday Name. What I am trying to do is have a query search this table and determine if a date is between any of the startdate and enddate fields, and if it is have it output "Holiday", and have it output "Non-Holiday" if it does not.

Is there any way to add a dropdown box or something that determines that a subrecord is active/completed, and then have a way to jump straight to the one that is active by clicking a button on the record? In the example I attached, I want to be able to click on the button above the tab and have...

Is there any way to add a dropdown box or something that determines that a record is active/completed, and then have a way to jump straight to the one that is active?

Hello, I'm fairly new to access and was wondering if it was possible to make a report that generated a chart based on a start date and the number of days you want it to continue for. In specific, I want it to display a chart that tells whether or not each day is a weekday or holiday, holidays...