Search results

i have a table of data that i need to know, the top 10 issue by time (exp1) grouped by Line, so i need the top 10 issues for Every line Please help cheers Andy

what a muppet!!!! i have attached the wrong spreadsheet no wonder people cant see the calculation..

I am so interested to see a solution to this little problem…i think ithis is one of my more complicated questions!!!! Problem: Where I work we have a series of machines… named “ C1, H7, H8 etc” Each line has 3 counters on it, Impressions – records the number of cartons used on the line...

i have looked at this all morning and am getting nowhere fast, any further tips please.. as i was not very clear in my first description here is how i believe it should have read... Can i have a label appear if a value in my subform is null. i have a report called "ModelFinalReport" which...

sorry "Report"

Can i have a label appear if a value in my subform is null. i have a report called "ModelFinalReport" which has a subform called "ModelFinal" And in that subform a textbox called "VAT" i also have a label on my main form that i want to appear if the text box "VAT" returns a null value. but...

i have a report which i need to make certain results displayed in Red, if there is a check in the box. example: my report is called OEEModel on the form i have a chkbox - called "FailureModeInPlace" i also have 2 text boxes called "EventCode" and "CodeDescription" what i want to do is for...

i need to total some data, but only if the code contains 4 digits. by this i mean. Code --> A101 ----> Occur 35 Code --> A101A ----> Occur 1 Code --> A101B ----> Occur 5 Code --> A101C ----> Occur 3 Code --> A101D ----> Occur 5 Code --> A101E ----> Occur 5 Code --> A101F ----> Occur 5 the...

i want to try and get a better understanding of VBA, i don't understand public, private, global etc... where i should put what and where... what i can use what i can't use.... error handling etc.. is there a good website, book or refernce point that explains from scratch how to use and write...

i have a query that uses data from a series of tables, the trouble i have is that if one of the tables is null i don't get any data returned. current query: Dtime: [Mktbl_otherDTime]![Other]+[Mktbl_UnacDTime]![Total]+[mk_tblBreakdowns]![Breakdowns] example: if i have data in:-...

i have no idea what you mean, any chance of elaborating on this please, it worked fine in Access 2K, but has to be in 97. I will attach my DB for you to see.

i have been working on this project all week and now it is almost ready to use i am having problems after saving the file to a previous version.. it was designed in Access 2K i need this in access 97, so i saved it as a prior version of Access and opened it and debugged it and saved the...

no to be honest, how should i do this please

it is not the label that i am struggling with to be honest, it's the items in the list boxes..

ok great i have that working, not sure if i should start a new thread for this now or just keep this one going ? (Please Advise) i now need the user to make a coice from one of the visible list boxes, the trouble is i am not sure how this will work: if you select the total time option the...

i want the user to make a selection from one of two option boxes, with the choice that they make i want a list box to appear straight away, depending on there selection, can anyone help please. Cheers Andy

is there a way to output a crosstab query to some kind of report, either a built in report or a Word doc. i have searched for ages but just want a simple tool to do this.

cheers, but i have browsed through the forum, and searched for elinking but cant find the example... anychance you could post the link please cheers Andy

i want the user to be presented with a choice of which database they want to open.

Can I, create a form, with 2 buttons on it.... one to choose Dept A Database the other to open Dept B database. the management of the company want to look at both databases, thought this might be the easiest way of doing it.