Search results

dont worry Pat, I have not gone completely mad... it was a last resort action to try and solve this task which is almost like recreating a MS Project GANT chart from an access table.. the table is stored presently in NF, but it would not link itself to a report of this nature.. BUT my...

try this you could have the report being run off a query. in the query have the fields you want and under the checkbox field put a statement such as. Forms!Yourform!checkbox!= True so you have the form, the user checks the boxes, put a button on the form to lauch the report , the query uses...

I reviously posted a query, but have changed tack ab it on how I am going to do this so have deleted that and started afresh.. I have a table which has project description as column1 and then many columns after it with the start date of each week between now and the end of 2005. I then have a...

well I dont normally have much confidence my own ideas but.... we have the same thing at my work with mass emails so the way around it is to do 1 email to all recipients using a loop on the recordset.. actually Mile you helped me with this.. a while back methinks.. although of course...

hi rich, nice to speak to you again, have been in france so have not been on the forums recently, I managed to fix it by selecting all reports to print to adobe acrobat and then putting them all back to one of the office printers... it would seem that you need to do the autocorrect fix and...

same problem Hi, any ideas on this? I have the same situation, have tried the autocorrect feature and nothing changes, my reports are all in landscape but come up as portrait, am running office XP with Access 2002 am really really stuck, it works fine on the laptop I have and then when I...

Hi all, I have been struggling with a querydef problem.. it works fine for one part of my database where the query is based on a organisation name (string) but for this part I need it as a number, I have tried changing the var declaration but it does not help, is there a way to solve this? at...

cheers! would i do this with a recordset? I can understand the principles behind it.. but am struggling with the code for creating the new records... assume it would be where you add a new record in the loop till the count = the higher number of the two? I'll give it a go and post back in...

ok.. not sure if this is possible (like most of my queries I post!) I have a dbase where the idea is that the user enters in the batchnumbers to be processed by our data entry team.. i.e 1-10, 14-18 then I am looking to get the dbase to take these numbers and append records to a table with...

a gem of a website! http://www.asterix-obelix.nl/latin-uk.htm

better than my quote for sauerkraut and leiderhosen in german! Vinum et musica laetificant cor aramaic is pushing it too far!

think my brain is out of the loop!! cheers! not sure I can think of a witty response in latin for you.. like the new avatar though...

ta! Cheers Mile.. I really appreciate the response.. saw you had touched on the idea of this previously in another post.. so am glad you responded.. but am still getting only 1 recipient in the email.. below is the code I have adapted with your additions.. I am missing something basic here...

ok.. this is not a "how do I email" question I promise! I have this code which sends off multiple emails.. fine and dandy.. But... our systems here have a virus protection which means if you are bulk emailing from access through outlook for every email you send you get a msg saying this...

not sure.. a light bulb came on in my head and thought maybe this might help.. like you say there is no other way.. but it should not matter how it is stored.. you could have a shape table with shapecode i.e. r and then shapedescription which would be square etc etc.. of course if the users pc...

useful? hmmmmm this might be off the mark a bit.. but could you not use a font such as dingbats or wingdings to pick up a square or a triangle or something else? just make the combobox like normal.. with the letter which corresponds to the symbol in wingdings i.e. r = a rather nifty box...

just at the end of the docmd.sendobjects section, change the flag to false.. that stops the preview and sends it straight away.. glad it helped. john

you could adapt this maybe... Private Sub Command10_Click() On Error GoTo Err_Command10_Click Dim strTextMessage As String strTextMessage = "DATA AS SUMMARISED ON QUALITY ASSURANCE FORM NOW AVAILABLE ON THE X DRIVE" & Chr(13) strTextMessage = strTextMessage & "PROJECT TITLE :- " & Me!txt1a & "...

may be a stupid suggestion have you tried putting a space between the addresses, when outlook confirms that it recognises the email address it normally adds a space.. it is a shot in the dark.. but might be worth a try.. John.

dont know if this will help or not... I found that when exporting to excel that if the file already exists and that the user has modified their copy with some formatting or formula's then the export would fall over.. John