Search results for query: *

Thanks guys your comments have been really helpfull your help and advice is appreciated

Hi All I have a strange one: I run the following with set deleted on SELECT * FROM GHDD3 INTO CURSOR RESULTS WHERE alltrim(UPPER (ghdsname)) = "SHIT" WAIT WINDOW STR(RECCOUNT('RESULTS')) the wait wind shows 0 when i run the above with set deleted off the wait wind shows the...

Hi Rick I don't want to open the file as The file gets open by the user and I need to know if the user has accidently left the file open. sorry if i seem a bit stupid. i dont really understand fopen() Thanks for the reply Nick your help and advice is appreciated

Hey all Just a short one. is there away i can test to see if a specific file is open. Many Thanks Nick just in case it helps. the file i need to know about is a excel file. your help and advice is appreciated

sorry code is WHERE (alltrim(pdssname) = 'SMITH') just a typo your help and advice is appreciated

Hi Mike Thanks for coming back so quickly my code is as follows : SELECT PMDDLADD, PMDMGACC, FULLNAME, COMPANY, PROPER(ADD1), POST_CODE, PMDMGCDE, PMDPYVAS, PROPER(STATS), PMDSBSIS,PMDSBEIS, PDSCSACC, PDSRCACC, PMDMGSNO FROM SITPERSUB ; INTO CURSOR RESULTS...

Hi All My employer has just upgraded to fox 8 and i have an application that uses sql statements that worked fine in ver 6. Having a read of recent threads i discover that you have to issue SET ENGINEBEHAVIOR 70 however it would still appear that this does completely solve my problem as the...

Hi all could any give any suggestions on why, when i print a mailmerge of more than a few hundred records it seems to print the first hundred or so fine, it then starts to print random characters over the page including the text im prining, then eventually only it prints random characters over...

Hi All I don't use Access so dont really have a clue where to start looking. So if you could point me in the rigth direction or give me some sample code it would be greatly appreciated. so here goes the question. An employee who used to work for my current employer wrote an export/import...

Mgagnon I have used the above code in previous code and it works great when i am saving an attachment onto my c:\ drive. The trouble i am having at the moment is that i want to save the attachment into an outlook folder. To manually do this you select the attachment(the email was sent as an...

Hi My problem is : I receive an email with a number of attachments. All the attachments are emails. What I need to do : Move the attachments from the email to a sub folder in my inbox(Remember all the attachments are emails). I have the code to check if an email has an attachment i am...

could also be that when testing your code you had an error in it causing you to hold on to the file and excel without you knowing try pressing alt+ctrl+delete to see if you have excel running still your help and advice is appreciated

just a suggestion why dont you automate sending an email your help and advice is appreciated

Hi all The problem i am having is that i need to print 1 mailmerged document several times. The trouble is that at the top of the document i have a company logo which is not always the same is there a way in which i can pass a mailmerge field with the filename of the logto and call it for its...

HI I am going through the process of learning VBA so if the following question seems abit simple. how can i go from page1 to page2 when the user clicks on a commandbutton Nick your help and advice is appreciated

Thanks all for the replys just another question i tried out html help workshop and created a dummy .htm in word. what i did was put a couple of lines of text and inserted an image then saved it as a html file. I then attached it to my help project and clicked view compiled help after compiling...

Hi I am looking for suggestions on what kind of software is out there to assist with creating help files to be used with my applications. I imagine that there are several applications out there so pointing me to the advantages of each kind would be of great help. The kind of stuff that will...

** current lock code set reprocess to 1 if rlock() = .f. messageb("someone is updating this record") return endif ** current unlock code unlock in alias my problem is that some freak occurences have meant that a user has not unlocked a record but has got out of the application ie...

Hi I have a multi-user application that is stored on a server the application has an edit notes fuction which when pressed performs RLOCK() which if the record is locked gives the message 'someone is editing this person' the record is then unlocked when the user clicks save. The problem i am...

My apologies i was being a bit of a flid i have sorted the problem out it was a case of double checking that i was right in what i posted and i was not sorry! thanks for taking the time to respond to my thread thanks again your help and advice is appreciated