Search results

Hiya im trying to add new records from one table to another, this will be done on a weekly basis. What i need to do is add new records to exisitng table according to Student Number, but because the same student can apply to many courses i need to allow duplicates I get error "Duplicate output...

thanks guys its working all very well

i know this mite sound silly but can u go into a little detail about how to do that

yes exactly,

i have set the property to can grow yes but it pushes the letters down e.g. i get:- miss a atkien s h l e y any other ideas?

hello have a quick short question i have 3 txt boxes (title, name, surname) placed horizontally in a report, i know we can do this vertically but is there anyway i can get them to resize according to the length of letters? or is not possible? thanks

its ok i did by reading another thread i didnt see before all u do is set the height property to 0 and can grow to yes then pop them in one text field cool

Hello Everyone On a report i print the address from sql query the format is address line1 address line2 address line3 address line4 address line5 Country Postcode as address sometimes dont have all lines, sum fields contain no values so on report it puts a blank line, is there a way i can not...

i get it what i did was added extra criteria to find null fileds and only add todays date to them thank you very much for your time and help hopefully thats the end of it :rolleyes:

hiya theres another problem when new records are addded i dont wont the dates to change, so if i find that more students have withdrawn 2mo i want to keep the dates as they were yesterday and only add dates to new records how can i do that?

cool thanks very much for advice it worked fine

thanks for reply i dont understand because i have so many records i want to insert the date automatically in the date field so say i have a table "withdrawn" with filed "name" "address" and "date" when i find all students with a query that have withdrawn how will i get each date field to fill...

Hiya i want to add todays date automatically after selecting some fileds so say i have records of students, by a sql query i can select all the records when students have withdrawn but then i need to add todays date to the "date field" for each record, does any one know how i can go about doing...

ahhhh i see, i got rid of the error msg :D thanks for your help

Hello every1 I have mostly read all threads on errors when appending records but i have no solution im trying to add new records from one table to another, i can do this successfully but i get the following error "Microsoft Office Acess set 0 field(s) to Null due to type conversion failure...