Search results

Hi Folks, I am trying to group all like records together on a form using a unique person identifier (a person can have more than 1 record); that is, to have each page of the input form focus on the records of only one unique identifier person at a time, then to have some sort of break between...

Hi Folks, I have created a program by which a user can enter any given time period (usually 12 months), and generate the top 5 people for that time period. I need to, if possible, automate a process that suggests one or several different 2 week time period(s) that is are shared with all the...

Hi Folks, Below is some code that is attached to a command button. It opens a certain file from Crystal Reports. It works just fine, however for whatever reason; it only opens the report once and will never open it again unless I close and exit out of Access. Any ideas. Private Sub...

Hi Folks, Is there any easy way to tell access not to display information boxes when a code-driven command button is pushed. For example, instead of warning the user that the table will be deleted and that some actions will be ran, is there a way to disable all those info boxes. Thanks a lot...

Thanks Harry, it worked perfectly.

Hi Folks, I have a snipet of code that I am working with, unfortunetly; I don't know VB very well and was wondering how to create a table with this code as oppossed to making and opening a query. The code works fine thus far. ..... SQL = " SELECT * " & _ " FROM dbo_v_claim_ap_pmtD "...

Works with single select, does not work with simple or extended multi-select This is odd: I have created a list box which displays unique values of field1 in table1 and displays them in a subform. I have linked the subform to a query using the context: ([Forms]![Form1]![List0]) The query...

Hi Folks, I have a form with a subform (displays all unique values for a certain field in a table) in it and a macro-driven command button that launchs a parameter-value query based on what criteria the user selects from the subform. The program works well, but I can't seem to figure out how...

Hi Folks, As a non-profit governmental local agency, we must conform to changes imposed by the powers-who-be. One of these changes is our extracts: currently, we receive one extract per business unit. This works very well. However, in a few months, we will be receiving one very large...

Hi Folks, I have a database, which is broken out by youth and adults for a non-profit governmental agency mandatory mailing. If the individual is a youth, I have created a salutation field "To the parents or legal guardian of: (Youth's First Name) (Youth's Last Name) at (Street Number and...

Hi Folks, I am wondering if it is possible to use a parameter(s) in a SQL Pass Thru Query. For example, prompting the user to enter a data range just like a normal access query. Or pulling criteria for a field from a form? I have tried to use parameter queries in SQL Pass Thru Query but...

Hello folks, Any help of this question would be very greatly appreciated. I am trying to create a query that utilizes parameter values. If I assume that a user runs the query and receives a number of user prompt boxes (parameter value) for what selection criteria they would like to use when...

Hi Folks, Something I have been working on, and can't seem to figure out (if it is even possible). Any suggestions would be greatly appreciated. I have a huge table that I am working with (about 10 fields, 700,000 records). The table is stored on SQL Server and I have created a view for...

Hi Folks, Any help or advice regarding this problem would be greatly apprciated: I am focusing on several check-mark box style fields in a table (I have about 13 seperate check-mark box fields). I am trying to create a query that lists how many "YES" answers are in each check-mark box for the...

Thank you very much!

Hi Folks, I have been working on this problem for some time; and would greatly appreciate any help: I have a database which displays individuals and their dates of service (MM/DD/YY) No one individual can have more than 1 date of service on the same day. As I look thru the database, I notice...

Hi Folks, I have a form on a Access 2000 database that is linked to a SQL Server 7.0 table. Everything works just fine and about 300,000 records already exist in the database. If I do a search on the form via a Query by Form, the query does return the results I want. However, when I try to...

Hi, This is very interesting, at least I think so. I have created a form which is used to input data into a SQL Database. One of the many fields is for Social Security Number. All Social Security Numbers are unique except for one, 555-55-5555 which indicates someone who does not know their...

Thank you!

Hi, I have two tables, one table has a unique identifier (Primary Key) and shows only unique distinct rows. The other table has an identifier which is not unique (Foreign Key). Is it possible to join these two tables and display the unique identifier from table 1 with only the most recently...