Recent content by kesam

Different, but more fun!! Not quite the same thing but I added this to the main form on a db we use in our office. Keeps the staff happy (or maybe they're just humouring me!!). Really simple, just creates a random number on opening then gives you a pop up form showing a record from the fun tbl.

This Month One way to do it would be to make your report a subreport of another which picks up only this months figure and displays it in the header. You can get this months figure by using the "currentdate" and "month" functions in expression fields. Probably not the prettiest way to do it...

it returned an error from that line of code Rich. Anyway though I thought all along there was probably an easier way but couldn't think of one. I tried basing the subform on a query which brought through the correct detail but as you need to input detail that didn't work. I do like to figure...

Rich, This is what I have in the control source which brings up the relevant supplier names for ease of use(asoppsed to just the supplier ID. =DLookUp("[Company]","TBL_Suppliers","[Supplier_ID1] = Forms![FRM_UPDATEVAL_sub]!SUPPCODE") The master and child are linked via the reference number...

Hi, Have searched in vain for most of the day for a solution. I have created a form which includes an unbound textbox which has a dlookup as the control source. This works fine when viewed "stand alone" however when I use it as a subform the DLOOKUP fields return an error. All of the other...

Users on the DB I've set up input a few different kinds of data. there's a form for items received, one for amendments, one for non conformities etc. A report on each of these is produced for the previous month ie report presented in April is on March's figures. I've set up the queries using...

Thanks, I was trying to put subs inside subs(which now seems pretty stupid). Kev

As a complete novice but eager to learn I hope someone can help. It's a pretty general thing. I want to press a command button and do 3 things. 1 Save the current form record 2 show a message box 3 Print a report based on the current record. As I say I'm kean to learn and have figured out the...

Overview I have constructed a Database for the recording of processing information ie date, received amount, completed amount reasons for non conformity etc. At the end of each month I am required to produce a report to show date, received amount completed amount incorporating totals and...

A few people have told me that upgrading and converting Access 2 dbs to Access 2000 can cause some problems with existing queries and reports. Anyone confirm or refute this? Thanks in advance

very much a vb novice but managed to get it working with the LIKE '* command. Thank you.

I have one form which contains a seperate record for various cost codes and their meanings. I also have a separate form whose records detail those people allowed to authorise funds to certain cost codes. On inserting a button to link the two fields(to filter and display the records of only...