Search results for query: *

Hello all I hope I am posting in the right forum. I have a nec vt770 projector and a Toshiba laptop that I have connected together, All works well with it. The cable connecting the 2 is about 75 feet long. I have added a lcd screen that is connected to the projectors output port. This will be...

thanks for the replys !!

Hello all I need to be able to sort my report by an incoming field called entity_code, this I know how to do but... the entity_code field will have one of four values sess crse prov part If I just order by this field the records will display on the report in the following sort order crse part...

Hello all I have a combobox that uses a stored procedure as it's recordsource. No problems with this in that the combobox is populated with the correct data. By default the comboxbox does not show a value until you click on the dropdown arrow.Is there a way of setting the first value of the...

Hey all To answer my own question I did the following Each row in my form is made up of 7 fields with a label at the top of the form describing what is in the field For example I have a field that containing a status code and the label is called Status_Label The following code will sort the...

Hello all I have continuous form that displays records in a recordset, each record has 7 fields. The user would like to take the records that are displayed on the form and change the order in which they appear on the form(re-sort them) They would like to be able to do this on the fly, as the...

AlexCuse That did it thanks!!

Thanks for the replies, I will play with it and let you know the results

AlexCuse I want to exclude the row entirely if process level low <> process level high,

Hello all I have the following stored procedure ALTER PROCEDURE dbo.hrld_sel_business_units (@PROCESS_LEVEL_LOW varchar(5) = null, @PROCESS_LEVEL_HIGH varchar(5)= null) AS SELECT '0' as 'PROCESS_LEVEL', '<All>' as 'NAME' UNION SELECT p.PROCESS_LEVEL, p.NAME...

Hello all I have stored procedure that I use to bring back a list of employees. this procedure is used at 2 different instances in my app. 1 to populate fields on a form 2 to add employee names to a combo box on a different form I have altered the stored procedure to return a list of...

Boy am I dim witted this morning, after posting I went back and took a look at what I did and realized I did not have the fields in the sort and group the same as the fields in the ORDER BY clause of my SQL, problem solved!!

Hello all I have a report who's data is based on a query. The query contains the following order by clause ORDER BY Dept, SupervisorName, EmpName When I execute the query the records appear in the order that I want. My problem is that the report does not display the records in...

Hello all I have a report that lists training course that have been taken by company employees. The report is multiple pages, breaking to a new page for each new employee id. Each employee has a supervisor_id associated with it and the report is ordered by supervisor_id. What I am wondering is...

Hello all I have a report I am trying to modify currently it has a detail header detail footer and detail section that works well except for one problem. There are instances when the detail section has just enough rows that it will finish at the bottom of the page this forces a new page...

Hey all A really basic question for you I am creating a form in word that will be locked once complete. I need 2 areras on teh form to be edittable by the user. 1) 2 check boxes 2) a text field I have the check box working but can not get the text field to work. Can anyone tell me how to...

Hello all I have form with a series of controls tied to a recordset The first control is combo box that the user can select a name from. The form also has a check box tied to a field in the same record. When the user selects a name I execute a requery, Me.Requery, my problem is that the user...

pampers that was what I was looking for thanks!!

Hello all not sure if I am poosting this in the correct forum but here we go. I have an access application that allows users to generate and preview reports. In the standard preview window the user can then print the report. The problem I am having is that for several of the users is that...

So I set teh combo box property limitto list = yes and yet I am still able to type over top of the selected entry. what gives?