Search results

Here in lies more questions, like which is the correct record? How do you make the determination as to which one is the current address, why is it in multiple tables, and would you want to keep the records that appear in each table? Wouldnt you want to delete one entire set of records so that...

Make a find duplicates query by clicking the NEW button within the query area. Creat one that looks at zip and it should return each unique zip with a count of its reoccurance.

There are several ways of going about this. I personally would use (seperate) queries with the criteria of IS NOT NULL for the second and third charge field. Doing this would seperate only those records that have something within these fields. Once you develope a way to filter them out, deleting...

Why eactly are there 24 seperate tables? One for each of the states that you deal with? Are each of the tables identical in structure and contain similiar data? If you could give an idea of what type of data is in each of the tables, I would get a better idea of what you would need to do to get...

Sorry about the delay in the response. The holidays really tied things up and I couldn’t access the forums from home. Here is what I have so far. I know the setup needs further tweaking, and FORM 1 will not be the actual name. What I am looking at completing is when they select MISC, a sub...

The runtime is only included with the developers edition.

Here what I hope to acomplish. I have a DB with 3 tables in it that have forms to add/modify data. These tables are..... tblTourny tblDiv tblMem They have a one to many relationship in that order (1tourny - ManyDiv / 1Div - 10Mem&Rank) What I need to do is create a fourth table to house the...

Ok, if this will work for you..... What I did is remove the duplicate fields from the second table and create a lookup filed to the shooters table. then I changed the form by deleting the previous fields and replacing it with the new on I created. Let me know if this works for you or if I am...

Access Microsoft Access 2002 Bible

If everything is working perfect under your profile, then I would have to suggest that you look into the user rights for the directory that you stored the BE on. If they do not have at least read/write permissions for the directory, then access can only work with what the user is allowed.

I have searched the forums, and cant quite find what I am lookng at doing. Some are close, but for the majority of it I see people implimenting way more than what I would need. What I have is 3 tables, all the data entered into them seperatly. I draw from these tables to create the fourth table...

I have been working on a MDB for a friend that would be used to track scores from various tournaments within a tournament circuit. I acknowledge that there should be 1)tblTour-Tracks basic tournament infoo 2)tblDivisions - Many many divisions 3)tblMembers - tracks member information (which is...

Have you tried the "DoCmd.SetWarnings = FALSE" in VBA? Im not positive, but I think that would prevent the message youare talking about.

What your getting at is normalization of the table structure. You would want to try breaking this one huge table into smaller related tables for several reasons. Considering that you say both entities have similiar fields, these would all be in one table. This table would contain the common...

Taking a shot in the dark, I would say export from LOTUS into a delimited text file, then import it back into Access. Once you have it there, make the determinations as to what the table structures should be. IF you want to replicate the LOTUS stuff, then attempt a direct import from lotus into...

I would have normalized it a few steps further. Any field that you consistently see data repeated could easily be stored within another table. tblConsultant ------------- Consultant ID Fname Lname tblDepartment ------------- DeptName DeptID tblRate ------- RateID RateAmt If the hrs for the...

Follow this link http://msdn.microsoft.com/vbasic/atthemovies/ Once you get there, select a movie category. Within each category are several movies that you can watch. They will send you a free copy of VB.NET Standard Edition 2003 when you rate 5 movies. There have been several issued so far...

Hey, just thougth I would post this up here and see if anyone has any critique for it. I am hitting a brick wall on the PIN to APT listing and history, so any suggestions would be helpful. Other than that, whats your opinion on this. I am actually developing it for a friend FOR FREE, so I am not...

Could you possible format the column in Excel as TEXT so that it doesnt automatically truncate and delete the leading zeros?

Put this behind a command buttons ON CLICK - EVENT PROCEDURE Private Sub Command0_Click() If Me.AllowAdditions = False Then Me.AllowAdditions = True Else Me.AllowAdditions = False End If End Sub In this example the command buttons named Command0