Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Soulbait

    Changing permissions on a registry key...

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

    Closing forms

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

    Closing forms

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

    Query Order

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

    Query Order

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

    Percentage in a query?

    Thanks, that worked perfectly.
  7. Soulbait

    Percentage in a query?

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

    Percentage in a query?

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

    Percentage in a query?

    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]...
  10. Soulbait

    How do I find get a percentage to work in a query?

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

    How do I find get a percentage to work in a query?

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

    Question about changing a query value without going into design view

    That'll work perfectly, thanks.
  13. Soulbait

    How do I find get a percentage to work in a query?

    Thanks, one question, were do i put that statement?
  14. Soulbait

    Question about changing a query value without going into design view

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

    How do I find get a percentage to work in a query?

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

    Button pushing queries

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

    Setting field value based on 2 other field values?

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

    Button pushing queries

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

    Setting field value based on 2 other field values?

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

    Setting field value based on 2 other field values?

    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.

Part and Inventory Search

Back
Top