Search results

After much trial and error, I was able to almost fully accomplish what I wanted... Almost. I ended up making subforms for the separate queries. Then adding those to the main form. I can now get the values to show and change when the date on the main form changes. I then used the following code...

@RainLover - Sorry for the delay, will upload a condensed version tonight. @Pat Hartman - Thanks for the advice. I am not very good in the aspects of ADO or DAO, but I would like to try your method. What I am attempting to do is run a query based on a date, then transfer the values of certain...

When testing the date, it did not seem to change on the form without a Requery, but I planned on just placing code in the criteria of the query to grab directly from the form. The name T6 really was just for testing and is actually the name of one of the queries. I do plan to change this once...

Ok, so here is where I am: I got the query to run properly by date and produce the necessary values. I have two different approaches I am working on with success: 1) Have an invisible form that first produces a value and is carried over to the subform fields to commit to the table. 2) Using...

It's ok, thanks for trying though!

As an append query or make table query it runs for far longer than 30 seconds.

Actually, that's a great suggestion. I had thought of this at first, but stayed on my current path. I will give it a shot and get back to you. Thanks.

The actual problem is not the tables, but the queries. In most situations you would not store calculated values, but this is one that would be safest to do so. The problem lies within the calculations, if they were simpler, then there would be more avenues in which to rely on and use. However...

I do have control over the back end design. The main problem is these are not my calculations but the companies. I have had a lot of problems getting them to work just because of their complexity. I was able to get a workaround going today in which I use the select queries and populate one form...

It consists of 9 queries.

I had problems with them before being too complex (I was trying to fit them into one query). I then had to go through them and fix any problems. Should I go through them again even if they work while as select queries?

The query is made up of several other queries. The append query itself only contains two fields. I tried each one on their own, but it will just get to a point where it states the DB could not be found... I am using the actual Query to do this. Not quite sure on how I would go about this if...

@RainLover - I tried testing the append query, but continue to hangs regardless. Also tried copying the DB, and then creating a new DB with the data from the copy, as I saw that this sometimes worked for others with the same problem. I even tried a unchecking spell-check options, but to no...

I'd prefer not to add the calculated values either, but there is a chance the DB will need to be converted for use with MSSQL down the road, so I figure to be safe, this should be implemented for now. What I decided to go ahead and do was turn my query into an append query to attach the values...

Thanks Pat! I had thought about separate tables before, but not for this situation. It makes a lot of sense, so I will give it a shot.

I have a few complex queries that consist of several other queries, to produce certain totals. These do work and produce a number. The totals these queries produce are to be committed to a table. Because of the enormity of these queries, I cannot put all the totaling queries into the Record...

I will try your suggestion as soon as I can. The structure of this database makes this table a bit odd. Technically there is one main table linked to several others. The main table records are sought out by date, but also record the UserID for the sake of seeing who input the data. I needed a...

Each has a different PK# associated to each record.

The SQL I posted was actually from the Query Wizard, but it only found the duplicates. What can I put in the Criteria to delete all but one duplicate? Thanks.

That was my thought, but I wasn't sure how to make the SQL in VBA to just delete all but one. My solution, for now, is to change the Index to Yes (No Duplicates), and on the only form that uses the UserID set the Error event to: Response = acDataErrContinue Likely not the best method, but it...