Search results

Thank you both for your advice. They worked a treat and have helped improve my learning of access. Cheers

Hi, Newbie question. Can someone please help me in the best way to display address fields on a report, where some of the address fields are blank. Want to show the address eliminating the spaces of blank data. I.e I've attached a sample mdb to help explain. I've got a table with Address1...

Thanks, i'll give that a go...

Running 2003 so could you please send me the example again saved as mdb. Many Many thanks JD

Thanks. Is there some standard code, examples etc to append the data and empty the temp table? JD

What if the actual Fund_Value was stored in another table (tblConsultants) and the adjustments table just held the adjustments? Could i then do an after update prodcedure once the adjustment_value was entered to update the field in tblconsultants? If so, what code would i require to do this?

I have an access table (tblSales) recording sales records. Each week i want to import new sales via a csv file into the tblSales table (automaically appending the records to the end of the table) What is the easiest way of achieving this?? Tried importing using the Get External Data >...

Probably didnt explain too well. The Under/Overs Fund needs to be a running total showing how much is in the fund as a total. Ie. Fund_Value is currently £100 You come along and put a new record in entering an Adjustment_Value of £50. The Fund_Value should then change to £150. Regards

Probably an easy solution but i'm a bit of a newbie and just need a little code help. Basically, i have a form SFrm_Unders_Overs which controls a finance fund for each salesperson. The form allows you to enter a Fund_Adjustment figure and i just want the Fund_Value control to auto update the...

Probably an easy solution but i'm a bit of a newbie and just need a little code help. Basically, i have a SFrm_Unders_Overs which controls a finance fund for each salesperson. The form allows you to enter a Fund_Adjustment figure and i just want the Fund_Value control to auto update the total...

Bit of a newby i'm afriad and come across problem where i have a form for entering payments (fund adjustments) and want the adjustment value entered to auto adjust the fund value control in the same form. I.e The fund value is $500, you enter an adjustment of $50 and the the fund value auto...

Hi I have a table 'tblRecords' and i'm trying to search against a field numeric field called BoxNumber and display findings onto a form. Basically, a 'Search - By Box Number' button on the switchboard opens 'frmSearch_BoxNumber' which contains just a combo of BoxNumber. When operator...

Hi, I need those records whose PeriodFROM and PeriodTO dates both fall within the date range chosen.

Hi. I have tblRecords which contains a 'Period From' & 'Period To' date field which i need to report against. On Switchboard, i've put a Period Report button which opens a form (frmMultiCalender) allowing operator to enter a TO & FROM date. Currently i have this TO & FROM data stored into a...

Hi. I have a number of linked tables which i'm trying to produce a report against. Problem i have is that when the opertator runs the report, i need them to be able to enter a TO & FROM date range which will look against the PERIODTO & PERIODFROM fields from within tblRecords and return just...

Hi, I want to display records in a Form, which displays data from two different tables. I.e. In the attached database, i have a frmRecords (data in tblRecords). frnRecords contains a CustomerID control which is a FK linking to the tblCustomers. The tblCustomers is where info like ClientRef...

Hi, I want to display records in a Form, relevant to the search critiriea entered by the operator. I.e. In the attached database, i want a button on the switchboard 'Search by Client Ref Number', this will bring up a box allowing operator to enter the Client Ref number. I then want to open the...

Correct one attached now

Hi, I writing a database to record all correspondance with customers. I've set up a CUSTOMERS table containing info like Client_Ref, Client_Name, Company_Name etc. Now from the main operator screen i've got a 'Create New Record' button which at the moment runs an [Input]=[Client Ref]...