Email

still stuck and i have just tried to burn what i have to cd and guess what! its set to read only and wont allow me to set it any different!! cant fix that either!!!

so so close yet so (swear word) far!

I already put this off by a couple of weeks and they are expecting it today now!!! ... really really dont want to put it off anymore so if someone/ anyone can help me with the looping through the list box bit and/or this attribute thing i would be so so very greatful

isa sleepy girl now :(

oh guess what else i've gone n done :rolleyes: i've taken my course selection inc. verry large databases :rolleyes: UH OH :p
 
Hi


Lynsey, Still looking at the list box thing, however the CD problem is one that i have come across before when i was at college handing in assignments and unfortunatley the only solution i know is to package the db in an installer.

As CD's are (usually) read only the default is readonly, I have tried viewing the Db on a read /re-writeable cd on a read /re-writeable cd burner. i.e you can use it like a harddrive(bit slow!) and it seemed to make no difference once it's on CD its read only.

I just left a note (In the documentation , got to look like it's not an after thought!!) saying once installed please goto the properties view of the DB through windows explorer etal and change from readonly.

You could try searching on here for thread about free installer downloads, i found this thread but have not tried the software.


Here

I'll get back to you if i can help with the listbox

Chris
 
Hello again

i tried this and it seemed to work.

Dim rst As DAO.Recordset




Set rst = CurrentDb.OpenRecordset("qryDynamic_QBF")


' just in case it isn't populated fully
rst.movelast
rst.movefirst



Do Until rst.EOF = True
strEmail = strEmail & ";" & rst!
rst.MoveNext
Loop

'lose the last ";"

strEmail = Left(strEmail, Len(strEmail) - 1)


EmailSend.Bcc = strEmail


I did get an error on:

EmailSend.Body = Forms!frmSelect2Email!EmailTXT

basically it doesn't seem to want to work if EmailTXT is null??

so use the Nz(Forms!frmSelect2Email!EmailTXT,"No Message")

Chris
 
Last edited:
Thanks very Much! Im just off to try that now! Had to go in to the shop and pay the wages and do the stock counts and money and stuff this morning first but im on the case now... thanks so much for your help!

Can you lot use the Database i have attached??
 
how fantastic are you... If i could kiss you i would! thanks more than a million! it works!!! WOOOOOOOHOOOOOO! YEY YEY YEY!!:D :D :D :D :D

know what though next time im going to climb Ben nevis (much easier):p

was thinking if i took the cd then started a new database on the companies computer and exported all the tables and stuff would that not solve the read only thing???
 
Hi

Glad that was of some use,:D ,


There's no need to create a blank db and import etc you can just copy the DB onto the server/hardrive and then view the DB properties in windows explorer and take off the readonly check. You could try ziping the file and then copying it to the CD. It's possible that this would prevent the readonly thing occuring. May be not seeing the whole DB here but if you can post the Zipped Db here will it not fit on a floppy??


Chris

PS: I think this post maybe some sort of record outside of the watercooler. Lots of kisses to go round??. :D
 
oh i got a wee bit click happy and added wee extra bits to it so heres the final thing!

It works if you save it to your "My documents" or whatever.

have fun playing and working it out

Millions of thanks to everyone that helped ... not going to list you all incase i forget someone, by mistake.

love you all loads,

Lyns xxx
 

Attachments

Users who are viewing this thread

Back
Top Bottom