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!

Recent content by mdex

  1. mdex

    Copy File Help

    Cheers Golom. Thought Environ was the way to go. mdex
  2. mdex

    Copy File Help

    Morning all, I'm trying to use access to copy a file from a network location to local machine. I can copy the file no problem with absolute path names but want to use environment variables for network users. OldName = "\\cottonwood\SomeExample.xls" NewName = "D:\Documents and...
  3. mdex

    Querying Subform From Textbox

    Thanks Golom, It works perfectly when I took out the errant & just after LIKE.
  4. mdex

    Querying Subform From Textbox

    I have a form with a subform postcode lookup. I currently have the SQL SELECT Sites.Site, Sites.Region, Sites.[Site Group], Sites.Street, Sites.City, Sites.[Postal Code], Sites.[Vetting Location] FROM Sites WHERE (((Sites.[Postal Code])=[forms]![Site Search]![postsearch]")); But wanted to be...
  5. mdex

    Exporting filtered datasheet subform to excel

    Sorry, They are only working in access to get the data out then manipulating it in excel.
  6. mdex

    Exporting filtered datasheet subform to excel

    There will be 3 or 4 people who will use the filter and export functions, each wanting at any one time slightly differing information. I'm still very new to access/vb after not using it for about 10 years so not up to speed yet. Couldn't get DoCmd.TransferSpreadsheet to work. Would it help if...
  7. mdex

    Exporting filtered datasheet subform to excel

    Afternoon all, Looking for a little guidance. I have a from that is used to filter data in a subform. The subform shows in datasheet view and my filters work ok. I have the following code to export the form to excel but it exports all records rather than the filtered results. DoCmd.OutputTo...
  8. mdex

    Emailing Form after update if check box it ticked!?

    Sorry I thought you Randy meant it would never be true or false regardless of quotes. Works fine cheers.
  9. mdex

    Emailing Form after update if check box it ticked!?

    Ok, so what value do checkboxes return? will I need to use 1/0 rather than true/false? Sorry, I'm not with my database at the moment to play with it. Thanks for all the help.
  10. mdex

    Emailing Form after update if check box it ticked!?

    I'm far from knowledgeable when it comes to Access but am teaching myself slowly. I'm trying to make a form email details of itself after update (saving/closing etc...) if a checkbox is selected. This is what I have so far. The code doesn't error but also doesn't send me an email...
See more

Part and Inventory Search

Back
Top