Search results for query: *

So I've got this little issue... I need to delete a key under Enum...you may be asking why...Don't. But RegKey = My.Computer.Registry.LocalMachine.OpenSubKey("SYSTEM", _ True).OpenSubKey("CurrentControlSet", _ True) Try...

Ok brain woke up, just had to move it up a couple lines.

Ok, its Friday, my brain has shut down. Anyways I have a form that has a button, the button pops up another form with 11 other buttons on it, each button opens a report, However, when I click the button in the popup form I would like that popup form to close. I'm just skipping over what i need...

Thanks that worked out quite nicely. Soulbait "Despite the cost of living, it's still quite popular"

I have a query set up currently that sorts by 2 fields The first field is a 3 to 6 digit field and is the primary sort. The second field is a 3 to 4 digit field and is secondary For instance, the first field ID may be 27684 then the next field is say 031 well the next record in the sort will...

Thanks, that worked perfectly.

Ok well if I fill in all the empty fields with 0 it seems to work, however this is not really an option to have the user be putting 0's in the empty fields. Is there anyway for it to be told if its an empty field that it should treat it as a 0 here is the new statement SELECT DISTINCTROW [Card...

Almost works. When I change it to Percentage:([Strongly Agree]+[Agree]/[Total] it works fine as long as there is data in the strongly agree and agree fields, but if not it will not give me the percentage.

Here is my current sql statement for the query I am running. SELECT DISTINCTROW [Card 1].Question, [Card 1].CardType, Sum([Card 1].[Strongly Agree]) AS [Strongly Agree], Sum([Card 1].Agree) AS Agree, Sum([Card 1].Disagree) AS Disagree, Sum([Card 1].[Strongly Disagree]) AS [Strongly Disagree]...

Here's my current SQL Statement for my query SELECT DISTINCTROW [Card 1].Question, [Card 1].CardType, Sum([Card 1].[Strongly Agree]) AS [Strongly Agree], Sum([Card 1].Agree) AS Agree, Sum([Card 1].Disagree) AS Disagree, Sum([Card 1].[Strongly Disagree]) AS [Strongly Disagree], Sum([Card 1].[No...

Thats kinda what I thought it should look like, but where do i need to be placing the statement. I must not be placing it in the right spot.

That'll work perfectly, thanks.

Thanks, one question, were do i put that statement?

I have some queries set up but I would like for the users to input 2 date ranges in say a form and that would be the criteria for the query, can anyone tell me how this would be done? Thanks

I have a table which has 5 fields which I am totaling each field and then the total of all 5 fields within a query What I would also like is another field that gives me a percentage between the first 2 fields and the total of all 5 fields. Can this be done, If this makes no sense which I might...

the crosstab query was the original query i set up that did not filter states. Like I said, I am most likely putting the code into the wrong spot that chunk of code is all associated to the OK button, while the Select Case code is all associated with the combo box, I've got it pretty well...

for some reason this is just not working for me, I tried th Dlookup as suggestiong but it says there is either a misspelling or that it doesn't exist. I've double checked the format and am about to change the fields to without spaces but that means redoing about 6 forms. If you wanted to send...

Ok thats how I have it set is 10 different queries, but when I click the button its not choosing the query i have specified in the list. I know there is something incorrect with the code in the On_Click function of the button that is not right. I'm missing a small piece of code that says to get...

Thanks for the email, however we seem to have a little miscommunication. I'm not trying to setup a query to search 2 tables. What I have here is a table with roughly 12 fields with no primary key. Named Card1 The fields are: Provider ID, Card ID, Card Type, Question #, Question, SA, A, D, SD...

Actually I just got it to work for the most part, however it has a memory of ones I've chosen before, I do not want it to keep this memory, I want it to ONLY show the one that it is suppose to be.