Search results for query: *

I am new to NT and need to create a login script to only allow guest users to login in the local machine name. Also I need to limit the applications the user can run. Please send me a sample script if possible. Thanks Zelda

We have a form to track services provided. The goal is to have the focus sent from one sub form to another if certain entries are choosen from a combo field. The code we are using is below. We are able to receive the info message, but the focus remains on the combo box. If this is not...

I would like to keep my forms from resizing. Once a form is opend and a command button opens a smaller form, my main forms are resizing once the receive focus again. I have seen other post. But they are not working for me. Have tried these settings: Auto Resize=No Border= Dialog or Thin Modal...

I have a form and subform. The subform is to a many relationship table. How can I limit the input on the subform to only 3 records. Subform is a continuous linked form.

Hello all, Can anyone direct me to a site that could help me with developing forms for low vision or physically challenged users? I need to ensure that my forms work with screen reading packages and are easy for quadriplegic users.

How can I pass two fields that I use on my login form to every filter other forms that are opened by a userID (multiuser environment). After login, a switchboard form is opened and the login form is closed. The two fields on my login form are: [txtUserID] [txtUserNumber]

I have an Entry form that writes the control names of unbound check boxes to one field [svcResult]in a table [tbl_serviceResponse]. Each record is linked by responseID (many)to Services Table (one). How can I reverse this to display the boxes as checked if the user needs to edit the record...

I have a form to track Services performed to an Employer. [EmployerID] & [ServiceDate] track services. On any [ServiceDate] you can have any number of the 21 Service boxes checked (Currently 21 separate fields). I would like to have two separate things happen. 1. Eliminate the need for 21...

I have the following events on a form. The first one checks to see if one field is checked, the other field must not be null. It prompts correctly, but it allows the user to close the form. I need it to remain open and set focus on [OES] field. Private Sub Form_BeforeUpdate(Cancel As Integer)...

I have 3 tables, one to many join. TblEmployer,(Main Table) EmployerID EmployerName Address etc..... TblServices EmployerID ContactDate ServiceType ServiceCode TblStatus EmployerID Status(Active or Inactive) DateEstablished DateClosed ClosureReason If an Employer has not had any services...

I have a subform which I want to become visible if a check box field is checked. I am using the following Event procedure on the check box. It works if you open the main form to add new records. How can I keep the subform not visible when not checked if you are scrolling through records from...

I have a continuous form, which is filtered by each user loginid. I need a way for the user to be able to select a radio button next to a record, then select command button thay will either open this record in either view only or edit mode. I will have two seperate buttons on this form. Any...

I have a mainform with two subforms. Would like to create a command button that will popup subforms in a seperate form view. And not have to scroll. My forms are linked by [company#]. Please help.

I have a database and need to limit records a user can edit. On records where the user is the author, I need it to enter their author number from a login table. The author needs full access of records they have entered. But they need view permissions on records they are not the author. All...

Hi, I am not that good at Access. I have a table that tracts counselors by [EDCNumber]. In a seperate table, I track ever company the counselor works with. What I need is an autonumber field that adds the [EDCNumber] plus the next number to be used, called [CaseNumber]. EXAMPLE...

I need to find the % of time elapsed from today's date if my start day is 11/01/01 and the end date is 9/30/02.

I need to be speed the loading of forms and data of our Access Appliaction. We are running Access with linked SQL tables (ODBC Connection). We can not use pass-through queries because of the need to update info, subforms and child/linked fields. Is there anything I can do to make this...

I have created a database w/switchboard and menus not displayed. I need for users to be able to create their own custom reports. But I have security set so they can not bypass the switchboard. Is there a way to create this in a form using radio buttons to select the fields. And tell thim to...

I have a report that uses 5 sub reports and is based on 5 seperate querys. Each query is linked to a query [qryDates] that asks [startdate] and [enddate]. When I run the main report it asks for start and end date 5 times before report is displayed. How can I get it to ask only once without...

I have a report that uses 5 sub reports and is based on 5 seperate querys. Each query is linked to a query [qryDates] that asks [startdate] and [enddate]. When I run the main report it asks for start and end date 5 times before report is displayed. How can I get it to ask only once without...