Search results

Hi everyone Is there a way through vba we can set the parameter so say i have table of 1000 records how would i get to pull 100 records or 50 records or 10 records i want a parameter box to come and ask me how may records i want to pull out!!!

ahhh thanks a lot thats working all fine :D

ive figured why its doing that its becos it selects the the first field data in post date and just puts that date in all the others, so if the first field is blank then its a blank insert which is not giving me the right dates any ideas how i can get around this!!!

Thanks that worked fine in the test data But when im using it in the real database, its not working it selects the right fields but doesnt insert the date any ideas why??

Here is a sample database I have to have duplicate customers and i usually have thousands of records so i cant just manual add the date if already added

I add the date with an udate query I give the customer an auto id number

not quite sure what you mean could you give me more explanation please ill write the problem out again maybe it will clear things up but i really need some help on this if i have a main table with customer no and postdate if customer no has been sent a letter a date is added. if the same...

is there no one that can help???? :(

Hiya All i have just registered today but i cant find what im looking for. i have a database that sends out reports to our customers when they get made an offer, then what i do is add current date to indicate i have sent the report. but when i get the same customer again i dont want to send a...