Search results for query: *

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

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

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

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

Sorry, They are only working in access to get the data out then manipulating it in 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...

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

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

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.

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