Recent content by pablotx

More info... Here is the SQL for the first query: SELECT tblScheduleAppt.SchedID, tblScheduleAppt.ContractNo, tblScheduleAppt.DateRevScheduled, tblScheduleAppt.Facilitator, tblScheduleAppt.TimeStamp, tblScheduleAppt.ReviewTypes, tblScheduleAppt.fkRefNo, tblReviewTeamMembers.ReviewerName...

I thought I might put a brief example. Say Peter is the team lead for Review 1 and Paul and Mary are going on the trip with him. Let's say Mary is logged in and wants to look at her calendar. I need to have the results of Peter and Mary, but then also Peter and Paul, because they are related...

I have been trying to speed up a query that takes a long time to run on my users who use a VPN connection with Hotspots. I have an Access front end linked to a SQL Server backend. I have a table called Review which contains a bunch of information as well as the Team Lead column. There is a...

I am trying to utilize the code from the last message in this thread and for some reason it is not working for me. I have an Access 2010 db that is linked to SQL Server. I can set up an ODBC connection fine for my instance of the Access front end and it works properly. I send the front end...

Hello to all: Hopefully a simple question for you advanced users out there.... I have a main form tracking Deaths [FrmDeath]. It has all of the particulars about a patient's death. On it there is a patient ID # [patientID]. It pulls up the consumer name and demographics on a subform...

Howdy- I work with an agency that reviews hundreds of providers throughout our state. We have a staff of 60 reviewers that travel 3-4 weeks per month to conduct annual reviews of facilities. I am trying to move our agency into the 21st century by automating our scheduling. Currently, we have...

Howdy everyone. Thanks for all of your help in the past. This website is a great resource for designers. I have a pretty broad question. I have been building some ACCESS databases for my department for a few years. They worked great for years as our whole unit was in one area, only had about 15...

Trying to find the examples and haven't had any luck. Does anyone know where to find it? Thanks.

Hopefully a simple question. I have attached a sample of the database with the question. I would like a percentage of compliance auto calculated from the fields completed on a form. Please review and give me your thoughts. Thanks in advance.

Thanks so much. Now what about the comma issue?

Thanks in advance. I feel I should know how to fix the following 2 issues, but can't quite get it. 1) I have a table with Dates in a text field. (mmddyyyy). I want to change the format so that it will display as (mm/dd/yyyy). So I have tried to change the field property to a Date field, but...

I am trying to get both of these forms to work together for data entry. I think my relationships are set right, but somehow along the way, the main form stopped working. Please take a look at the attached and point me in the right direction. Thanks in advance

Thanks so much. It works like a charm. What's funny is that I don't ever recall using that code back when the database was working properly. Thoughts?

Folks, Ran into a problem today that I can't figure out. Should be an easy fix, but it has been years since I designed the database in question. Everything was working fine until yesterday and I can't find the solution. Problem: Subform isn't opening with information from the main form...

One more thing to make this potentially more difficult. The main form that I want the label to appear on is a continuous form. Essentially just a long Excel like lists (log). I only want the complete label to appear on each specific record that is indicated on the linked field as being...