Activity Stream

To use dynamic default value, code in Observer combobox AfterUpdate: Private Sub Observer_AfterUpdate() Me.Observer.DefaultValue = """" &...

This has been solved. Solution available at https://www.access-programmers.co.uk/forums/showthread.php?t=306443

We would enter approx 10,000 or so records a year where the details only vary slightly but >80% of the content is usually the same as the previous...

I think Allen Browne's article is an example of that. If you want to provide db for analysis, follow instructions at bottom of my post. But why...

Thanks for both of your help. I've tried (in my own way) to incorporate the advice you've given me but I'm just not getting anywhere. Would...

There are several ways to do this.... this is my idea. You have a saved query "SalesInfoforCurrYrPlan". In code, I opened a query to get unique...

Is there any reason to archive data into seperate tables as oppossed to maybe setting the record inactive?

Perfect! You are AWESOME, John!!!!

Tom, always there is a way!... ;) In Form's Load event procedure, you will find this line of code: 'Fill the listbox with the related...

Colin Here is a link that will tell you how to take Mcode (Power Query Language) and apply it. ...

Well, buttons don't have a ControlSource. Again, the DueDate can be calculated when needed in textbox or in query. This calculation can be...

I don't know your table design, but it seems if you had a field in your table eg LastCalibratedDate, you could update that field when the calibration...

Thanks, that works.

I take it that you are doing an Aggregate Query and applying the Max field to the Date field. Do this in a query, but do NOT add any other fields to...

Hi @orange, There is a field in the table that holds the exact amount of days between calibrations for each tool. That field was created with the...

Thanks for the tips. Indeed removing Focus is working too. I see I ended up not using the variable, I started in one direction and ended in another,...

John: Thank you... 'appreciate the additional info. I just finished tweaking the CFT process (multi-select across CFTs) into the OPT process...

I couldn't think of a legitimate way to accomplish this. I updated my process instead to have my archive table names be something specific.

Step back from database and tables and describe in plain simple English what exactly you mean by duplicate. Sme examples to clarify your requirement...

ahuffman24, Just saw this thread. My first thought is you have determined HOW you want to do something, but you haven't identified WHAT exactly...

We need to save it into the table because we need to track when the next calibration is due. Right now, the only solution i've come up with is to...

suggest try this datevalue(now())+format(timevalue(now()),"h")/24 substitute your date value for now()

Please tell us more about this: As for your code/database: You need the complete specification. Trying to work on/develop a database without a...

Just for name sake there are 3 plate set up but in reality all the targets ( _Ct fields) are mix and matched while testing. Coming to the point :...

No. My advice is to NOT save into table. Calculate when needed. Would need code to save calculated result. Which brings you back to dealing...

A couple of thoughts. You declare and set a string variable but never use it. You don't need to set focus to the textbox to get its value; that's...