Search results for query: *

Hi Everyone, I have a really sticky problem with a cross tab query that I am developing for a welding department. I want to split the column Heading into two "sub columns" depending on the value Column having a certain criteria. Let me explain: I have a CT query with the follwong...

Hi folks, I have a question, I hope that you good people out there can help me. I have a list box ( called SYSTEMS) which I use to limit the contents of another list box ( called Valves). The row source of the listbox "VALVES" is based on a query that relates the valves to the...

Hi everyone, I orginally set up my reports so that they fit on an 11.7 x 17.7 paper ( because my bosses wanted it so). Now they want to know if they can have the option of resizing the report to fit unto a normal letter sized page. But I Don't want to give them design rights to the reports...

Hi everyone, I need some help on this please if you can, I am trying to find a simple, elegnat way of coding so that I can use the selection criteria in combo boxes and a multiselect list box to create the criteria for a report. I have two combo boxes called [SelectStatus} and [Priority] and...

Hi and Help Please, I have a form (called SelectionForm)with two combo boxes and one multiselect list box that I use to select criteria to open a report (called Rpt03) via a button.Rpt03 is based on a query that refers to the main table of information. The combo boxes are:[SelectStatus] and...

Can any one tell me how to Diasble/Enable the Close button and the MinMax buttons programmaticaly ? I have a form that can be opened via different paths in the database. Sometimes it is opened in datasheet view and sometimes it is opened in Form View. When it is in datasheet view, I want to...

Hi everyone: I have a problem. I have a combo box called "SelectStatus" as follows: SelectStatus --------------- StatusID ( integer) And a list box called "SelectSystem" as follows: SelectSystem ------------ SystemID (text) The liStbox can have multiple selections...

Hi every one, I have yet another question for the gurus outthere. This is a resuest from some users that I don't know how to satisfy. I have a database that tracks Current assignments ( called "Punch items") for engineers. Engineers belong to several disciplines like Piping...

Hi everyone, Can anyone show me how to use multiple criteria from 3 or 4 different combo boxes as a filter when openinig a form? I want the user to select from the following comboBoxes on a form: ------------ System (text) Discipline (text) Status (integer) Employee (integer)...

HI everyone, This might be an easy question but I'm way past feeling embarrased so here goes... I have a Mainform with a Subform called "Comments". When I change or update the contents of a combobox called "Status" on the MainForm, I want to automatically: a) to take the...

I have a database that tracks the amount of open technical issues in an engineering department. Open issues are called PunchItems. I have a MAINFORM based on a table tblPUNCHITEMS with the following filed: tblPunchItems --------------- PunchItemID (AutoNumber) Title (Text)...

Hi everyone, I'm having some trouble with the pagecount of my report.Please help if you can. My report has the following sections: ReportHeader PageHeader GroupHeader0 GroupHeader1 Details PageFooter I used a report wizzard and the report prints a reading list for several employees and...

Hello everyone, Hope that someone can give me a hand with this problem. SENARIO: I have two tables. Tbl01 is used to store a list of Equipment TagNos and info as to what Areas of the plant the equips are located in. It looks something like this: Tbl01 ----------- AreaID TagNo (Primary key)...

Hi folks, Can anyone suggest to me why I can't edit records on my Main Table when I have opened it up in datasheet view? When I try, the pencil icon changes to a circle with a line through it. I presume this means that the records are locked.I can only add new records. But: a) I am the only...

Hi everyone, I'm throwing out this question again hoping Someone has a helpful answer: I have a form in continous view and I want to set the Eabled property of two fields in the CURRENT RECORD to fasle if a checkbox the same record is ticked. The underlying table is like this TblTwo...

Hey guys once again, anyone's assistance would be greatly appreciated. I have a subform (in Continous form view) based on a table with fields like this: tblTwo ------------- EquipId Issued IssuedTo IssueDate RequisitionNo Returned( THIS IS A CHECKBOX) ReturnDate ConditionOf Equip etc, etc...

Hi everyone. Please help me if you can. I have a form ( called "IssueDetailsFORM") in continuous view that shows all the issue details for equipment that has been "issued" ( ie taken from stores). The same EquipID can have several issue records. The underlying table for the...

Hi everyone, I have a dailogue form with a very long multiple-select list box.User selects several criteria from the list box and then clicks on a command button on the form to run a report based on his selections. This bit works fine( thanks to some previous help from this site). Sometimes...

Hi Everyone sure hope you can help me on this... I have two tables. Table one stores a list of all the reading assignmnets ( ie specifications)that persons in various disciplines should read.[Think of specifications as manuals or technical reference books]. It also shows what is the revision...