Access Deleting Members (?)

Feb 22, 2007

First I'd like to say I've learned a great deal from all of your posts. I registered today because I'm having the strangest problem.

Let me tell you that I am in no way a programmer, I don't know any code except some basic html. I was asked to take a 2 day class to learn Access (which was a joke) and then build a database for my employer. I think I've accomplished what they need by using every available book I could get my hands on, forums like this, and the help menus.

Our database is very simple. We only have 3 tables, all of which are related by a field we call our "referrer code".

My problem is this -- we've noticed that some (6)of our records are gone. I have no idea why, or when. We run a roadside assistance company. The database keeps track of members. I can't afford for Access to just drop people. The tables are very small, we only have 1,841 members. There isn't any specialized coding, because like I said, I don't know any. I've mostly used wizards to design.

Does anyone have any idea what, if anything, I should look for. I can send or answer any questions that might help you help me.

I would appreciate anything you have to offer -- even if its just a place to read something that might help.

View Replies


ADVERTISEMENT

Access How To Find Members Who Have Not Paid In A Query

Mar 16, 2005

anybody help please

I have list of member in the member table, every month each member makes a payment (monthly fee) as they do they get entered into the fee table how do I find out the members who have not been entered into the fee table (which will show they have not paid )

thanks

View 11 Replies View Related

Deleting All Entries In MS Access

Aug 23, 2005

hi,

i'm building a MS access DataBase for my customer. in between i'm always testing if it works fine (VB code, DB connections, etc.). But at the end, i would like to have DB empty of those test entries.

what is the best and savest way to delete these entries (so non of the traces are left behind)?

thank you.

View 7 Replies View Related

Permanently Deleting Entries In Access!

Dec 6, 2005

When i enter entries into Access, and then they are deleted, for some reason the size of the Access Database doesn't reduce in size. I've only just noticed this as i accidently entered over 65000 entries in and then had to delete them now the database is twice it's usual size.

Can someone please tell me how to reduce the size of the database and explain why when you select delete record it doesn't actually delete the record.

Regards,

Donni.

:cool:

View 1 Replies View Related

Deleting Records From A Table In Access

Jul 27, 2006

I want to automatically delete records from a table in MS Access 2002, I want to keep the existing table structure and therefore I do not want to delete the entire table. I cannot find a way to do this through a macro. Any help on this would be appreciated

View 1 Replies View Related

Sum No Of Members Wrong

Mar 8, 2006

I have a query where I am trying to count the number of members who have joined during a period of 12 months from a start date sept 01 to following August 31. Instead of getting the total number of members I am getting totals for each member type. I have 12 member categories identified by [TypeID] but each member has a MemberID (Autonumber). I use Sum in the MemberID Field in my query by pressing the Sigma Button. When I run the query I get totals for each TypeID instead where I wanted one final Total. I suppose I need to count the records bearing in mind some numbers have been deleted so numbers jump in the Auto Number field. This is quite asic but I cant get it right. Help appreciated!

View 7 Replies View Related

Modules & VBA :: Deleting Worksheets In Excel From Access

Sep 30, 2013

I'm exporting some data from an Access Database into an Excel Spreadsheet to create a report in Excel, and I'm running into some problems with that.

The idea is I have an Excel Template with a tab to take raw data from an Access Query, and then a couple tabs that manipulate that data and a final tab to format it for reporting. Basically, the formatted tab uses lookups to find data that's been exported from the query and display them in appropriate columns and rows (producing a result sort of like a cross-tab query but where I've got better control over the presentation of the results). My end-goal is to have this data formatted, to replace all the lookups with hard-coded values data, and then to remove the raw data tab and other tabs with lookup data to have a clean report ready for printing.

It's that last step - deleting all the extraneous tabs that are no longer feeding any equations because I've copy/pasted values over the lookup equations - that's proving vexing. Everything through this point is in the same On_Click event code:

Code:

Private Sub Command0_Click()
'Note: I'm using early binding right now to take advantage of Intellisense;
'My plan is to go back and replace this with late binding once I have code that works.
Dim objXLApp as Excel.Application
Dim objXLbook as Excel.Workbook
Dim objXLWS as Excel.Worksheet
Dim strPath as String

[code]....

I don't get any error messages. I actually have a messagebox thrown up in the code to inform me that I'm getting to the right worksheets selected. (The loop is selecting the worksheets as expected. But when I open the file in Excel... all of the worksheets are all still there, including the ones that should've been deleted.Is there something I should be doing to make sure the worksheet deletion goes through?

View 2 Replies View Related

Selecting Active Members

Jan 18, 2007

Hello,

I have a single membership table that contains two separate date fields,a "StartDate" when a member joins and an "EndDate" when an individual cancels their membership.

I would like to query this table to provide a list of active members between a given range of dates.

For example if the date is set to 1/1/06 through 1/1/06, I will get a list of all active members on that particular day.

Any help is greatly appreciated. Cheers.

View 2 Replies View Related

Tables :: Get All OU Members Into A Table

Mar 4, 2013

I am constructing an Access database and wish to get all the members from a particular OU into a table.

Our Domain name is CORP. The Active Directory Users and Computers shows our domain as "corp.

Under this, there is a folder called "Accounts_User" and under that a folder called "Site-SYD" - This is the OU I want get get all the members from?

View 3 Replies View Related

Search And Edit Members

Apr 8, 2015

I have registered members and groups in my access database and i want to create a search form that enable me find and edit registered members of groups.

View 3 Replies View Related

General :: Access 2000 Table Deleting Data

Jul 26, 2015

I've just joined a company based in Scotland, they are running a multiple user access 2000 database: backend and front-end. Recently they have had an issue where a user inserting a new row in a table, as they do, the record above drops off the table (disappears/unrecoverable). My first impression has been that this is a DB corruption issue and as such have ran compact/repair.We are running this database on network server:

-Backend resides in central location
-Frontend - Each user has their own front-end, storded on their personal network drive.

Would I be right in saying that the best solution would be to convert to newer version of access ?

View 3 Replies View Related

Deleting Multiple Records From Access In Datasheet View?

May 15, 2013

When I highlight multiple records and choose delete, it only deletes 1 record.

Is it possible to delete more than one record at a time?

View 2 Replies View Related

Access VBA - Crosstab Tables Into Forms / Deleting Blanks

Aug 1, 2013

I have a crosstab table that is displaying in a form within a form because the form has data coming from multiple tables.

Crosstab Query looks like
Name Sum Cust1 Cust2 Cust3.....
Jon 50 250
Bill 100 50 100
Kevin 200 50 100
Ryan 10 500

The issue are the blanks in the rows for each Name. When I bring it up on the form, I want the columns to be the Customers but only customers with amounts. The original form is there to show the name and position and the form within the form should have 1 row for name of the person that is being selected and columns of customers WITH A BALANCE.

View 1 Replies View Related

(query) Move Old Members To Another Table

Aug 25, 2005

Hi all,

My database is a simple membership database that adds members and by clicking of a button it tells me the memebers birthdays for the month and if i chose to select the send card option then it remembers who has been send the card.

All i want now is a query that will take a member who's memebrship has been expired (since membership is year long only) and move them to another table by looking at the membership dates (like 2004 and 2003).

And may be later on if those members wants to join the membership i can then add them again from that table back to the main table.


I hope i made my self clear enough.

Thanks alot

View 4 Replies View Related

Display Members Picture In Report

Apr 30, 2005

i have a table calle "tstaff" and one of the fields in it is named "picture" which hold a link to the picture of the staff membe, the picture is stored on my pc, not in the database.

so in the picture field would be something like this...

Picture
c:documents and settingsall usersdocumentsmy picturessample pictureslue hills.jpg

what i am trying to do now is to create a report that displays all the patients data, including the actual picture that the link refers to...

how should i do this please

cheers

Andy

View 10 Replies View Related

Forms :: Delete Inactive Members?

Jan 9, 2015

I have created a database containing customer records and i wanted to somehow add a part where an individuals records will automatically be deleted if they are not active for 3 years+

View 6 Replies View Related

How To Handle Duplicate Members In A Table

Oct 7, 2015

I am putting together a "Clients" table, what is the best way to handle Clients with the same name.

For example:

Here are a few fields from my "Clients table":

ClientID
Fname
Mname
Lname
DateOfBirth

I was thinking of making a unique index for first and last, but then i thought, what if I come across 2 John Smith's?

I am sure there is a professional way of handling this, but Im not sure what the norm is.

-SHould I make a unique index for Fname, Mname, & Lname?
-SHould I make a unique index for Fname, Lname, & DateOfBirth?

I would like to know what is the norm when storing people in a table and the best way to prevent duplicate clients from being entered.

View 5 Replies View Related

Mail Merge From Database To Multi Members

Jan 3, 2006

Hello,
i am creating a database for a membership of my martial arts academy, so far i can add and search members.

i would like to have a mail merge feature on this, so that i have a list of all the people with a check box next to their name, if the box is ticked their name is added to the mail merge. if its not ticked its not added.

All help is much appreciated.

Aaron.

View 4 Replies View Related

Adding Payments Due For Family Members In Query.

Sep 28, 2005

Hello,

I have a query that lists members who have outstanding payments. The results of this query are being used to populate a winword mail merge document.

The problem with this query is that if there are multiple members from the same family who owe then I will get an entry for each of them in my query results. What I would like to do is add the amounts due so that I only have 1 entry for that family. Additionally, since it is possible that more than 1 person can have the same last name and not be related I would also like to have the query check the address field and if it's the same than add the amounts due. The following is the sql statement for the current query.

SELECT Members.FirstName, Members.LastName, Members.ParentsNames, Members.HomePhone, Members.PaymentDue, Members.Active, Members.MemberDues, Members.FamilyAmount
FROM Members INNER JOIN MemberTypes ON Members.MemberTypeID = MemberTypes.MemberTypeID
WHERE (((Members.PaymentDue)=Yes) AND ((Members.Active)=Yes))
ORDER BY Members.LastName;

Any assistance would be greatly appreciated.

Regards,
Chris

View 4 Replies View Related

Printing Daily Report For Existing Members

Aug 11, 2015

I have a kids club which do lots of functions for kids, to monitor the members and who is in and out I did a small access data base with details of Start date of the function and end date for each member.

I want to make a daily report showing only the active members in today date only for example:

Jack have swimming every Saturday, Monday and Wednesday Between 14 July 2015 till 14 August 2015
Jill have swimming every Sunday, Tuesday and Thursday Between 14 July 2015 till 14 August 2015

today is 11 August 2015 and I want to report to mention just who is active today only.

View 3 Replies View Related

Deleting All Related Sub Records When Deleting The "main" Record.

Apr 12, 2008

I have two tables.

1. Persons (list of persons)
2. Job history (list of jobs)

each person have their own job history. all these jobs are stored in the job history table. when i delete a person i would like the job history for this person deleted as well. each job stored in the job table have a field with person name, so that it is linked to this person.

how can i do this? vba or simple properties options?

- Roy

View 1 Replies View Related

Queries :: Count Active Members Grouped By Month

May 5, 2015

I am trying to get active member count by month in MS Access.

Table looks like this:

admin ID firstName sDate eDate 1 Adam 01/01/2015 01/04/2015 2 Ben 01/02/2015 15/04/2015 3 Carl 01/02/2015 13/03/2015 4 Don 13/01/2015

Required output would be like this

2015-Jan: 2
2015-Feb: 4
2015-Mar: 3
2015-Apr: 3
2015-May:1
etc..

I got this far:
SELECT DISTINCT count(a.ID) as mCount, year(dimDate.Date) as [Year], month(dimDate.Date) as [Month]
FROM admin AS a INNER JOIN dimDate ON (dimDate.Date >= a.sDate AND dimDate.Date <= a.eDate) OR (dimDate.Date >= a.sDate AND dimDate.Date = null)
GROUP BY year(dimDate.Date), month(dimDate.Date)
ORDER BY year(dimDate.Date), month(dimDate.Date)

Query4 mCount Year Month 31 2015 1 71 2015 2 44 2015 3 13 2015 4

View 2 Replies View Related

Queries :: Printing Daily Report For Existing Members

Aug 11, 2015

I have a kids club which do lots of functions for kids, to monitor the members and who is in and out I did a small access data base with details of Start date of the function and end date for each member.

I want to make a daily report showing only the active members in today date only for example:

Jack have swimming every Saturday, Monday and Wednesday Between 14 July 2015 till 14 August 2015
Jill have swimming every Sunday, Tuesday and Thursday Between 14 July 2015 till 14 August 2015

today is 11 August 2015 and I want to report to mention just who is active today only.

View 8 Replies View Related

Reports :: Members Database - Show Payments Of Yearly Subscriptions

Jun 27, 2013

I have a members DB that apart from full details also show payments of yearly subscriptions. I am trying to print a report that shows a list of all the lapsed members. sounds like a simple simple report, BUT...I have a table that includes male and female members on one club number, idealy man and wife, but if for some reason the part company one may not pay the others subs those making the other a lapsed member. is there anyway i can print one part without the other?

E.g. this is haw it prints now

Male Name Paid Female Name Paid
J Smith No M Smith Yes

and this is what i am after

Male Name Paid Female Name Paid
M Smith Yes

View 1 Replies View Related

Forms :: DCount / 2x Criteria - Counting Family Members Under 16 Years

Jan 13, 2014

Using MS Access 2000

I'm building a customer management database. Part of which is a table to record details of all members of the main customers family or the household compliment.

I'm currently using a DCount to work out how many people on the table are related to my client, to work out the size of the family.....

=DCount("MemberID","tblHHMembers","CustID = [CustID]")+1

Could I also then count the members of the household that are under 16 years old by looking at the DoB from the same household members table?

I realise that I'd need to ask access to calculate age at the same time as working out if they're under 16 and then count them if they have the same Customer ID - which might need a little more than this single function!

View 2 Replies View Related

Queries :: Count Number Of Society Members In Particular Postcode Area

Sep 16, 2013

I have a query to count the number of society members in a particular UK Postcode area. It works well for a single Postcode reference but adding further references to the Query Design View generates an 'or' or 'and' statement, rather than the additional counts that I need.

The SQL code I use for a single reference is :
SELECT Count([Mail List].[PostCode]) AS CountofPostCodeH
FROM [Mail List]
WHERE ((([Mail List].PostCode) Like "BN5 ???"));

How do I amend this code to produce counts for multiple references in one query.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved