Search results

Is it like an Answer key??? or could it vary depending on the subject?? If person 1 answers question 1 yes... and they should have answered no.. If person 2 answers question 1 yes... could that be correct??? or will it always be no?

Based on looking at the data... nothing is consistent, Number of characters (before and after) There are no consistent delimiters... I don't see how a single formula can be used without being extremly complex... I can't wait to see what one of the guru's come up with

So the key is to making them Public. When you create a custom subroutine in a module Private subs are local to that module, while Public subs are accessable throughout the application. Public Sub My_first_Subroutine (Any Variables to be passed) 'Code end sub If you wish to create variables...

Change to SELECT DISTINCT for starters. that will fix your repeat values error... Do you have your second and third combo boxes requery'ing through code on the change of a value of the box preceeding it? Also, Which field holds the text description your seeking?

Hopefully you wish to do this for more than the basic things like close.. which there is no value in changing to a global macro because it's one line of code, not to mention the wizard can make you a close button in about 15 seconds no coding required. But for more complex operations, you have...

Try this example out.. look at it for a bit, play around, i think you'll get it. In queries.. when I set the criteria to be a value based on a form's control.. I always use the right click and BUILD option.. then you look for Access > Forms > All Forms > form name your want > then the control...

ok.. so you make your drop down boxes right? right. You don't set the control source because your not saving the data in the dropdown, your simply using it as a tool. So you set the row source.. (The SOURCE of the Rows used in the drop down.. :) ) When you click on the three little dots on the...

To create a drop down box of years, you might want to set the datasource using a query builder, select the date field, but use the format(datefield, "YYYY") setting so you only get years... then use the SELECT DISTINCT opening in SQL and you'll get a dropdown list of all the years in your...

Create a dropdown box of months.. and another of years. Then in your query you reference those controls. You may want to look at the "Build" option when you right click on the field name... it's helpful

There has to be a market for it... Microsoft put a ton of money into a vb studio package designed around multi developers on multi stations... and with phones and web conferences I can't see how it would be much different than having a single office of 20 floors with people working on different...

Do an evaluation on the "On change" event of the drop down control. if me.dropdownboxname = "No Answer" AND me.TextboxName <> "" then msgbox "Something" end if You may need to change textboxname <> "" to Not textboxname IS Null

create a query with your desired fields.. and one calculated field.. The calculated field will read something like this: Expr1: Format([Name of Date field], "MM") This will pull only the MONTH number from the records... so in your search criteria, you will put in a number.. or paramater for the...

If you use a query with paramaters that must be entered...those paramaters have names example might be... [Please enter start date] Use THAT name in your previous formula =(Format$([Please Enter start date],"mmmm yyyy",0,0) & " to " & (Format([Please Enter End date]...blah blah you get it

Well you can look into the count functions built into Access. But if it were me, and it's already working the way you want and you just want to remove a minus... In the query design view... for your field that is being sumed... in the part that lists the field name just type * -1 after it....

OOO... very nice! Learn something new every day!

Your best to create a query that has a calculated field. Calculated values that change over time shouldn't be "stored" in the database. they should simply be generated based on the data that doesn't change, which is the birth date. In a new query, select your table, and ALL the fields. Then in...

hmmm interesting... it doesn't open in sheet 2 for me. I tried it in 2010 and 2003... umm. hmmm I dunno what to tell ya. Does it always open in sheet 2? even if you go to sheet 1 and save it then close and re-open?

Hey Kev, glad to hear you got that working. Congrats. Glad i was able to help you.

Here ya go! Hopefully this works the way you expected??? I was working on it kinda fast. I left all your stuff and just added mine, so i'm sure you'll be able to see what I did, but if you need a further explination i'll gladly elaborate. Basically, I created a new query, and filtered the...

I attatched an example of an updated code version. (Wasn't working quite how I wanted it to) But I am not able to recreate your problem of being able to simply move the password prompt in order to view data on the second tab. When the password prompt comes up, sheet 1 is in the background, not...