Search results

I was just about to post a question about that (changing a value and changing it back), as I was just reading a little bit about the .oldvalue I will take a look, and let you know. As always, I really appreciate you help buddy!

Also, since the only data being edited will be on the subform, would the on load event be better for passing the field values to variables? Instead of the on close for the me.dirty check, is there an event that would run if the user goes to the next record, closes the form, etc?

Hey Adam! I was hoping you might be lurking around today! Essentially, this db is fairly simple... It tracks historic pricing of our parts. So when we need to update the exhange rate on parts sourced from out of country, or if the duty cost changes, I don't want to have to re-enter all the...

Hi All, As the title states, I need to find a way to check if changes were made to a record, and if they were, save the info as a new record, leaving the original untouched. I would guess this could be accomplished using the on dirty event and perhaps some "insert into" sql, but in reading...

Ok, so I haven't managed to get it working... And when I try running it as a straight query, it takes forever, and doesnt do anything. So, I have re-written the module, and broken what I need to do down into 4 simple make-table queries, and to run the sequentially. Then I will just create a...

What he said. It's really easy to use.

Unfortunately, the tables I am accessing are ancient, and store the date as text in the format yyyymmdd. How do I put a stop in?

No, its not fixed. I'm trying just to simplify the query first and get that to not take forever to run, and then I will revisit the Module. I like that mySQL trick though, thanks!

Option Compare Database Public Function ProductPerformance() On Error GoTo Err_ProductPerformance Dim ReportThisYear, ReportLastYear, ReportMonth, ReportStartDay, ReportEndDay ReportThisYear = YEAR(DateAdd("m", -1, DATE)) 'get the year, from (today's date -1 month) --> this...

Ah.. I realize after I posted it that I copied from the VBA editor, not the nicely formatted word file I had. But that may be part of the issue... the tables I am calling from are old, and most fields are text fields... including the TRANSACTION_ID... but not SALES. I will try that. NOTE: I...

Hi guys, I created this module, and when I try to call the public function ProductPerformance, I get a datatype mismatch error. I'm hoping a fresh set of eyes might help me find the issue... Option Compare Database Public Function ProductPerformance() On Error GoTo Err_ProductPerformance...

Nope, that's not it. Access didn't like the relationships between the tables... I got the following error message: "The SQL statement could not be executed because it contains ambiguous outer joins. To force one of the joins to be performed first, create a seperate query that performs the...

I think I figured it out... FROM ((([19a) unique_lineup_shared_vehicle] LEFT JOIN (DWP_D_PART LEFT JOIN DWP_F_PART_INVOICE ON DWP_D_PART.PART_SID = DWP_F_PART_INVOICE.PART_SID) ON [19a) unique_lineup_shared_vehicle].PartNumber = DWP_D_PART.PART_NUMBER)...

I forgot to put the brackets in, but yes... DEALER_SID was causing all the problems. As soon as I took it out, the query ran perfectly.

Sure, Brian. Here it is: SELECT * INTO [SALES_BY_ZONE] FROM [ SELECT 'RETAIL' AS TYPE, Count(*) AS SALES, Left([DWP_F_DEALER_VEHICLE_INVENTORY]![PROCESS_DATE_SID],4) & ' ' & Mid([DWP_F_DEALER_VEHICLE_INVENTORY]![PROCESS_DATE_SID],5,2) AS TRANSACTION_DATE...

I am just wondering the proper procedure for nesting JOIN statements... I have a statement that is set up like this: FROM (((table1 LEFT JOIN (table2 LEFT JOIN table3 ON table2.fieldA = table3.fieldA) ON table1.fieldB = table2.fieldB LEFT JOIN table4 ON table2.fieldC =...

It worked! I'm not totally useless at SQL! Thanks for your collective help Aje, Namlaim and Brian! I appreciate it! Cheers, Colin

I think I may have come to a realization... I included DEALER_SID in the Select statement for no other reason that it is the field that the tables are joined on. I don't need to do that do I? :eek: I'm going to try taking that out now...

It didn't like them at the beginning and end, but I put the [] at the beginning, and I saved and closed it, and it changed to a UNION query instead of the MAKE-TABLE it should be.

So I was playing around with the placement of brackets in the FROM statement, and I tried to run the query and got a message saying something about DEALER_SID potentially belonging to more than one table... Was I missing something as silly as a rule that if the three tables share a field, it...