Recent content by SeanITFC

Hi all, If anyone has a VB program to code a command button to look-up Customers' surname from a table from entry of text box eg "Smit*" , I will be eternally grateful....... Thanks SeanITFC :confused:

Hi all, I have a Video rentals table which lists all transactions. Using a 6 month querry & group by video number querry I have achieved trhe following list: Video number.....Title........Cost(£) 6.....................Bond..........2 6.....................Bond..........2...

Many Thanks Jacob Many Thanks for your help SeanITFC :)

I am looking for the VBA code to backup the (current/open) database to another folder in the c:/ drive. It will sit on the on click event of a command button. Many Thanks SeanITFC

Many Thanks Many Thanks for your help

Hi, In access help I've found the phrase for 6 months from todays date: Between Date() And DateAdd("m",6,Date()) But what is the phrase for 6 months before todays date (Not 'DateLess' or 'DateMinus') Thanks SeanITFC

Hi all, I am currently trying to program a video hire form for HNC Project. The form loads from two querries: the main form from 'Customers' table; the subform from 'Rental records 'table. The form loads fine with the main menu scroll bars running through the records.....but I need the form to...