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: *

  • Users: HMJ
  • Order by date
  1. HMJ

    Query is pulling ALL fields when only 2 are requested

    Lespaul, We have been doing that, but when you generate as many queries as we do on a daily basis it becomes a pain in the @$$ to do that every five minutes or so. We were hoping to find a way to eliminate it from the start. Golom, When I get into work in the morning, I will look that up...
  2. HMJ

    Query is pulling ALL fields when only 2 are requested

    We have a situation that started about 2-3 months ago. When we make a query using MS Access, it automatically pulls ALL fields for any and all tables queried. Example: I query for LastName, FirstName; sort by LastName FirstName. No other fields. This is the SQL statement that is generated...
  3. HMJ

    Why can only one person can access DB at a time?

    I was required to install a MS Access application that was used in another office. It does exactly what our originally DB did (the one I developed here), but it has more pictures and our boss likes the 'snappy' look. Anyway, the problem is that when one user opens the frontend, no one else is...
  4. HMJ

    Creating a Module

    Hello All, I am fairly new to this, and am trying to use a module to create an item by joining two fields. It is simple, but I can't seem to figure out how to make it work. We have a field called [lastname] and another called [firstname] - original ain't we? When we run reports, etc, we...
  5. HMJ

    How Do You Open Multiple Data Entry Lines ?

    To: Rolliee Okay, I can see that, but how do you create one record for each of the 'x' number of employees assigned to the section. Each employee should have his/her individual record in table2 when this is done. That is what is causing the headache. Thanks Harry Jessen HMJessen@Yahoo.com
  6. HMJ

    How Do You Open Multiple Data Entry Lines ?

    I hope someone out there can help us. The situation is that we have two tables with the fields indicated. Table1: Emply_ID Employee_Name Employee_section Table2: Emply_ID Training_Class Training_Date Comments On form #1, we would like to: ...(1)Select the section that training was...
  7. HMJ

    Using One Input to Create Multiple Records?

    We have a situation where we have been tasked to input training informaiton about indivdual groups of employees. (Maybe this should be posted to the Access Forms group - if so, let me know) What we would to do is use a single form where the user. (1) selects the group (2) inputs the training...
  8. HMJ

    I want to create an uneditable screen

    Sam, I am currently doing this for my database. There is one that a specific group has edit authority to, and another IDENTICAL that has all the "FORM" properities set to NO: Allow Edits = NO Allow Deletions = NO Allow Additions = NO Data Entry = NO These properities work...
  9. HMJ

    Exporting DB causes input ability to disappear?

    TO: BNPMike Everything appears normal. No error or alert messages. I had one person - a local user who I know - tell me that it happend to them and they had to go in and recreate each query, form and report before this problem disappeared. There must be an easier way. Harry Jessen...
  10. HMJ

    Verification of Changes

    TO: BNPMike That sounds interesting, but I am NOT a pro at this by any means. Could I obtain more details? The only problem I see is the multiple "versions" of a record. How would you assign the versions or know what the latest was? I am using a single frontend that access...
  11. HMJ

    Exporting DB causes input ability to disappear?

    TO: BNPMike Nope, no CD. We zipped the DB and then sent it over the network to the distant server. (This was a direct transfer, not an email.) The file was unzipped, and the rest is history. Any ideas? Harry Jessen HMJessen@Yahoo.com
  12. HMJ

    Verification of Changes

    Is there a way to verify that a user wants to change information? We have a situation where some information is being changed - by mistake - and nobody will admit to doing it, much less admitting to being in the record. (I know - this NEVER happened before!) What I would like to do is make...
  13. HMJ

    Exporting DB causes input ability to disappear?

    We have developed an Access application with a frontend and a backend. The application works great - until we send it to another site for use. Of course, they have to relink the frontend and backend once it is installed - no problem there. However, the new user is not able to input new...
  14. HMJ

    Can you format a table field for MM:SS only!?

    mkov The only problem is that we need to do mathmatical actions later on such as averages. If I make it text, I won't be able to do that. Thanks anyway! Harry Jessen HMJessen@Yahoo.com
  15. HMJ

    Can you format a table field for MM:SS only!?

    OKAY, just came up with more information that might clarify what we are doing. The time I am trying to enter in the field is how long it took to complete the activity - the duration. I do not need a 24 hour or am/pm time system. Just entering minutes and seconds it took to complete this...
  16. HMJ

    Can you format a table field for MM:SS only!?

    Hello All; We are trying to build a table for tracking times on the Physical Fitness test. Part of the test is the time it takes to swim so many laps or to run a mile distance. Access has time formats where it is HH:MM:SS already defined; however, we only need to keep the MM:SS. Is there a...
  17. HMJ

    Opening a Specific File When Using Shell Function

    PH: THANK YOU!! It works great! Harry Jessen HMJessen@Yahoo.com
  18. HMJ

    Opening a Specific File When Using Shell Function

    We are trying to setup a button that would open a specific application (MSAccess) and a specific file. According to my reference books, this can't be done - but we all know books are not perfect. Our current command line is: Call Shell(stAppName, 1) Where stAppName = "C:\Program...
  19. HMJ

    How To Use Multiple Criteria To Open Records?

    Roy: Even though the field name is 'Client No' it is a text field. This is the customers desire, not mine. I am currently home, but will try this first thing in the morning. Could you breakdown the structure of the 'and/or' multiple criteria statement? I barely understand the single...
  20. HMJ

    How To Use Multiple Criteria To Open Records?

    I have a form with a sub-form that works fine – up to a point. The sub-form is a datasheet listing of cases that are assigned to a specific client. So far so good. The sub-form has a button that will open the specific record(case) if clicked. NOT GOOD. In order to do this, I have to look...

Part and Inventory Search

Back
Top