Search results

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

TAbs I found I need to draw this on the current tab where it belongs to the tab and not the form. But Ive already created the combos and text boxes and would like to consolodate and save space by using tabs. Is there a way to do this without doing everything all over again to draw it 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?

I tried to use the fuction again but it would show up.

Thanks for you quick response however I keep getting an #error on my report after entering that in the controlsource. My form is called personnel and the dates are labeled ANTHRAX 1 - ANTHRAX 6. Would I put this in the controlsource? =[Forms]![Personnel]![ANTHRAX 1]

Using the DateAdd function on my form shows up with due dates for shots that were taken but the due date doesn't show up on the report. Its not sending the data from the form to the report. The first shot is showing up but thats the only shot you have to manually enter, the other ones are...

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

One thing I forgot The reports are individual shots with due dates if this is of concern.

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

Perfect Thanks alot for the quick response too.

Perfect but.... Now the text boxes disappear on each individual record how do I stop that from happening?

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 exactly does this do for me, Im running into some trouble with a combo box right now as posted earlier. Dealing with one shot but its got different types of this once shot and I want to select it and have dateadd calculate a due date based on the selection in the combo box.

Date Add problem The combo box is working, it calculates the dates based on the date taken that I type in but when I reopen the form the selection in the combo box disappears and is blank. The date stays the same for each individual record. Im using the date add function to calculate the date.

Combo Also, sorry the combo box works as far as updating the box with the correct dates but it doesn't save that information between each record. When I open up the database the combo box is blank and the date reverts back to the "taken" date. How do I save the date and selection for each...

Text86 is bound to???? And that code gives me an error. Is there suppossed to be an ElseIf in the 6th line. Thanks

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

Shot record Database Any ideas please don't hesitate. Thanks again for your time

Good to go thanks Andy. But another ? For instance I have a couple of shots that are a 6 shot series and a booster every year or two after. Whats the best way to generate a report to show which shot they took and the correct due date reflected in the report. What I basically want to do (at the...