Search results

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...

I am trying to have a label field become visible on the main form when a combo box on a linked form has a certain value. I can make it the action occur if the combo box is on the main form, but when I bring the variable of the subform into the equation, it falls apart. I read through some...

Are ya'll talking about the Robert Trent Jones Trail? If so, I played about 8 of the courses a few years back. Loved it. The Judge and Legislature ate my lunch however.

Thanks for the input. As I am really a novice when it comes to Access, I need all of the suggestions I can get, especially on how to do the batch process necessary to move data back and forth.

Here is the scenario: I have a bunch of people with laptops who go on reviews throughout the state and leave reports on site with the facilities they review. They go out in multiple person teams and work together on reviews. Currently, each person types out their own citations in MS Word on...

Fernando, Works perfectly. I definitely agree with you about the database normalization. The example we have been working on was just so I can test a particular theory. I do plan on spending a fair amount of time on setting up tables and relationships when I begin the project. Thanks for...