Search results

Right now I have a query pulling dates that expire within 30 days and works fine. How do I continue to pull that and include all dates that are expired also? Thank you

This should be fairly easy, just not for me. I have a text box on a form that uses DateAdd calculation. I want the textbox to say Series Complete if Checkbox is checked or True and if not continue to use the DateAdd Calculation. This is what I have so far but its off... Any help appreciated...

I have 12 immunizations and I want to send the personnel who are within 30 days of expiring to a table or seperate emailable form. Any input is greatly appreciated as Im beginning to understand this application. Thanks

Although probably an easy fix I cant seem to find this with my knowledge level. Im trying to find the latest (most recent) date from two different fields on a table. One field is M16AFQC and the other is M16TRQC. How would I go about doing this. Thank you..

On my form in a text box Im using =Sum(IIf([Typhoid Complete]=True,[Typhoid Complete],0)) to count check boxes. The number is showing up right except its a negative. Any ideas as Im sure its just late for me. Thanks

Hello all, I have put together a simple database of immunizations and now tweaking for better efficency. I want to know whos expired and whos current with an end result of a pie graph or percentage output. I have the date taken box and using the DateAdd function for the expire date based on the...

Why on my form is the same data for each tab showing up on each page. Am I doing something wrong or not changing a property?

Hello All, Im using the DateAdd function for a shot series of 6 shots but the dates don't populate the report. The first one populates but thats the only one you have to enter. Whats the problem? Thanks

I have 13 different reports with info and I would like to sort them by the date due and name as a second sorting group. How do I accomplish this. Its for a shot record database I've been coming up with. I just want to look at the report and see who is coming up due very soon. Thanks for your...

Quick ? Can I have a bound text box with a DateAdd Function in it? If so how do I do that. Thank you

Hello and Im slowly learning the basics of Access thanks to this forum. Well Im stumped though on how to get five of my text boxes to disappear on my form when I check a checkbox. Its for a shot database and this particular shot is a series with an annual booster. What I want to see on the form...

What would be the correct code for this. Basically Im building a shot record database and have a Combo box that contains 3 different types of shots and when selected the DateAdd function calculates a due date. I hope this will reset for each record or be able to change for each individual. Any...

Hello. Im trying to put together a shot record database and currently I have all the shots and based on a taken date using the DataAdd feature tells me the due date. I want to generate a report based on that due date but don't have an idea on where to start. I would like the user to know who is...

Not for me. Well I am stuck (farly new) on how to make a combo box with files that when clicked on will open up. This will save some room on my page too. Thank you..

Thank you for reading, hope ya can help me out. When I open my form up the scroll bar is always at the bottom and doesn't completely show the top of my form unless I manually scroll myself. How can I get the form to open up with the top showing or scroll bar in highest position. Thank you for...