Search results

anybody???

Update If I format the unbound with an input mask for medium date it won't pass the value to the query. Yet if I format it as a text box it will pass text. I need it to pass the date.

When I have my form I have an unbound control called rtdDate. In rtdDate's AfterUpdateEvent I have it run a append query. Within the append query I have the following: RTD Date: forms!masterListQ!rtdDate Yet it keeps coming up blank when you run the query. Its like its not finding the value of...

thanks bone...thats exactly what I needed.

I have a combo box in a form that I want to prevent "unwanted" changes to this comb box. I'm trying to find a way that if someone changes a combobox, it prompts them "are you sure you want to change this?" If the answer is yes then it lets them change it, but if the answer is no it returns it...

When a person selects a value from a combo box, it prompts for a date that goes in a text box on the form. I think I need to use an input box though.

Is it possible to use a msgbox to fill in a control on a form?

Thanks lagbolt, I'll give it a shot. I think a new approach to this matter is needed, like you suggested

My problem is this: Table 1 contains: PIN, Name, Section Table 2 contains: Name, Section, ID Table 3 contains: ID, project name Table 1 is current personnel, table 2 is personnel who've worked on a project, table 3 is a project listing. I'm trying to create a way that when a record from...

YOU ROCK Bat17, that helped emmensly Wulf

Have no worries, I figured it out.

I'm still new, how do you requery a listbox after a COMBO BOX updates? I know its code of some sort but not sure what that is? Wulf

Let me say... ..this forum is a wonderful place and you guys are full of awesome information. Now that I have groveled to the great gods of Access, let me get to the heart of my problem. My database is very similiar to this one but I would like to incorporate a LIST BOX that also updates and...

Sure, how bout 2000? Wulf

I'm running Access 2003. I've attached the database, said form with mess up list box is on the "main" form. Let me know what you come up with. Wulf

My list box on my form has the fore color set to 255 or red yet it still displays the first column in black and the rest in red. Am I missing something? Why isn't it all red? Wulf

Thank you Thank you for this, I think this is what I've been looking for. I originally had date expired calculated in a query and the form pulled its info from the query but I couldn't figure out a formula to make it conditional and look at the 3 extensions. Looking at the one you came up with...

So your saying that I shouldn't store my extension dates? I know not to store the "date expires" because it changes too much but the extension dates for each record don't change once they are given to that specific record. So why can't I store them? All I want is an unbound textbox that when...

Ok, here's my quandry: I have a form used for tracking certain "reports" within my office. One control comes from a table and its the report "Date Started". A second control calculates the "Date Expired" which is normally "date started + 180 days". Now here's the tricky part, I have three...

I'm trying to print a report with 30 blank lines at the end for write-in additions. I've followed several of the posts on this site but I seem to be running into a problem. I've attached a pared down version of the database. Can someone please help?