Search results

i would be if i knew where to start

so there is no way of knowing explicitly what the error is if it only occurs at runtime and doesnt give an error number how are we to know how to rectify it?

it is really - cos i still havent solved it

how does this differ from the packaged version?

could someone explain to me what the runtime command switch is and where to find it? thanks

ok thanks for your help

im not that usedc to error handling and find it ard to predict what the error might be - if the routines work ok without errors how do i predict what might go wrong?

that seems a bit difficult when i dont know the actual cause of the error

well i tried Resume Next thinking that this would override the error but it doesnt seem to work

i did wonder afterwards if that was my problem - i found it happens on two other buttons that print reports i guess its a little scraPPY of me not to be using error catches thanks for the reply ill get on it right away

i have a main form with a button that opens a simple form of 2 columns. this all works fine as an .mdb file but when i create an installer package to use with access runtime i have a problem - when i open the second form it shows on the screen but has a runtime error and when the error box is...

ive had a look at this but cant figure out what it does - so many quotes within quotes - could you explain how it works please? """""" & Me!comboCourse.Value & """"""

thanks very much - it seems to have done the trick right away - il ltake a proper look tomorrow and see what it does and how it works thanks again

I have a simple combo box in a form which lists corses stored in a table Since new records tend to be inserted en bloc for a particular course id llike the combo box to retain the last course name and insert it in the default value of the combo This would automatically populate the combo with...

yes thats right - Email is the name of the textbox so that it sends to the saved email address for that person/record - ive just had to send an apology to the person concerned -- they will have a stack of test emails in their inbox - not a good day so far thanks for your help

sorry to be giving you false info -- ive just realised that im using the wrong record and sending the emails somewhere else lol but it still opens the vb screen if left in the background obviously not a problem when fully working -- but i stil lwonder why its doing that

oops i did that but still doesnt send i put a stop on the last line and looked for the file - it does exist in the directory also i tried .Display instead of .Send and that works???

can i butt in here stopher? ive tried your code changing it to rtf format but cant get it to work - when i click the appropriate button it either goes through the motions (i see the message box for a split second) then nothing, or it opens the vb screen but shows no error any ideas? thanks...

i just made the changes as advised and in a flash it all works perfectly -- i hope thanks again

there is indeed a reference to that form in my query i think i need to clean this up since ive tried so many different ways to make it work that specific line you refer to has always seemed problematic and ill try your version youve been a great help - thanks