Search results

entering new records each record will have the same school number. any way to replicate this school number for each record in a form, rather than type it for each new pupil record... at present the form is a query as the user has to type in the school number to check whether the school is...

re not sure what you mean about class modules. but I do not have anything in the modules section. I have a form that sends out an email through outlook, also a few forms with clipart, and a couple with Gif animation. but otherwise nothing ovretly different.. I agree it is a bizarre...

right, this is a good query!! I have a 97 database which I copied and then tried to convert in access 2000. firstly it would not convert. said it had undertaken the convert but did not write the new file to the hard drive. secondly when I open the file as a 97 file within 2000 I lose all the...

missed a variant! travis many thanks missed changing one of the strings to a variant... so it works perfectly now. am very appreciative of all your help. kind regards John

the invalid use of null occurs when the text boxes are checked for content and the fIsBlank routine is called. I tried the variant idea but still had a compiler error. if the boxes are all strings can I not just remove the Is null statement? when I try this it still does not run, and I still...

Old Topic - New Problem!! can anyone help with the following syntax? Tim kindly helped previously but time is running out so would be very keen for any pointers at all. I am receiving a "invalid use of Null" error when I run the code. have played around with the code but to no avail. can...

Null problem Tim I have run your code, and all seemed fine until it called the field blank routine, and I had a invalid use of Null error occur. my text boxes are a variety of different data types would that cause the problem?

many many thanks! cheers for all your help, I'll give the syntax a go.. very kind of you to help. cheers John

apologies, did not explain myself fully in the earlier posting. situation is as follows. I have records that used to be recorded on a spreadsheet, they are all now in a database. the job number field has now been added. I want this number to continue from where the last job finished which...

two queries really. 1. i have code attached to this posting which emails data to a user. this all works fine no problems at all. but the email sends anything from 1 record to 10. does anyone know of syntax to put in that will make the email only pick up records that are not blank? I tried an...

how would the syntax for the email pick up the report? would it be as an attachment? one of the requirements is that the resulting email has the data within the message section not as an attachment. J

good question! mainly because I could not find a way of linking a form to a query. I have an email code which I need to declare the txt boxes with the syntax so the email can run off the form therefore the forms run off the query, I can the final form will pick up the data from the form which...

apologies, can you explain what that exactly means and entails? many thanks J

have sorted the problem. hayley, many thanks for your offer, think I have sorted the problem by running a form off each line of the query and then linking the final form to each individual form. a bit clanky and slow but it does work. many thanks. john

many thanks! cheers brad, I agree coding would be better, still finding my feet though so dont want to bite off more than I can chew! thanks for the syntax and tip about the queries. J

I have some syntax which sends out an email. the email can list up to 10 projects my code at present only covers two projects but the email only sends out the details for the second project and seems to ignore the syntax for the first. I attach a txt file of the code. can anyone see the error...

I have 10 queries and 10 forms which populate a final form. as the user does not need to see these queries/forms. (a macro opens and closes them) is there a way to have the forms and queries running in the background so the user sees nothing but the final form. I can open and then use the...

thanks... cheers for the attachment. what I am really looking for is this... I already have an exisiting form which links to syntax for an email. I need to populate the form with data from a query. each line of the query is a different record. so I have up to 25 lines in the query. my...

cheers! thanks hayley problem seems to be ok at the moment, really does seem to be a random event that happens occasionally. and our winzip is playing up so can't seem to zip up the mdb to put on the forum. if the problem rears its ugly head again, I'll send you the zip. ta John

doh! how painstakingly obvious! many thanks, that solves my problem. cheers John