Search results

I've got a combo box that lists duplicates. I want the dupes removed. I went to the Query Builder for my Combo Box and set Unique Values from "No" to "Yes" - Saved, then re-opened the form. It still lists dupes. I went back into Query Builder and unchecked the box for the Patient_ID...

I work at a small mental health clinic and am trying to accomplish the following. Access skills a little rusty, it's been a while. What I have: I have one table that lists all of the patients, their phone number, address, etc. In another table, it lists the medications that each patient takes...

We have a database that was being used with a psychiatrist office program, but we aren't using the program anymore so we've stripped the database. We want to create reports with it. The database has three tables: Drugs, Prescriptions, and Patients. Drugs has two columns: drug_id and drug_name...

Hello, I have a table that contains a bunch of records, the fields are Employee ID, Task, Date and Vehicle. All I need to do is create a report that will list all records correlated with only a single employee. For instance, when I open the report, it asks for the Employee ID, you enter it...

this should be an easy one. Not sure why I can't figure this out. I have one table, Leopard Test Scores 2007, that has only two fields, employee and total. The total column has a "Date/Time" data type with a short time format. All entries in the total are in the "mm:ss" format, e.g. 03:23...

I have switchboard that contains command buttons to access many forms. I have locked down the forms via password using the following code for each form: Dim PassWord As String PassWord = InputBox("Enter Password") If PassWord = "MyPassword" Then ' Open Form DoCmd.OpenForm...

Firstly, thanks everyone for your help. I have a form that Employees will use to input certain jobs they have done throughout the day (e.g. mowing, raking). One record in the form represents one task that one individual has done. We can get several records from a single employee in a day...

Hey folks. I need to build a report that will allow users to pull data between TWO dates. I do have a query that will allow users to pull data by inputting a SINGLE date, which I've described below: I have a report that displays the User ID, Arrival Time, Departure Time, and Job ID, and the...

I have three fields in a form. "Starting Miles", "Ending Miles", and "Total Miles" I want the "Total Miles" field to automatically calculate the difference between Starting/Ending miles fields. So if starting miles is 2000 and ending miles is 2200 I want the total miles to list 200. Thanks.

I have an old table that has many, many records. One of the columns lists the Date of Birth. Here's my problem: Users have entered data into this column as "71462" This representing July 14, 1962. Is there a way to automatically format all data in this column so that it is more palatable -...

Hi guys. Could someone tell me how I would go about adding a form field in my form that will automate a number based on two other form fields? To be specific, I have a form that requests Employees add in their arrival time and departure time for a particular job. For instance, If they add 4:00...

Hello, I am new to this forum and have a problem. I have a simple one table/one report database in Access. When I view the report, all data shows up on every page except there is one in the middle that is completely blank - I looked at my table to ensure that I didn't leave any empty rows, and...