Search results

Can you attach a version of your app; as is its pretty difficult to find out what's going on...

First you can make the effort of spelling my family name properly. Second, what you THING is totally irrelevant: did you bother to try it? I am not sure you even understand what it does and why it is doing it. You thing too much: just stick to facts...

Here is the solution to your problem. I called this query sqlDateIntervals: PARAMETERS prmProduct Long, prmDateFrom DateTime, prmDateTo DateTime; SELECT DateIntervals.Product, DateIntervals.DateFrom AS PrmDateMin, DateIntervals.DateTo AS PrmDateMax FROM DateIntervals WHERE...

I am stuck with this goddamn A2013 that came with Office 365: it's full of bugs! I'll try to contact MS (again) about it. Stay tune...

Read this: https://msdn.microsoft.com/en-ca/library/office/ff191865(v=office.15).aspx

And I add statistical analysis of your company's data, if possible.

Ooops, deleted the wrong post! Anyway here are both versions.

Here is a mdb format: should do the job. Good day.

I FOUND THE SOLUTION!!! This new webbrowser is totally different and of course undocumented... It has no navigate function: rather one has to use ControlSouce = "..." to set the URL! and it works fine!!!! I will clean up the app and post it later today (later for me means afternoon)...

Are you getting the full page then an error message? Could it be that LME pages have some fancy process that creates a problem? Did you try the Market pages form? Here, copper works fine but platinum has a security problem. Don't work on the web browser issue: I will take care of it...

Its not going to be that steep if you by a good ref. book like Access 2013 Bible at Amazon. Once your familiar with Access basics, forms & reports won't appear so complex...

2 - a,b) possible and easy using report feature. You COULD create general purpose reports for letters, etc. But this involves fancy coding in the report.Detail_Format event; leave it for now... 3 - a,b) same as above. 3 - c) Any report style and contents are possible with access. 4 -...

Plog idea is A1! CL: do you like the idea of auto display of market web page? On my laptop, it worked fine but after an MS round of updates, I get an error AFTER the page is properly loaded. Is it working fine on your PC???

Attached is a sophisticated answer to your issue. Since the person entering prices will have to use 2 pcs or go back and forth to find metal prices, I am suggesting an auto display of the web page corresponding to the market/metal. Hope you will like it, as for me it was fun to create...

The metal market place is most probably on the web (is it?). If possible, can you join as many of those sites? In the past (well I am an old timer), I created an app that was reading the NHL sites. Unfortunately, a fire wiped out my lap, its contents and of course the backups (stupid to keep...

I guess I'm just confused on how to put it all together: so am I!!! A screenshot of the Db relations (or even better a dummy version of your DB...) would help and a clear description of events occurring when a notification is received is mandatory.

The solution is a bit tricky (note that I don't understand why you want to do that at the query level...): 1 - Create a new query using the union query as a data source. 2 - Define a column for every select items. 3 - For the date column: select it then right click it, then select properties...

A bit late but... Yes there is a very easy solution: in Detail_Format use a Select Case 'AbsenceStatus' in the Case 'N', set what ever you want like AbsenceStatus.ForeColor to the wanted color... don't forget to reset it to its initial value!!!!

It is obvious that only certain occurrences of Date() need to be changed. Simple question: how many queries, forms and reports are likely to be inspected?

Date manipulation as always been a pain with Access... I found this method and it works fine so... Using A2007, you should have no problems opening the report hidden, set the date range then make it visible. Don't forget that this 'complicated' way of handling dates works independently of your...