Search results

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

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

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

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

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

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

Hello all, Have a problem with my subform. It works fine on its own, but when I try and work with it on the main form, I start getting error messages. I have a feeling it has something to do with event procedures needing to refer to the main form, but I'm not certain. Any help with the...

I am having trouble with a query. I have attached a simple version of a table for your perusal. I think the solution is relatively simple, but I don't know how to do it. What I want to do is this: If a person has any stays of shorter than 3 days, I want the results to show their entire history...

Howdy, I have created a few split multiuser databases in Access 97 that my company has used over the past few years. Currently, we are trying to move everything to a new network server. When I did a simple copy and paste on Friday moving everything to the other server it seemed to work fine...

Howdy folks, I have a rather large form that I created in Access. It is mainly a travel reimbursement form. It has numerous drop down fields for travelers, dates, etc. My problem is, how do I email it? I would like for the receiver to see the "printable version". When I try and export it...

Have something I can't quite figure out. We have a convulated system for our per diems. If a person leaves before 7 am they get paid for breakfast. If they return prior to 7 pm, they don't get paid for dinner. There are a few more conditions, but you get the idea. I have [Begin Time] and...

Got a problem I can't figure out. I will try and explain in my newbie language. I have a list of companies and a very long list of employees who work in those companies. On my form, would want the user to be able to select a company from a combo box. Afterwards, I would want another combo...

Trying to fix a simple problem with some tables. In my department, we recently switched servers and from Windows 98 to Windows 2000. We had a database that got converted somehow during the transition. One person didn't get their computer switched until about a month later. In essence we...

Folks, I am in a rush and don't really feel like developing a data structure from scratch. I am looking for an example of a checkout database. What I have is a need to track 15 laptop computers that are checked out by 25 staff members each week. I want to be able to view Employee history as...

I have never worked with graphs in ACCESS until now. I have a problem with a report I am running. I have a graph based off of a survey question. For the field question 1), the graph currently has the counts of yes, no, and don't know. I am trying to also get the graph to show what percentage...

Query emergency I have a query that I need to complete in the next hour or so. I am trying to find if any 1 customer number has had over 4 billings in over a rolling 6 month period (any order - 6 months later). I can not figure out how to do this. In my query I have 1) Customer Number, 2)...