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 derfloh 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. Page410

    VBA Clipboard Manager

    Working with ranges and selections is one of the options that I am looking into. It may end up working in this scenario. I would still be very interested in a clipboard object to work with however.
  2. Page410

    VBA Clipboard Manager

    Combo, It is a home grown in house application written in VBA. The Access application opens and populates data into MS Word templates. It also copies content from one template to another. I'm currently investigating a couple of different options but ideally, I would have a clipboard object...
  3. Page410

    VBA Clipboard Manager

    Issue: Current process uses MS Access, MS Word and the Windows clipboard to create correspondence. Because of the way that the clipboard is used I can only have one of these processes running on a machine at any given time. If I try to run more than one, I run the risk of incorrect data being...
  4. Page410

    Copy record and all related records

    I was wondering if there was any way to identify and/or copy all records related to a record being copied. Let's say I have 5 tables A,B,C,D,E My goal: When I copy record A1 to create record A2 I would like to identify all records in B,C,D,E (if they exist) and create records in those tables...
  5. Page410

    gather sql code output and randomly use

    I'm deducing that you simply want to grab a record at random from your dataset. I Performed a Google search for 'ms access return random data' and found this link in less than 30 seconds. http://support.microsoft.com/?kbid=210468 Check it out and let me know if this is what you are looking for.
  6. Page410

    Does someone have this spreadsheet open??

    Prior to generating a new excel file try to delete the existing one with a Kill command (Kill "C:\My Data\myfile.xls"). Just trap the resulting error when someone has the file open (probably permission denied) and deal with it accordingly.
  7. Page410

    List all AccessObjects regardless of object type

    Have you tried to simply query the MSysObjects table. You should be able to get something from that.
  8. Page410

    Hyperlinks not working

    Can you post the code for how you are trying to open the file?
  9. Page410

    Acrobat ActiveX control Hide Command Bar

    Try changing the the following property of the control. .setShowToolbar (False)
  10. Page410

    How to view acrobat files

    set the src property for the control to the file path of the pdf file.
  11. Page410

    Looping through file items

    Here is a snippet that should help. Just make sure you add the Microsoft Scripting Runtime reference. Function LoopThroughFiles() On Error GoTo ErrorHandler Dim sysObject As FileSystemObject Dim sysFolder As folder Dim sysFile As File Set sysObject =...
  12. Page410

    Clean Up of IF..Endif, etc.

    ...Price and then break them apart for testing below. curDiscountedPrice = (cboMaterial.Column(2) - (Round((cboMaterial.Column(2) * 0.06), 2))) curChangeAmount = Format(curDiscountedPrice - Int(curDiscountedPrice), "#.#0") curDollarAmount =...
  13. Page410

    Check if control exists

    For my information, what would the advantage of passing the reference be?
  14. Page410

    Check if control exists

    Here's a quick little function that will check if a control exists on a form or subform and return a boolean value. I've used it to check to see if recordset field names are used as form control names, updating the recordset with the form value when I have a match (let me know if anyone is...
  15. Page410

    Trap errors from pdflib

    The pdf activex control doesn't include an error class. Does anyone know how I can trap these errors. Has anyone out there already written a class module for this?
  16. Page410

    Keep track of RS!!!

    I should have mentioned that you should capture the max UID to update to the global or hidden form.
  17. Page410

    Keep track of RS!!!

    Do you have any kind of sequential identifier (UID) on any of the tables involved in your query? If so, you could assign the UID to a global (make it a long) or even a hidden field on your form (Default of zero). In your criteria for the query, include this field and apply criteria...
  18. Page410

    Delete Then Relink Tables!

    If you don't use the link table manager you could always query against MSysObjects to get the table path before you delete the table and then use the path to re-create your link. This sql will return the name and path for tables linked to other Access DB's SELECT MSysObjects.Name...
  19. Page410

    Null value handling in Access 2003

    I'm not sure that a check box can be assigned a null value in Access. A check box is a boolean control and will always be equal to one of two values (True or False, Yes or No, -1 or 0). Weird that your users would not be able to change records without making a selection. Does the field that...
  20. Page410

    MsgBox with a Scroll Bar?

    PH, That worked great. note: setting the SelLength to 0 also means that I don't have to set Behaviour entering field to Go to start of field, which can be a pain when working with tables. Thank you all for your assistance. Mike

Part and Inventory Search

Back
Top