Search results

I would recommend that you use a PIM such as Outlook or other calendar type applications (web based GMail and Yahoo Mail have these features). Putting them into a database will make them a little less accessible as the web based options out there. If you are looking to coordinate cost and keep a...

Have you considered ASP since you are going to have to run either IIS or Apache to get to it? The Visual Studio Express WebDev is something that can assisst you. http://msdn.microsoft.com/vstudio/express/

Look into cascading as that is exactly what you are looking to do. It will have to use a slight bit of code, but its not impossible. You need to use the after select or after update as the trigger on the first group and then populate the second group based off of the selection in the first...

1. Put all three tables into a query. 2. Establish the proper type of join on the code field between them. 3. Use defined fields to summarize the fileds. Your example has left me a little in the dark on how these items relate. You have ABC in there a few times and I cannot determine the logic...

HA Got it finally to order up properly in a cross tab query. I now have it in the fashion that I need it. Trouble was too many records processing at once and not the proper initial settings.

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

Much appreciated I have attempted this but I need to rethink the entire setup. It seems that the more I think on it the more compicated I make it and the worse my head hurts. :rolleyes:

Thanks I appreciate the response, but that was a little off base. I am not worried about duplicating them in that fashion, what I wanted to do was alert them to whether or not the record exists in tbl_1 and whether or not they already have it in tbl_2. I know that I can set the duplicates to no...

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

Check out www.course.com and look for the New Perspectives series on Access. I can only say that I love them as they take you from nothing to knowing the system very well. From there you grow.

So far..... Well, I have looked at the example (thanks) and a few more from the MS website that they have for download. What I guess I am trying to get at is this. I would like to structure the tables properly so that I can design a form that would allow for a selection (from all TB) for each...

Close Thanks for the submission, but either I cannot see how the logic can be applied to my situation OR I am just not getting my idea across right. I have attached mock data (ExampleData.txt) and the database with the two tbls. The txt is a reflection of what I receive in print form, and the...

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

I appreciate the thought, and will do that (it was on the agenda). The thing was that I received all of this data in one Excel sheet originally, so I simply placed the O to identify the Owner information within the queries. I will place it accordingly throughout the table. As for the units...

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

Here is the actual code to change the background of the form from grey to green. Add it to the after update event of the checkbox. If Me.Detail.BackColor = 4227072 Then Me.Detail.BackColor = -2147483633 Else Me.Detail.BackColor = 4227072 End If The ME represents the form Detail is...

Glad to have been of assistance. Let me know how it all comes out for you. Sounds like you have it straightened out.