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!

  • Congratulations Wanet Telecoms Ltd 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: *

  • Users: Soulbait
  • Content: Threads
  • Order by date
  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, 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...
  3. 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...
  4. 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]...
  5. 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
  6. 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...
  7. Soulbait

    Button pushing queries

    Ok I have a query set up to run from a button, but thats just not good enough... What they want me to do is when you push the button for the query a popup box comes up with a filter option for the query It would have the option of No filter or choosing one of 10 states this report is for. Then...
  8. Soulbait

    Setting field value based on 2 other field values?

    Disclaimer: I am really bad at programming With that out of the way, I am looking to setup a field value to be a Description, based upon the value of of 2 number fields the 2 number fields are as follows 1,1 1,2 1,3 1,4 1,5 1,6 And then there is 2,1 etc..., 3,1 etc and 4,1 etc. The fields...
  9. Soulbait

    Question about buttons and fields

    Probably really simple question, but its something I have no idea about. After clicking a button (the button adds a record) How can you tell it to automagically go back to the desired field? And on that question, if you press a button in a sub form how much difference is code is needed to make...
  10. Soulbait

    Howto change subforms depending on data entered into main form?

    Is this possible? I'm wondering if I could get it to automagically change forms when that data is changed in the main form. For instance I have Main Form, then a field within main form we will call FormType with 4 different options (1,2,3,4) Now if I enter 1 into the field I would like it to...
  11. Soulbait

    Domain Server and Access 97

    Is there anyway for Access to use the domain server as its place to retrieve its list of users and groups for a secure database? Thanks
  12. Soulbait

    Merging Into Word from a form

    Ok, I'm working on my first complicated database for Access, never had much training, just knew how to use it. I seem to have hit a brick wall I read the FAQ (http://www.tek-tips.com/faqs.cfm?spid=702&sfid=2379) that showed me how to do it, but its still not working... I don't know maybe I'm...
  13. Soulbait

    Rolling Date Queries

    I have a database that I am designing, we need to be able to do a query on a rolling date As in, my boss says, I want to know about the last 30 days, or last year I was wondering if there is a way to just be able to go back 1 year or 1 month from the Current date. Without having to edit the...

Part and Inventory Search

Back
Top