Search results

I can walk from my house to my favorite watering hole in 7 minutes. The walk from my favorite watering hole to my house is over 20 minutes. The difference is staggering.

Or forward thinking by the Russian military?

I had a top and end checkup during the week - colonoscopy and gastroscopy. I've reached an age where medical advice is for routine checks - annually for gastroscopy and three yearly for colonoscopy. I've had polyps removed from both ends in the past. Preparation for the gastroscopy is easy -...

And, not understanding the language, your point is?

Too easy to slip on that sort of thing. Me too. Important thing is that the information is right.

I think 2 should be 2. Form bound to Program, subform bound to Program_trainer with a combobox to select trainer

To me, a quarter (timewise) means a specific quarter of the year eg Q3 2021 or Q2 2022. Is the real question, the number of quarters between two dates. So if the start date was in Q3 2021 and end date was in Q2 2022, then the number of quarters would be 3

But not test the code by debug.print GoSub xxx

Instead of recreating the tables with the consequent bloat, you could try to change the field names. If this process is being done daily, there would only be one field to change name.

I've not come across an .MER file before, certainly not in an Access context. From what I can determine by searching, an MER file is a complied MED file created by RSView, and has something to do with controlling factory software.

I have a goto in most procedures On Error Goto ... :)

Depending on your data, the recordset returned from your query could have none, one or many records. Because you have selected a number of fields in your query, each record that exists in the recordset would have the contents of the the fields selected in that recordset. For example, the first...

Try Private Sub chkShowRetired_Click() If chkShowRetired.Value = True Then Me.filter = "[AssetCondition] = 'Retired'" ' <<<<Missing Me.FilterOn = True Else Me.Filter = "[AssetCondition] <> 'Retired'" Me.FilterOn = True End If End Sub

Fine if there is say only two addresses (Billing and Shipping) but what about the case where a customer has multiple depots to here orders are to be dispatched.

I now wish I had not used the example of yearly prices as a date range related price. I did come back to your example of a pricing table which defined for any date range, the price applicable. Negative returns can be handled by finding the price applicable to the order in the pricing table and...

Try using the URL in the backend table linking \\servername\folder\folder\BEfilename.accdb

Pat, if say the particular business has prices which are fixed each calendar year, but differ from year to year, then I cannot see why the price cannot be be determined by the date of the order from the pricing table (PriceID, Price, PriceYear) in any future report. Discounts and any other...

If you really must have an unbound form, open a recordset with all the values rather than having all those lookups.

As your price table enables the of the price applicable to any order because you can determine the price applicable at any date, storing the price in the order table is redundant. Having noted that, I would have probably decided to store the price in the order table to facilitate reports.

You are trying to change a file name to 03/26/2022.....pdf It's an invalid file name if forward slashes are included. Use a dash?