Recent content by jimmidopolus

Veep It is simply (within VBscript tags): If session("userID")="A" or session("userID")="B" then... Given I have got it to work on other machines, I've ruled out the bug in the code. It's difficult for me to recreate because I'm a few hundred KMs away...

I've set up a site using ASP vbScript pages with an MS Access database for only a few users. User logs in according to values stored in database table and sets their userID as a session variable. The restricted pages work by only allowing access using a vbScript IF statement: If...

Think INT(MONTH(E11)/3)+1 will cause errors as december will be month 12/3=4+1=5. I meant to write earlier but mis-typed: ROUNDUP(MONTH(L24)/3,0) sorry for my errors james Regards james

OK don't know what you know so am just going to try and fully explain. I am no expert though as you can see from the lack of stars! When a date is typed into Excel, it is converted to a number and then the number in the cell is formatted to a Date format. You example, if the default date format...

Can think of couple of ways depending on the way your quarters start. If they start always first of the month, then a simple ROUNDUP(MONTH(L24),0) formula would work. If the Quarters overlap months then use the date codes. For example, we know 1/1/03 is displayed from 37622. Therefore it is...

Don't think this topic has been covered as have read quite alot of the site! Question is regarding exporting over approx 65k records which is above excel's row limit. Current I warn the user and then give the option of exporting the first 65k. Is there a better solution, for example, being...

Have you thought of giving a score to what is entered in the box and then refering it to a select case to modify the query's underlying SQL? If you are just using the 'WHERE' Clause on the same fields you could simply write the following to determine your SQL: eg. strSQL = "SELECT...

All is working again! Simply got away with copying the form and deleting the original. Put it down to Microsoft.

Hi all, hopefully a guru can help me out with this teaser! I have a form in access that I'm using to pass variables through to SQL statements in VBA, so it is effectively a selection screen. To help the User I have used combo boxes which obtain the values from a GROUP BY SQL SELECT statement...

Hi. Hopefully a quick question. I have joined a company running JDE OneWorld as a 'zero client' using Citrix Server. We evaluate data in a MS Access database installed on the client, so rather than exporting to Excel from JDE and importing to Access from Excel, we are hoping to link the JDE...