Search results

Hi. I have a form with over 200 fields on it. I want to maintain the conditional formatting I've already got in there for specific values. I also want to add conditional formatting such that all the fields are greyed out when a new record is created, and they only turn white once data are...

I have a database with 1 primary table containing records for hundreds of individuals, all of whom are identified by 3 unique IDs (they are complete for all records - no blanks or repeats so far): 1) ScreenID is a unique ID I made up for each person, and will remain this way 2) StudyID is...

I have a main form that is really crowded (and already has 4 continuous subforms pointing to separate tables). I need to enter test score data on a second form (not a sub-form - all the data on it come from the primary data table - there's just no room on the main form). I linked it to the...

RESOLVED: Form field - want non-alphabetical display of lookup table values I have a single-column lookup table listing the values that I want displayed in a combo box on a form (we'll be using the same lookup table for multiple fields in the database, which is why I need the lookup table). I...

My team is planning a database that needs to be accessed by individuals whose computers run on different operating systems. I typically use MS Access, but this will pose a problem for other team members. They were hoping to use LibreOffice. I searched older threads, but couldn't find much...

RESOLVED: Relationship not working Hi everyone. I have a database with 2 tables. I set a one-to-many relationship enforcing referential integrity, cascade updates. Table A is the primary table, with "ReferralID" entered as a numbered field (the primary key). Table B is populated via a...

RESOLVED: Cannot add record with newly added value in lookup table I have a database that allows me to select a text option through a drop-down list on a form, where my form field is linked to a lookup table, and the value is then saved numerically in my data table. I just added a new...

RESOLVED: Deleted rows still showing up in background tables Hi. I have a database with a form, which has a continuous subform. I've deleted rows of data via the form, and I no longer see them on the form, and yet they still seem to be in the table when I export the data. Any idea what is...

RESOLVED: Not sure what I did, but it seems to work now. ------------- I split a database, and then afterwards changed the field names in my backend. The new field names are now reflected in the front end, but many of the fields on my forms no longer link properly. When I try to re-create...

I have a database where 2-4 users will be entering data, via a form. They may be viewing the same records simultaneously, but won't be editing the same fields within those records at the same time. In the past, we've had multiple copies of the same form feeding data into a single table, and...

I have a query that pulls together data from several sub-queries. One of the sub-queries may occasionally result in multiple records for the same person. At this point, we are not changing the database to prevent this. We do not want to prevent duplicate records - we need to see the...

I am creating a form based on a table which has meaningless field names (except for data analysts), but the field descriptions are detailed and would be very helpful to include on the form. For example, the field name might be "I_A", which means nothing to those who have to enter the data into...

I have a database with multiple users. They've requested a specific date format to ease data entry. There are many dates to enter, so I'd like to help them with this. In earlier development of the database, I found that regardless of how I set up the date input on the forms, the date...

I have a database which will have multiple users. They will enter and view data on a form, which also has a sub-form on it. The form header has a "Search" command button. I know it's possible to change MS Access options on each user's computer, to specify the search options. However, is...

I have a database with a parent table for basic patient information, and a tPatientStatusDates table (data entry via continuous sub-form) which logs, for each patient, the date that they reach each of 6 stati. I'd like to be able to report the wait times between each status type. For example...

My database has a number of reports, and I've programmed it such that people can click on the last name of a patient on any of the reports, to open that patient's record on the form. However, the form is then filtered such that they cannot search for other patients, or move to other records...

Can anyone tell me why a user would get a "DLL function not found" error, when attempting to export an Access report to Excel? I had no issue exporting this report on my own computer, but another user was not able to on theirs. The DLL error message was preceded by an error message about...

RESOLVED: Form option group - single click selects 3 options I have an option group on my form, and it is supposed to allow only 1 selection. It has 6 options. Three of the options function fine - when I click on any of them, only that 1 option is selected. However, the other 3 options seem...

I have a database with a form, and a subform. There's a numeric "status" field on the subform, with 6 options. The subform is continuous, and each of the 6 status options may be logged, for each records. Each time one of the 6 stati are logged on the subform, there is a numeric field on the...

I am working on a database project (not related to the previous one), to store data on repeatedly completed forms for patients. Each patient comes for multiple visits. Each visit, they complete 2 separate forms. I have set it up in the following way: - tPatientID - stores patient ID info -...