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 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: Paul7905
  • Content: Threads
  • Order by date
  1. Paul7905

    Setfocus on a subform Question

    I have a form with one subform. The subform is in datasheet view, nothing unusual about it. The main form is named "OtherMain" The subform name is "OtherSubform" The subform source object is "OtherSubform" (same as it's name on the main form). On the Main form, I have a control button and...
  2. Paul7905

    Using "FindRecord" to Search a Sub Form

    I have a form with code that I use to find records containing a search argument typed by the user. The code resides in a small separate form used to type the search argument in and it works well. It will find any data in any control on a form that matches what the user typed. The form being...
  3. Paul7905

    Access db VERY slow to load using desktop shortcut

    Hello all. I have several access databases on my laptop. I am running XP professional and Office 2000 professional. I am experincing very slow loading of any of the databases if I use a shortcut to the MDB on my desktop, typically, after clicking on the desktop shortcut icon, I get an...
  4. Paul7905

    Very slow database loading

    Hello all. I have several access databases on my laptop. I am running XP professional and Office 2000 professional. I am experincing very slow loading of any of the databases if I use a shortcut to the MDB on my desktop, typically, after clicking on the desktop shortcut icon, I get an...
  5. Paul7905

    Validation text message not displaying (combo box)

    Using Access 2000 Have a combo box on form. Underlying data is table of numeric data. "Limit to list" set to: NO (want the user to be able to key a value not in the list). "validation rule" set as: >=0 And <=100 "validation text" set as: "You must select or enter a numeric value in...
  6. Paul7905

    server based antivirus question

    Recently tied our network into the internet via a broadband connection. Using a Lynksys router mpdel BEFSR11 connected to a Cisco 2900 switch. Our servers are Compaq (3500r and 1600r with 500 mhz cpu's) running NT 4.0 sp6 and Terminal Server / Metaframe 1.8. We are a small shop with about 8...
  7. Paul7905

    Any Recommendations

    Recently tied our network into the internet via a broadband connection. Using a Lynksys router mpdel BEFSR11 connected to a Cisco 2900 switch. Our servers are Compaq (3500r and 1600r with 500 mhz cpu's) running NT 4.0 sp6 and Terminal Server / Metaframe 1.8. We are a small shop with about 8...
  8. Paul7905

    windows colors question

    We are running Metaframe version 1.8 Have an application that displays pictures in .jpg format. When the application is run on Citrix, the colors are terrible, when run locally on a PC (or locally on the Citrix Server itself), they look fine. I looked at the settings in the neighborhood for...
  9. Paul7905

    Help advancing a line (skip) without printing detail

    Have a report that is going to be 3-hole punched and placed in binder. I am looking for a way, based on number of detail lines printed, to skip printing a detail record and to leave a blank line at the vertical postion on the page so that when the paper is 3-hole punched, the data in the row is...
  10. Paul7905

    Access Shell to Adobe Acrobat Reader?

    Have an access App. I have an access table in this application that has the file names of several hundred Adobe Acrobat .pdf files. User would like to be able to click on them and have Access Call Adobe to display the .pdf file. Is this Possible? If so, does anyone have any VBA sample code...
  11. Paul7905

    Search a sub-form(datasheet view) by keying start of field search arg?

    I POSTED THIS ON THE FORMS GROUP, NO TAKERS, SO I AM POSTING HERE IN HOPES SOMEONE HAS A SOLUTION I have a main form that contains a subform. the subform displays inventory items in datasheet view (subform must display the data in datasheet view per user mandate) Currently, user has to use...
  12. Paul7905

    Search a sub-form(datasheet view) by keying start of field search arg?

    I have a main form that contains a subform. the subform displays inventory items in datasheet view (subform must display the data in datasheet view per user mandate) Currently, user has to use the scroll bar on the subform to scroll to the inventory description they want so they can do some...
  13. Paul7905

    KISS way to force users to click a command button (faq702-2071)

    I have a problem where users may &quot;X&quot; out of access by clicking the X on Access itself (not on the form(s) because i have them turned off on the forms properties). When the users do this they circumvent ceratin operations in the close event for the form(s). I tried the technique...
  14. Paul7905

    How to setup a Peer to Peer connection

    Hola ! I have two computers, both are running Windows '98 (vanilla '98, NOT ME or SE) One is a laptop, one is a desktop. Both have 10/100 ethernet adapters in them. I routinely connect the laptop to a workplace NT network and that works fine. Now i want to be able network my home PC to My...
  15. Paul7905

    Need &quot;RunCommand&quot; Ghuru !

    Scenario ~ I am Using Access 2000. Looking for a way to bring up the Access Export window using VBA. In help, I found the &quot;DoMenuItem&quot; command. Reading Help, this command was available in earlier versions of Access but has been replaced by the &quot;RunCommand&quot; argument...
  16. Paul7905

    Need a &quot;Runcommand&quot; or DoMenuItem Ghuru !!!!!

    Scenario ~ I am Using Access 2000. Looking for a way to bring up the Access Export window using VBA. In help, I found the &quot;DoMenuItem&quot; command. Reading Help, this command was available in earlier versions of Access but has been replaced by the &quot;RunCommand&quot; argument...
  17. Paul7905

    Permissions Question~

    Scenario ~ I have an access 2000 database running on a compaq proliant server running nt 4.0 terminal server and citrix metaframe. Access 2000 has a facility that provides for the compaction of the database upon close. In a nutshell, the compact basically copies the database, compacted, to...
  18. Paul7905

    Any way to invoke the Export Wizard from VBA? (in access 2000)

    I would like to be able to invoke the Access 2000 Export Wizard in VBA. What I would like to do is start the Export Wizard in the click event on a form and pass the wizard the name of a table (or even better, a query which wold be driven by paramaters the user chooses on the form) in VBA and...
  19. Paul7905

    How to get VBA code to pause until another activity is complete?

    I have a question regarding getting VBA code to pause or wait for another process to complete. Here is my dilema: I have a form (let's call it Form1) with a command button on it which runs some VBA code in the on the click event. In the middle of this code, I may determine that it is...
  20. Paul7905

    Question Similar to &quot;Macro Too Fast&quot;

    I have a question similar to one of todays posts where someone needed to get Access to wait a while for another process to complete. Here is my dilema: I have a form (let's call it Form1) with a command button on it which runs some VBA code in the on the click event. In the middle of this...

Part and Inventory Search

Back
Top