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

    Updating Response Table Using Other Input Tables

    Yes that is what I am trying to accomplish. So I want to have a list of 5 items in a combo box, but on the main table which will be the data input table I want to have the field in the table that the combo box populated to be blank initially, yet have defined values in the combo box selections...
  2. tps131

    Updating Response Table Using Other Input Tables

    I have what I think is a very simple question, I haven't used Access since college so I am trying to re-learn it for a project....I have one main table that I am collecting user input from, however I have a series of combo boxes that have prepopulated values identifying certain threats. I have...
  3. tps131

    Excel Conditional Formula

    Another issue has also surfaced. What would be the easiest way in an excel formula to combine two criteria. Example, now within the overall group(1st criteria "C") want to cut that down by (5)days(2nd criteria "G")...This is what I think it would look like but it isnt working. Any suggestions...
  4. tps131

    Excel Conditional Formula

    That worked, Thanks alot
  5. tps131

    Excel Conditional Formula

    I have a large excel spreadsheet where I want the average number of days an issue was opened to be calculated based upon the type of issue. I have a formula that calculates the count of the types accurately in one column, now I need to have a count on another column based upon the value in the...
  6. tps131

    multiple name selection in VB

    I have a simple question about VB coding for an access application...I had it working with one user but cant get it with multiple users...I want to be able to check a table and if the users name is in this table I want to unlock a button on the application..here is the code that works with one...
  7. tps131

    TWO ISSUES

    I got it to work...issue was I had the default value and control source all messed up...Thank you for your help
  8. tps131

    TWO ISSUES

    First one worked...it is displayed but it wont save it to the table where the other data is being saved since it is referenced to the other form not the table
  9. tps131

    TWO ISSUES

    Problem I am having is I have a form where you add new projects, containing a project name and autonumber projectID, The project is the highest level in the database, next I have a screen that comes up where you add the requirements for that project into a table..Very simple idea but having some...
  10. tps131

    2000-XP

    Yeah thanks alot for your help!!
  11. tps131

    2000-XP

    This was the first real application I built with Access in a long time so here is what I have checked in the for references going to Tools_References in the Code Window of Access Visual Basick for Applications Microsoft Access 9.0 Object Library OLE Automation Microsoft ActiveX Data Objects 2.1...
  12. tps131

    2000-XP

    I looked it up it seems like it is part of the operating system thats why I was thinking maybe it was a conversion problem..I didnt think there would be a problem opening 2000 in XP either I thought the only issues arose when you downgraded..Only thing I could think was Access wasnt installed...
  13. tps131

    2000-XP

    No files were added to the application it is saved as a normal mdb file I believe, and i zipped it and sent it they got that error
  14. tps131

    2000-XP

    I created a project in using windows 2000 and Access 2000, client site uses XP, sent the application for them to look at and give feedback this is the first of many errors the receive when trying to open the application..."Your app database or project contains a missing or broken reference to...
  15. tps131

    Security ??'s

    That would come in handy once this is distributed outside, how do you create a MDW file? Thanks
  16. tps131

    Security ??'s

    Henry,How can you link that feature to an existing table with user information?
  17. tps131

    Security ??'s

    Yeah that does make sense, I have been working on it this morning and came up with a way to disable the buttons with a password that would be supplied to the admins and users, but that still doesnt prompt the user for their names or individual passwords. Is the code complicated?
  18. tps131

    Security ??'s

    I have never used any security features in Access and I have a program that I am developing that requires admin access and user level access. I used the built in security wizard and it was useless for what I need to be done..Basic overview is I have a table with all the users info (i.e.Name...
  19. tps131

    Export to Excel

    I have a form with infomation that users are going to be inputting into a combo box and two or three text boxes..I want to be able to have the user after filling out the form to click on a command button and export those fields to an excel spreadsheet from there an admin can review responses...
  20. tps131

    Combo Box Control

    I get this error when I use that procedure.."the expression you entered produced the following error..The object doesnt contain the automation object 'Me'.

Part and Inventory Search

Back
Top