Search results

I have 50 different record sets of individuals and do not want the form or report to produce all the data on all 50. Do I use the "wherecondition argument of OpenReport"?

Sample DB attached, purged of actual names and reduced to a sample of records per table. This took longer than I thought because I am very sensitive to personal ID theft. Three questions: 1. I have Access 2000 on one computer and Access 2003 on another. I am using the computer with 2003 for...

Working on it. Due to the tables containing personal information and I do not have permission from individual members to release the information publicly, I am constructing pseudonames and psedo id's. This will take time.

Very Helpful. 1. Consistency will be my first priority. As far as a date in the table names, I have already discovered the error because I have scripts keyed to tables with different dates and see the problem. 2. Repeating columns. The problem of meeting attendance and charges (or not) has...

My statement:"I had to create that because there is no way to download datasheets to check for consistency amongst tables.", was in reference to the Table Design View information. I wanted to capture that information in a spreadsheet file so that I could check Field Names, Data Types and...

The spread sheet I sent are the Design Views of the 4 Tables I am using. I guess the :shrug: term means that you don't consider them to be "structured"? I am using what I have now, but I have a goal of restructuring the database by following text books.

Thank you for your interest in helping! I do not have any accounting training. I am an engineer who has used ACCESS for other purposes and when I inherited this job, I was given many excel spreadsheets with multiple worksheets having inter-related computations, no written guidance, and nothing...

In managing bank transactions for a small charities group, I initially had a spread sheet which I imported into ACCESS and it has become difficult to track and relate deposit and withdrawal information. I decided to start from the design state, using ACCESS textbooks. I have to keep...