Search results

I have data that I would like to use within another system. In order for this information to work as desired I will have to "de-normalize" my tables into a single record set. Here is the issue, I have 40k+ records that have the majority of the data I need in a single table. I have directory...

I have a system set up to track the progress on certain items. I import all of the data for all items from another system so as to eliminate unnecessary data entry. This import will occur once a year and will overwrite the existing data. Only a small percentage from the imported records will...

I have created a simple system to track member information. It does include a photo on the form, and everything works better than I had hoped. Now what I would like to do is store the directory path in a table, and then use it in the code to pull up the photos. Currently, the photos are...

I know there are a few topics on this, but none I have found hit the nail on the head. Synopsis: I have two separate systems containing measurements for the same items. A good percentage of them are right on the money in the measurements, but some are way off base. The structure: tblClass...

I have a mdb that I am working on, and have encountered a problem. It deals with junction tbls, and how to bring the data from both tbls into a useable format. In the mdb I have 2 tbls, one containing NC(neighborhood codes) and another containing TB(taxing Bodies). Since there are multiple TB...

Hey all, I am currently looking to make a great database system for use within my community. What I currently have is a mdb with just 3 tbls but will be building from there. I have the normalization down thus far, but wanted to put things out there for any suggestions or ideas to make this a...

Ok, I have one table consisting of 3 fields. Example tblAllFinal Pin Data1 Data2 There are roughly 30,000 records in this table. What I need to do is compare field one to field two, and create a report from my findings. What the result should display is: How many equal: How many off by one...

I have been looking around quite a bit to see if I could find an easy answer (its never easy), but have had no luck. I have an Access system that runs fine in Access2K, but all I get are reference errors in 2K2. Is there a simplistic way to get these refrences to register? Would creating a form...

Been awhile since I have been in the forums, but I was hoping to receive some enlightenment on a problem. I have a system that requires some simple data filtering/cleaning before it goes to processing. I have created 3 queries (the ones starting with ~) and need to have these fire in thier...

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...

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...

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...

There is no major importance to this, but a major amt of curiosity. I noticed under the INSERT then OBECT menu selections, there is ADOBE ACROBAT DOCUMENT. Now, I would think that this would allow for an individual to include a page or pages of a PDF document to be inserted into the report that...

I have 2 reports, which are basically 2 pages that need to stay together. What I would like to do is trigger the second report to print as soon as the first finishes. To help clarify.... You enter 5 client IDs, and the data is retrieved. Now, you go to print and (at this point) its printing...

I know this is going to sound simple, and will most likely kick myself later, but here goes. I am creating a database that will track the history of certain transactions. The data will be imported on a daily basis into the tbl_CURR. I will then run a comparison to the data that was imported...

I am currently developing a system that will be used by MANY depts. and individuals within one agency. What I would like to do is 1 of 2 things. 1. Use the NT domain server (PDC) as a reference for credentials. I would retrieve the logged in users ID from the workstation, then prompt them fro...

Heres (hopefully) a simple one. I have 2 reports, one of which displays data from my dbase, the other is more of a "cover" type letter. What I would like to do is print one then the other. This will be done if only one selection is made in the GIU, but it is set up to accept multiple entries. No...

I am trying to something very simplistic, but cant seem to get my thoughts straight on how to achieve my goal. I have a text box for entering contract numbers on a form. I want the Before update function to verify that the # exists in a table within the database. The form is not based on the...

Heres a bit of a stickler that I have come across. I am exporting data from and antiquated database into a Tab Delimited file. From the file I import the data to Access, no problem so far... Now within the file there are 3 fileds (Field1, Field2, Field3 for discussion). Field1 contains a type of...