Search results

Thanks for the info and the different perspective on the current issue. I have done some more investigating and found that when adding the index Test01 like I did the searches were in fact very fast but the updates to the dataset were increadably slow even to the point where it would take 1.5...

Adding my 2 cents but you can just make some functions in a standard module that fetches the info from your class modules so the query can get the data. I do not think you can use a class module in queries due to you having to create the class object before using it. So if you make a private...

I believe that's the only way to do that. You need to add something to the before update or after update event of each form or subform to add the necessary value's to the fields to accuratly keep track of who modified and when. One thing you also may want to add just as a side note is the...

Actually I would like to add the table specific's so maybe someone might be able to see something I don't. [Compiled Metrics] - Is the Name of the table [Comp ID] = Autonumber [Daily Date] = Date/Time (Just storing short date value's here) [Shop ID] = Number [Project ID] = Number [STR...

Hey guys, If I have a table with four fields in a single index that I called "Test01" in vba would I still search for the regular named fields and it automatically pickup on the index or do I need to call that index somehow to properly search the index? Sounds silly but any help is greatly...

The issue is with the Automation object. Try addapting your code using the code I posted above and see if you get different results.

Most of the applications that I have built if the table grows several thousands of records every day then I typically will pull the date out of the main table and have it referenced but only for filtering speed. It's far faster to filter 1 million + records on a date field if it's just...

The same situation would apply if you code did not completly close out of the last instance of excel properly. I noticed in the example code you posted you do not clear/close all the objects that you have used with your excel instance. Keep track in your task manager and make sure it's completly...

Appreciate the secondary info jdraw.

Thanks you actually answered my question with your statement: <I am not aware of any date-specific treatment involved in normalization of data.> I appreciate the inputs.

This error happens when the focus of the excel document gets shifted to another instance of excel. So what I mean by that is lets say I run some code to output to excel then I open up a different excel file. What happens is that file I just opened now becomes a part of my current excel...

Do you have an example of an xml file that you could post?

spikepl I know your going somewhere with that question but instead of storing a date/time field in a main table you would use the Id number from a secondary table that would just store dates and in the main table it would only store a number relative to the actual date. I'm sure you knew this...

Good Day All, I am looking for some good information on how to properly normalize dates in access. I have read many things and have actually normalized dates before in the past but I can't help but feel that there is a specific correct way to accomplish this without having to jump through many...

So here is my fix for now. I created a tmp table to store the combined values of all the affected fields that gets emptied when before the form is open using the following fields. Job ID SOS ZM KEOP Comments Materials And I wrote a function to fill the data: Function BuildTmpRun() Dim...

Sounds good :D I'll try and break the old habbit because it makes sense. Thanks

Thanks spikepl I'll give it some further thought. Also Bob I forgot to mention I use ID as my PK field name bc it's my standard naming convention that I have used to many years. Dunno why it would be bad, if you could shed some light one that I would appreciate it? Thanks again for all your...

So I guess my main question is should I try to concatinate realtime or flatline the data and try to handle it where there is a longer loading time? Or unless someone know's of some flashy SQL that can hadle the operation since the SQL part of access run's on multi-processors (at least last I...

Sorry for that bob and I appreciate your inputs. I know that I have not normalized it completely yet that is true. I normally normalize till it hurts then de-normalize till it works but this is rather a new development and I should have been more stricked on myself as far as the design is...

Spikepl: As for the vba code that was it because all the other functions operated the same way and gave no better results anyway so displaying them would just be a waste but here is my SQL that I am currently using to display the data. And the code earlier I posted on any of the one to many...