Recent content by Soulbait

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