Search results for query: *

Hi I have some code in my DB that opens up a file using the following code: 'Opens the file. stAppName = "cmd /c " & Chr(34) & fileName & Chr(34) Call Shell(stAppName, vbHide) Now the above works perfectly well when opening a file on my C:\ drive even if there are spaces in the directory...

That code works a treat... can use chr(9) to insert the tab delimiters etc so now just have to write some code to populate a nice long string and all should be good. Thank you very much one again Aceman!

Thanks for your responses... Unfortunately not I will be pasting the data into a completely different program. Aceman if you could point me in the right direction and I will do some research to see if I can get it working... I will potentially want to throw another spanner in the works later...

TheAceMan Another quick one for you then =) The code you gave works well however it copies in the column headings aswell. Any quick ideas on how to remove the headings? This is how it is coming through: Item Material # Customer Material No Qty UOM HigherLevel Plant Shipping Point Product...

I knew it had to be something stupidly easy. Thank you very much Ace Man

Hi I have a sub form currently that is in datasheet view and I want to setup a command button that when clicked will copy all the records from the sub form into the clipboard. I am essentially wanting to replicate going into the subform and pressing Ctrl + A (to select all records) and then...

I found a solution to this. Check thread http://www.tek-tips.com/viewthread.cfm?qid=310363

As there was another person in this thread looking for this info I shall post it here as I found the answer to my question. The following code allows you to open a new email and specify the Email address, subject, body, attachments and then still be able to edit the email before you send it...

anyone know how to do the above but just get the email composed in Lotus Notes and then be able to edit it or add additional documents before you send it? IE: automatically attach a document and set the sendto and subject line and then the user can add additional text etc.

I am also wanting to find a way of doing this and have been looking for awhile now. Hopefully a lotus notes person will be able to help out as I am sure you would just need to change a few bits of code so it doesn't send the mail automatically.

I have had a look on Google and found a couple of sites that seem relevant but they don't explain it very well. Do you perhaps have a website you can recommend or could you explain how RDS works? Thanks Mark

Hi Does anyone know of way/if possible that you can host the backend on the internet/remote machine and have the front end connect to it. What I am trying to achieve is that we have 3 offices and we want them all to share the same backend. Currently all 3 offices have their own backend. The...

Hi, For some reason when I enter To Do items they show up on the calander a day early. Everyone in our office is experiencing this. Any ideas? Regards Mark

But couldn't they create their own WIF and swap over to that one??? sorry still learning on security and that was my understanding.

and if you have smart users they can modify the shortcut and bypass the WIF and hence login on the default WIF and have full access/control.

FYI - forgot to update this post. I have solved this problem by creating the frmlistso form again. Did everything the same but this time it works perfectly... access bug??

have you checked to make sure the file itself isn't read only for some strange reason. Right click on the file when its on your pc and go to properties and make sure read only is not checked.

DoppyNL have a look at the website for Fineprint PDF and see if they have any support. Most have developers support and sample code etc. I used Win2PDF and their website contained some very helpfull information on creating PDF from VBA and about attaching them to an email automatically aswell.

I agree with Richard and another thing to look into is having any data that is static (Won't change) saved in a table in the front end. Will help with speed issues.

I run a bit of code that finds the highest number in the table and adds 1 to it. (Obviously to get the next number) I have this code on the after update event on one of my controls. I also include some code to save that record as soon as this is done. I found in a multi user environment if you...