Search results

Oh one other thing I noticed, I'd like for new records to default "Yes" for All Questions No. I've attached an updated version of the database. It's mostly formatting changes, but you'll see the text box I'm talking about in the "Status" area on frmPARQ. I've played and played with the record...

Absolutely wonderful Lagbolt! Thank you! However, silly me, when looking through it, noticed that I'd left out a possibility. The DoctorConsent can be yes if it is 1 or 3. So I'm trying to make this minor change in the code you put in the Record Source. SELECT tblPARQ.*, Not...

Thank you for the reply lagbolt, seems like a smart idea, however, I don't know, and can't seem to find, the correct syntax to write what you've told me to write. And I'm not sure where to place the code once it's written. I hate to be a bother, but if you could, or anyone, write out the code...

I have a text box called "Approved" on frmPARQ that I am trying to write an event for and am having trouble. I've created a db to allow users to enter and store information off of paper forms. There are 10 check boxes on frmPARQ that are yes/no questions. There is also a check box called...

I'm not even sure what to call this problem... I have a form, that I've set up to do an email function. There are text boxes for [To:], [Subject:], [Body], and [Attachment:]. I am running a query that pulls names, emails, and dates pertaining to vaccinations. The query shows who's...

Thanks for your efforts guys. Queries didn't work - and either way I had to get these values stored. Motleyjew was close with the VB stuff.... I finally found what I needed: Linky. It says to create a macro of SetValues and call the macro for OnCurrent in the form, and also AfterUpdate for...

I appreciate the reply! I don't know any VBA either... so i'm not sure how to write that based on the big IF statement I have in post #2. Here's some further information that might help in writing the statement. The form is "frmVacinations" My form section looks like this...

*bump* still needing help with getting the calculated form values stored in my table.

values calculated on form not being stored in table I'd placed this db to the side for a while... now I'm back to it, and I'm noticing a problem. I have various "date" text boxes and related "expire date" text boxes. I am wanting to place a "default value", essentially, for expire date...

Figured out the filling text box problem.... What I ended up doing, was deleting my current combo box and starting over. When going through the wizard again, I added all columns from tblSemester and just changed the 2nd and 3rd column widths to 0. This way I didn't have to edit the sql after...

This is bringing out some creative thinking on my end. hehe Here's what I've come up with: I still have my "tblSemester" that lists the semesters and their ending and beginning dates (month and day). Field names are [Semester], [BeginDate], [EndDate]. I created a form with the following...

I think I figure out how to get a qry to look to form fields for values. Example, I placed [Forms]![frmMain]![Semester] And [Forms]![frmMain]![Year] in the criteria for my date field. Now I just need it to automatically correlate semester/year entries by the user with date ranges.

Any ideas on how to do this would be helpful... i might be going about it all wrong... if there's a different way or an easier way, I'm all for hearing. I don't have to have the tblSemesterLookup - if getting it to work would mean writing a big IF statement, that's fine.... The users can deal...

I did a search through Microsoft and found this article. It said... There's a download in the resolution section and a helpful tip in the references section. I'm not sure if this would be applicable to you because it confused me on the versions. Maybe you can read it and understand more...

This is sort of a continuation of this thread -but I'm changing my approach. I've been trying to figure out Bob's advice of creating a form where users can enter a semester/year and run different reports based on the criteria entered on the form. I know in the previous thread I asked about...

Just thought I'd update and say that I got the report to work right and thank you so much for all the help. In the wizard I had it do a sum on the sumofhours field. And in my grouping, I hide the header that included the sumofhours field and only showed the [sum(sumofhours)] field. It shows...

Thanks for the replies. I like the idea of doing the sum of the sum on the report and the form for entering dates - I will have to figure those out later. I'm still confused on how to go about writing the query(ies). Here's a picture of my query now - maybe that will help:

Let's see if I can explain this situation effectively... I've been handed a database that is set up to track tutoring sessions of students. The original creator designed the database for 1 semester. I am trying to make it functional for x number of semesters. So here's my dilemma: I have...

Ah, well I always give up right before I find my answer... Wasn't getting much on google until i found this. My resulting statement was: =IIf([CPR_option]="1", DateAdd("m",24,[CPR_Date_Issue]),Iif([CPR_option]="2",DateAdd("m",12,[CPR_Date_Issue]),Null)) And it did what I wanted. :)

I'm having trouble forming a multiple condition IF statement. Basically, I have 2 radio buttons with values of "option 1" = 1 and "option 2" = 2 which values are stored in field [CPR_option]... then I have 2 date/time text boxes "CPR_date" and "CPR_date_expires". I am trying to write a...