Search results for query: *

I have a query that runs from a form. In the form I have the option for a user to enter a From-Thru date to print to a report based on the From-Thru dates they entered on the form. My form is called frmSelectResolutionRpt my fields on the form are RevDenDate and RevDenDateThru. WHen I use...

I have two cells that have time in them. I want to be able to calculate the difference between the values. For example cell A1 has 14:45 in it and cell B2 has 15:10 in it. I want to subtract the difference and return a value in cell A3 of 25minutes. How can this be done in Excel? Thanks...

Is it possible in Access to have the user create their own reports? I have say 10 fields in my database and some users want to only show 3 of the 10 fields on the report but then other users want to see totally different fields on the report. Is there a way to list all 10 fields on a screen...

I have a form and at the top has the following fields: AdmitNumber Admit Date Discharge Date Patient First Name Patient Last Name Then I have a tabular subform in the middle that has numerous fields where the user can enter data. They can add records to the Admit Number fields at the top and...

I have a question. In a query how do you get a field that has null values but also may have a value in it to show everything on a query. For example I have the tables/fields listed below. I want to list by using a query the Locker ID/EmpLastName/EmpFirstName. In Table1 EmployeeID is null or...

I have five fields example field names are ActiveCombination, Combination1, Combination2, Combination3, Combination4, Combination5. I want the user to Enter a combination and then display only that combination on the report. For example I enter at the prompt 'Enter Active Combination' and I...

I have entries like this on a form Combinations: 49-05-21 42-48-14 37-43-09 Each of these is in a little window on the form. Only one of these can be active so I wanted to add check boxes below each combination. Would that be the best way to go. The user wants to display which one is...

I have a database that has 600 records in it. The user has not populated anything into the Department field. I need to write a select query to allow the user to enter a Department at the time of running the query. So I used in the Criteria Like [Enter] & "*". But when I run the...

I have this code in my form it works great when the user tries to change something in a field that already has a value in it. The field is numAdmitNumber. But my problem is when the go to enter a new record and the enter 123 in the numAdmitNumber then tab to the next field and they realize the...

Is there a way to only have this message display when they try to enter something into the numAdmitNumber? When I tab or hit enter to go to the next field on the form the message "No Changes Possible" displays. Which they have not really entered anything new into the field but they...

I have a command button 'Add Record'. When I click on it I need to have the cursor or pointer go to the strAdmitNumber field on the form. How can this be done? Thanks, Todd ttorfin@dakcl.com

Is there a list someone can give me of the background colors and forecolors values? For example a value is backcolor=255 255 is red 0 is black. Some values are 65536 which shows as green and 1672553 shows as red. If someone out there has a list that would be great to get. Thanks, Todd...

I have a form MyForm that has a field on the form called numAdmitNumber. I want it so that the user can only enter into this field when adding a new record to the database. When they first come into the MyForm it comes to the first record in the database. I want the field numAdmitNumber to...

I want on a form to default in today's date when I first enter the record, but when I come into that same record tomorrow to edit the record I want the date in this field to then stay as yesterdays date not update again with today's date. For example I enter a new record today and the field I...

If I have a field in my database that is the user name, I want that user name to be able to be entered into only on the first entry into the record. For example I enter a new record in the database and I have a field in the database called Initiated By that will contain the users name who...

I have an access database the key is admit number/requestor/review type. The users wants to be able to from the switchboard click a button for Add/Edit Database. When they click this it will bring them to a screen where they can enter in an existing record in the database and edit it from this...