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 Mike Lewis 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. paulbasi

    Create table query and relationship

    Hello, I have a couple of tables, one called tblUsers and one called tblQTdb I have a query that creates a table called tblCurrentuser. The query uses the logged in user's ID to pull additional information for that user. I want to use that table and pull the UserID from it and pull information...
  2. paulbasi

    Combox box base on previous combo box

    Wow, this was excellent. Thank you so much for this little bit, it helped me greatly. You have made my Friday much better. Have a great weekend! -Paul
  3. paulbasi

    Combox box base on previous combo box

    I was finally able to upload this file and can be found at: http://www.savefile.com/files/1674718 Thanks againhttp://www.savefile.com/files/1674718
  4. paulbasi

    Combox box base on previous combo box

    Please don't take this as me having someone do my work for me. I feel guilty about this but I'm stuck. Here is a copy of the db I can't seem to attach the db as I'm behind the company firewall and it won't allow me to upload anything to a website. I will need to email this to myself and upload...
  5. paulbasi

    Combox box base on previous combo box

    TheAceMan1 , Thanks for responding. I think I'm just stuck in an endless loop here. I know it's probably something very simple and I'm just too stupid to figure it out. I think I'm going to have to go and buy a book ... do they publish one "Access for dumb asses"? :) Cheers and thanks for...
  6. paulbasi

    Combox box base on previous combo box

    Thank you for the responses. I don’t know why I just can’t grasp this. I have tried the sample that you have given me and of course my tables are different so I substituted names but it just won’t work for me. I have been trying to get this to work for more than a week and I am now totally...
  7. paulbasi

    Combox box base on previous combo box

    It’s been a few years since I have worked with MS Access so please forgive my newbeeness. I am trying something very simple and I have done it before but for the life of me, I can’t remember how. I have searched for over a week and just can’t seem to make it stick in my head. Here is my last...
  8. paulbasi

    Copy contents of a cell containg time/date

    Thank you ... exactly what the doctor ordered!
  9. paulbasi

    Copy contents of a cell containg time/date

    I’m trying to dump a text file from an Excel sheet with calculated results. I need to do some time calculations and then take the results and export them to a text file. Here is a simplified example of what I am trying to do … A1 = start time B1 = duration C1= end Time (calculated) D1...
  10. paulbasi

    VBA Module Size

    Thank you very much for the quick reply Steve. Will this still not cause the same size error? I can tell that this will definately reduce the size by a few lines however, one would assume that limits would still be in place. Thanks again
  11. paulbasi

    VBA Module Size

    I'm writing a SUB PROCEDURE that has many IF THEN ELSE staements. As a matter of fact, there are too many and I am getting errors. Is there a simple solution? Here is a quick run down on what I am attempting: When I open the form, it hides certain fields and displays others ... The section...
  12. paulbasi

    CDROM drives disappeared.

    Hello jhumbo, If you have not found a resolution to your problem ... do this. It's worked for me! Step 1: Back up the registry 1. Click Start and Run. Type in REGEDIT and click OK. 2. From the Registry Editor window, doing one of the following depending on the operating system: Windows 2000...
  13. paulbasi

    =Environ("username") in Access 97

    Hello, I am using this in my DEFAULT value in a table from a tip that I got here. I tried it at home running Windows XP and it works great. However, at work where we have users with Win95, NT4 and XP, the default will not work with Windows 95. Can someone please give me some guidance...
  14. paulbasi

    On no data in form

    Hi there, I have had the same situation where if there were no records to display only a blank form would show up. To resolve this, I created a bitmap with text that explained to the user there were no records and then used that bitmap as the background for the form. Now, if there were records...

Part and Inventory Search

Back
Top