Search results

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

This could be done via script, but thats not really my speciality. I would suggest searching the forum for importing from excel since I am sure I have seen something similiar posted in the past. If you cant find what you need, I would post in the MODULES AND VBA part of the forum.

How many numbers per street? How many other per number? Obviously there can be 0 or more numbers to every street, but for every number there has to be 1 street (1 to many relationship). Now, if there can be 0 OR MORE other fields to each number, but only one Number field per other (a possible...

Your simply lookng to return the items with UNEQUAL (<>) prices? I would have to assume that your 2 tables share a common key or unique identifier. You would add both tables to the query with a link between the unique keys/identifiers, then add all of the fields you want to display. Then beneath...