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...

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...

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...

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...

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...

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...

Hello all Is it possible to set a property setting on the listbox control so that the user is forced to select an item from the lit rather than typing in an item. In other words I want the user to be able to only select an item from the list not add a new one.

Hello all I have a subform, that is a continous form, containing controls that are bound to a table. I want to be able to disable the auto update so that the user can add/delete/alter records on the form and not have the changes take effect uptil they leave the form Can I disable the auto update?

Hello all I hope I can clearly explain my problem here... I am working on an Access db that has a table that is linked to a continuous form(actually it is a sub form within a form). Each field in the record set is associated with a txtbox, drop down list or check box. The sub form has several...

Hello all I have a form called x a subform within the form called y the subform y has a header, a footer and a detail section. The detail section has fields that display values from fields within a table record. Can anyone tell me how I set focus to the detail line within the detail section of...

Hello all I have a program that opens a file with the extention of .ben When it trys to open the file it dies on the following code cn1.Open _ "Driver={Microsoft Text Driver (*.txt; *.csv;)};" & _ "Dbq=" & sPath & ";" & _ "Extensions=asc,csv,tab,txt,ben" I changed the...

I have a form that contains several textboxes that are bound to fields in a table. I want to be able to add a cmd button to the form to allow the user to save the values of the textboxes to a record and then bind the textboxes to a new record in the table. At this point the only way I know how...

Hello all I am hoping for some general guidance here I have created a form in access to insert a new record into a table. The form contains 26 textboxs. The textboxes are bound to fields in a table. My problem is that when I open the form the bound fields contain the values of the first...

Hello all I hope I can explain by problem well enough for you all to understand what is going on. I have a form with a sub form, normally this form upens up with the sub form getting its data from a query. There are times when I need to open the form and then teh sub form using a different set...